Secure Your Data Prep Area
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
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)
785 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)
1,024 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
2,350 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
2 reads
Visual Studio and its business intelligence variant SQL Server Data Tools share a very powerful but extremely busy interface. If you happen to close out of one of the...
2019-12-20
128 reads
This quick tip is likely to be the most brief of the entire collection, but is also one of the most practical. When testing SSIS packages during development in...
2019-12-19
10 reads
Most folks I know go to one extreme or the other when it comes to the visual layout of SQL Server Integration Services packages: either they don’t care a...
2019-12-18
816 reads
Ordinarily I wouldn’t blog solely about a set of right-click options in an application, but in this Eleven Days of Festivus series I’m sharing some quick tips that have...
2019-12-17
219 reads
Regular expressions (or simply regex for short) have long been used by system administrators and data professionals for searching and manipulating text. Regular expressions allow the user to find,...
2019-12-16
47 reads
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
By Rohit Garg
In an era where cloud computing drives innovation, understanding its fundamentals is no longer...
I will have to test this next week, but will not have a chance...
I want to add a condition in the joining columns part of the merge...
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers