When moving data in an extraction, transformation, and loading (ETL) process, the most efficient design pattern is to touch only the data you must, copying just the data that...
2020-08-05 (first published: 2020-07-23)
527 reads
A few years back, I wrote a blog post about using an SSIS object variable as a data flow source. In that post, I described how you could load...
2020-07-30
128 reads
For the better part of 15 years, SQL Server Integration Services (SSIS) has been the go-to enterprise extract-transform-load (ETL) tool for shops running on Microsoft SQL Server. More recently,...
2020-07-28 (first published: 2020-07-16)
681 reads
SSIS parameters help to ease the process of passing runtime values to SSIS packages. For values that can change over time, using parameters in SSIS is an ideal means...
2020-07-14 (first published: 2020-07-02)
463 reads
I’m happy to announce the publication of my latest book. The SSIS Catalog: Install, Manage, Secure, and Monitor your Enterprise ETL Infrastructure is now available on Amazon in both...
2020-07-13
16 reads
I’ve been building ETL processes for many years, and I’ve learned two universal truths: data preparation is messy, and you must always secure your data prep area. A data...
2020-06-18
2 reads
Earlier this week, the state of Iowa held its caucuses to choose each political party’s nominee for November’s presidential election. Being the first state in each election cycle to...
2020-02-11 (first published: 2020-02-06)
781 reads
As anyone who reads my blog on a regular basis knows, I’m a big fan of using dynamic configurations, including SSIS parameters variables, to make my ETL architectures as...
2020-01-03 (first published: 2019-12-21)
912 reads
The JOIN() function in SQL Server Reporting Services is a handy tool that allows you to turn a list into a delimited string value. This function accepts two parameters,...
2019-12-22
720 reads
The JOIN() function in SQL Server Reporting Services is a handy tool that allows you to turn a list into a delimited string value. This function accepts two parameters,...
2019-12-22
1 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Zikato
Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
hello , I am looking for a Grafana expert to help me with this...
Comments posted to this topic are about the item SQL Standard Confusion
Comments posted to this topic are about the item SQL Standard Confusion
Ask SSC