LATESTS POSTS
Delete Windows files recursively in cmd
Delete a file in Windows cmd
Download and install the Excel OLEDB 2007 driver
Download OLEDB Driver for Excel 2007 allows to read Excel files from applications using ODBC or OLEDB connections. The driver for Excel 2007 is needed for example to load Excels files from SSIS. …
OLTP and Transactional Databases definition
What is the definition of OLTP or On Line Transactional Processing. OLTP refers to all databases designed to manage the processing of data in a transactional and reliable manner, for management purposes in …
Dimension table definition in Business Intelligence
What is a dimension table in business intelligence? Dimensions are axes of analysis. The same dimensions often come up in the same areas. A dimension is a tree, the objective is to join …
Create a text list of files in a folder in cmd
How to create a list of files and insert it into a text file with a simple command in Windows? It pretty easy, you need to add in the command to redirect the …
Copy recursively files and folders in cmd with xcopy
To copy a single file or many files recursively with windows command prompt, use the xcopy command. The xcopy command is very similar to the copy command but it manages the recursivity and …
Copy a file to another folder in command line
To copy a file to a different location in cmd, use the copy command line in a Windows Prompt. Two main options allows users to copy files in Windows command prompt or batch …
List files recursively in folders and subfolders in cmd
Per default, the dir dos command list all files and folders within a given folder, but not recursively. To display a complete of files and optionally folders within all the subfolders, use the …
Popular Posts
Calculate last month value in DAX with Power BI
How to calculate the last month value in DAX for Power BI? Managers, Financial advisors and Business consultants use month comparisons extensively. To create these comparison measures, use the DAX time intelligence functions …
Create a SQL Server partition
How to create a table partition in SQL Server? Let’s consider a large table with Sales data. So, this table have a column that stores the year of the sale and the table …
SQL Server Pivot example
How to use the T-SQL Pivot function ? Use the SQL Server Pivot example query to change rows to columns with the SQL built-in function ? The SQL Server Pivot query can pivot …
SQL Server Versions
SQL Server is a relational database management system developed by Microsoft. List of all SQL Server Versions Here’s a list of SQL Server versions from its inception, along with their release dates:
List user defined table types in SQL Server (UDT)
How to list user defined table types in a SQL Server database? First of all, users declare User Defined Table Type as a particular table structure in the database. This UDT is reusable …
SQL Server Violation of unique key constraint
How to insert or update data in an SQL Server table with a simple query? Here are two simple solutions to execute an update or insert and avoid errors. The SQL Server error …
Split a delimited text with SQL Server
How to split a delimited text in SQL Server? The string to split can have a comma or a semicolon delimiter. Using an SQL Server query, you can cut a string compounded of …
Arithmetic overflow error converting expression
With SQL Server, how to avoid this error : “Arithmetic overflow error converting expression to data type int”. Let’s insert some data into a table using a stored procedure for example. Facing this …
Check if object exists with SSMS
How to add or remove the object existence checks in SQL creation scripts with SQL Server Management Studio? To add dynamically the existence check before generating the create statement for you SQL Objects like …
SQL Server unpivot query example
How to use a SQL Server unpivot query to transform columns to rows? It’s possible with this simple SQL Server UNPIVOT function example. The T-SQL Unpivot function can do it in one single …
SQL Server table size and disk space
Listing SQL Server table size and disk space can be very convenient especially to analyse the disk usage for each table. Three different ways, but similar are presented here to display SQL Server …
Last updated table on SQL Server
How to check the last date a table was updated on a SQL Server database? Check the last access and update with a simple SQL query? Thanks to the SQL Server relational database …