MariaDB: Running Total and Running Total by Group
Keep it simple :-)
Database Development
SSIS: Check for Errors in SSISDB and Send Email
SSISDB is the database that is collaborating with SSIS. When we execute a package, the execution information is logged in SSISDB. If a job is scheduled, we need to know if there are errors in the executions. As a last step in SSIS package, I run stored procedure that searches […]
T-SQL: NVARCHAR(255) vs. NVARCHAR(MAX) Disk Space Comparison
In some scenarios like ETL or load data into a DB, we need to insert the data into a staging table, where all the columns are String data type and on the next step to cleanse and manipulate the data. I heard a discussion about the data type of the […]
The Intuitive Way to Understand the Zig-Zag JOINing with IIF()
In a real world scenario, we can sale in our online store on standard or discounted prices. In this exercise we use three tables to demonstrate the zig-zag JOIN:
Learn SQL Server Intuitively Transact-SQL: The Solid Basics book is on the way
I am very happy to announce that my first book, dedicated to Microsoft SQL Server from the Learn Intuitively series is now on KickStarter.
The Intuitive way to understand the JOINs in SQL Server
When we write a DML query that is using JOINed tables as data source, first we need to understand the way SQL Server is manipulating the data. The clauses in the DML query statement are ordered as follows: SELECT FROM… JOIN WHERE GROUP BY HAVING ORDER BY Behind the scene […]
T-SQL: Quick and simple Unit Testing of a Stored Procedure with Predefined Parameters
Let’s say that we have a SP with predefined parameters, i.e. @Parameter1 can hold values 1, 2 or 3; @Parameter2 can hold values of A, B, C or D and so on. This script creates all the possible combinations for the parameters of the SP and executes the SP as many times […]
T-SQL: Refresh View After a Change in the Design of an Underlying Object
Very often we make changes to the design of an underlying objects, used by views. After we do this, we need to refresh the views to apply the changes. In this example we will: 1. Create View 2. Change the design of an underlying object 3. Refresh all the views […]