The Eleven Days of Festivus 2020
We’re rounding the corner to the second half of December, which means it’s time for my favorite holiday: Festivus! Like many of you, I enjoy gathering around the Festivus...
2020-12-12
3 reads
Tim Mitchell
Creating Your First Azure Data Factory
Azure Data Factory has grown in both popularity and utility in the past several years. It has evolved beyond its significant limitations in its initial version, and is quickly...
2020-09-08 (first published: 2020-08-28)
492 reads
My New Favorite Demo Dataset: Dunder Mifflin Data
Those of us who write technical articles and deliver technical presentations are always on the lookout for the perfect data set for demonstration and testing. Microsoft has done a...
2020-08-17 (first published: 2020-08-06)
647 reads
Reusing a Recordset in an SSIS Object Variable
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
208 reads
The What, Why, When, and How of Incremental Loads
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)
554 reads
Comparing SSIS and Azure Data Factory
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)
710 reads
The SSIS Catalog: Install, Manage, Secure, and Monitor your Enterprise ETL Infrastructure
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
35 reads
SSIS Parameters
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)
476 reads
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
Lessons from Iowa’s Caucus Debacle
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)
782 reads
Blogs
Migrate to Azure PostgreSQL Flexible Server
I need to migrate from a single server to a flex server. Instead of...
Using Copilot to help me update SQL Saturday
By Steve Jones
An interesting AI experiment here with Copilot from GitHub in handling some code I...
Master SQL with This Free Course (141 Interactive Exercises Included)
SQL is essential for modern businesses and applications that rely on data. It's a...
Forums
The Vast Expansions of Hardware
Comments posted to this topic are about the item The Vast Expansions of Hardware
Code Blocks
Comments posted to this topic are about the item Code Blocks
does netsuite really hide columns from customers?
Hi we built a gateway from sql server to netsuite using an oracle competitor's...
Question of the Day
Code Blocks
What happens with this code:
DECLARE @Iteration INT = 0;
WHILE @Iteration < 10
SELECT CustomerName,
CustomerStatus
FROM dbo.Customer
WHERE CustomerID > 3;
SET @Iteration += 1;
See possible answers