LATESTS POSTS

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 …

List files in folder with cmd
When it comes to listing huge directories in Windows, it’s mandatory to use scripting to avoid a tremendous manual work. Automation is key here, with very simple bash commands windows system can do …
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 …

Delete Windows files recursively in cmd
How to delete files recursively in Windows cmd? I.e. how to delete all files in a folder and its subfolders. Use the del batch command line and the recursive option. The Windows delete …

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 …

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 …