In this article, we will talk about sp_WhoIsActive stored procedure and how we can use it to monitor currently running activities in SQL Server.
Monitoring activities using sp_WhoIsActive in SQL Server
SQL Shack
Extending Biml with C# scripts
SQL Shack
In this article, we will explain BimlScript, which is an extension of this markup language with VB or C# scripts.
Converting SSIS packages to Biml scripts
SQL Shack
In this article, we will explain how to generate scripts from existing SSIS packages by showing all related options. Then, we will analyze the generated script and identify how each object is mentioned in the script.
Using Biml scripts to generate SSIS packages
SQL Shack
In this article, we will explain how to generate SSIS packages using business intelligence markup language by providing a step-by-step guide where we will illustrate how to configure each object and how to use variables, expressions and parameters within the package.
SSIS: Execute T-SQL Statement Task vs Execute SQL Task
SQL Shack
In this article, we will give an overview of the Execute T-SQL Statement Task, and we will make a small comparison with the Execute SQL Task which is more popular.
How to get GraphLayout XML from programmatically generated SSIS package?
Stack Overflow
What is the SSIS package GraphLayout? Is it readable in programmatically generated SSIS package?
Getting started with Biml
SQL Shack
In this article, we will give a brief overview of BIML by showing how it can be installed and how we can use it to generate SSIS packages using the BimlExpress tool. Finally, we will provide some good resources to learn this technology.
Manipulating SSAS OLAP cubes using SSIS
SQL Shack
In this article, we will give an overview of the first two tasks provided by Integration Services (SSIS) that allows manipulating OLAP cubes and executing commands over SSAS. These two tasks are Analysis Services Processing Task and Analysis Services Execute DDL Task.
SQL Server functions for converting a String to a Date
SQL Shack
In this article, we will explain how a string to date conversion can be achieved implicitly, or explicitly in SQL Server using built-in functions such as CAST(), TRY_CAST(), CONVERT(), TRY_CONVERT() and TRY_PARSE().
A SQL join on multiple tables: overview and implementation
SQL Shack
SQL join multiple tables is one of the most popular types of statements executed while handling relational databases. As known, there are five types of join operations: Inner, Left, Right, Full and Cross joins. In this article, we will explain the meaning of Joins in SQL, we will describe each...
[Read More]