Enabling Checkpoints in your SSIS Packages
Checkpoints are a great tool in SSIS that many developers go years without even experimenting with. I hope to enlighten...
2009-06-18
13,025 reads
Blog Posts
Learning a New Development Platform
This past week at work we have been having some in-depth training. The interesting thing is it hasn't been SQL...
2009-06-18
1,334 reads
PASS Connector Editorial for June 17, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-18
653 reads
The Cost of E-books
What’s the cost of e-books? It’s an interesting question that I have always wondered. I found this account of the...
2009-06-18
725 reads
The secret skill revealed in the dusty booklet
Going through one’s father’s belongings after his death is
always a poignant, bitter-sweet experience. I was going through his most
precious books...
2009-06-18
1,988 reads
ALSSUG...soon!
Yes, ALbanian SQL Server User Group will start soon with first meeting and registering the new users. So we will...
2009-06-17
495 reads
Creating Red Gate SQL Compare Snapshots with Powershell
Co-worker and fellow DBA,, John O'Shea developed a Powershell script to create Red Gate SQL Compare snapshot files. Check out...
2009-06-17
1,064 reads
Kindle – Encouraging Plagiarism?
I ran across a story about the new Kindle blog publishing features. It was called “How the Kindle Now Lets...
2009-06-17
701 reads
Speaking at North Texas SQL Server User Group meeting
For those in or around the Dallas area tomorrow (Thursday) evening, I'll be speaking at the North Texas SQL Server...
2009-06-17
787 reads
Starting up a Pass Chapter
I am on my way in setting up a Pass chapter on our tiny Caribbean island. I had no clue...
2009-06-17
600 reads
Blogs
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
Forums
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers