SSIS
Load and manage files with SSIS
Work in progress…
SSAS
Build a tabular Model with SSAS
Coming Soon
SSIS
Load data to Azure with SSIS
Coming Soon
SQL Server
Learn T-SQL development
Coming Soon
How to list files and folders in Linux ?
In Linux, the ability to list files and folders is a basic yet essential skill…
How to copy files and folders in Linux ?
Copying files and folders in linux bash scripts is a fundamental task in any operating…
How to modify a table in SQL Server using ALTER TABLE ?
T-SQL script examples to modify SQL Server tables using ALTER TABLE statements. How to modify…
Pass a list of values as a parameter to a stored procedure in SQL Server
To pass a list of integer values to a stored procedure in SQL Server using…
How to execute a stored procedure with parameters in SQL Server ?
Execute SQL Server stored procedures with one or multiple input parameters. Depending on the implementation…
How to convert a string to a date format in SQL Server ?
Different solutions to convert a date stored in a text to a date format using…
How to create a SQL Server stored procedure ?
T-SQL tutorial on how to create and run basic SQL Server stored procedures. To create…
How to create a SQL Server stored procedure with parameters ?
T-SQL tutorial to create a SQL Server stored procedure with input parameters and T-SQL variables….
How to check if a column exists in SQL Server ?
When working with SQL Server databases, it’s common to need to check if a specific…