Here's a step-by-step tutorial on using the Change Data Capture function.
© Exsilio Solutions 2013
All rights reserved.
What’s on our mind?
Exsilio Solutions is proud to introduce our new blog! Not only is this forum completely integrated with all our social networks, but it is also 100% responsive. Now, you can take Exsilio with you on your phone, tablet, and desktop - redefine what you thought possible!
Understanding Query Execution Plans in SQL Server Management Studio
A baseline on how to start using Execution Plans to improve your query performance.
SQL Server – PIVOT/UNPIVOT Clause
Understanding the benefits of the PIVOT/UNPIVOT Clause in SQL Server.
Pros and Cons of Dynamic SQL
The pros and cons of Dynamic SQL and how to use it.
Setup and Usage of R in SQL Server 2016
How to setup and use R in SQL Server 2016 using the SQL server R Service.
SQL Stored Procedures Best Practices
Understand best practices for SQL Stored Procedures regarding 3 categories: readability, performance, and handling bugs.
SQL SERVER 2016 – ISJSON Function
In my first post, How to load data into SQL Server using JSON functionality, I discussed one of the key functions of SQL Server 2016 JSON support, which is OPENJSON.
Today we will see another built in function of JSON, which is ISJSON.
ISJSON - This function is used to test whether a string contains valid JSON or not. It returns 1 if the string is valid JSON. If not, it returns 0. It returns null if the expression is null. We will check all of these return values.
Configuring Environment Variables for an SSIS Package
For all the devs out there - how do you configure the environment variables for an SSIS Package? Our preference is to create package and using parameters and variables to create two separate environments of the same package. In this post, we'll show you how.
Analyzing Source-Target Mappings for SQL Stored Procedures
If you want to analyze or create a particular job, Integration Services (SSIS) package, or other form of ETL in Microsoft SQL Server, one of the first things you may want to do is take a look at all the stored procedures you are running and determine which ones need to run before others.
Using Metadata to Simplify Database Administration
When creating a database and an ETL process to either load or extract from it, you can help yourself quite a bit by creating a metadata repository. The benefit of this metadata is that you can use it to create data-driven ETL and other processes: instead of creating numerous lines of code for each particular object, you can create a dynamic process which uses metadata to perform the appropriate ETL for all your objects.