Create Azure Data Lake Linked Service Using Azure Data Factory
In this article we walk through a step-by-step example on how to create an Azure Data Lake Linked Service in Azure Data Factory v2.
Adding Rows in Incremental Loads - Level 3 of the Stairway to Integration Services
Learn how to incrementally load new rows into a database from an Integration Services package. MVP and SSIS guru Andy Leonard continues his series on learning SSIS.
Advanced Event Behavior – Level 10 of the Stairway to Integration Services
The tenth article of this series starts to look at more advanced events and how we can use those events to better control and enhance our packages.
Advanced Logging - Level 12 of the Stairway to Integration Services
In this level, Andy Leonard goes into advanced logging techniques for your packages.
Advanced SSIS Workflow Management – Level 8 of the Stairway to Integration Services
In Level 8 of the Stairway to SSIS we look at more advanced workflow management within a package.
An Overview of Project Conversion - Level 14 of the Stairway to Integration Services
As we continue on with our look at Integration Services, this step talks about how to convert projects to the SSIS 2012 format.
An Overview of SSIS Parameters - Level 15 of the Stairway to Integration Services
The next level in the Stairway to Integration Services looks at Parameters and how you can incorporate them into your packages.
An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services
In this level of the Integration Services Stairway article, Andy Leonard examines SSIS variables.
Basic SSIS Workflow Management – Level 6 of the Stairway to Integration Services
The next installment of our Stairway to Integration Services from Andy Leonard looks at workflow and how you can control what happens in your package.
Charting the Unknown – Level 5 in the Stairway to Reporting Services
This article will explain different types of visualizations, including charts and maps, and when you would use each type.
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)
Hello all, I’m looking for advice on how to derive a daily snapshot table...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Question of the Day
Using OPENJSON
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.[key]
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers