SSIS – Avoid OLE DB Command
I decided to do a little performance testing on some common SSIS “Tricks” that increase speed and effectiveness of SSIS...
2008-12-29
14,305 reads
Blog Posts
April Fools Challenge
I know it's not April 1st yet, but I wanted to throw out a couple comments and a challenge well...
2008-12-28
1,513 reads
A Little Work
Tia came down and asked if we should do something with the kids, bowling, movies, etc. I told her I...
2008-12-26
1,432 reads
One Year In
I got my Toshiba Qosmio a little over a year ago and it has been a great machine for me...
2008-12-26
1,448 reads
When Data Mining Goes Too Far
Data mining is commonly used to find otherwise undetectable patterns in related sets of data. However, sometimes these patterns provide...
2008-12-26
1,522 reads
Grasshopper
During a recent class I happened to mention something about grasshopper, and a student wasn't familiar with the reference to...
2008-12-25
1,770 reads
Merry Christmas
I'm sure some of the geeks out there are logging onto the web, checking feeds, and whiling away some of...
2008-12-25
1,393 reads
Building an Infrastructure
As we try and evolve our automotive industry, and perhaps our energy policy, to move into the future in the...
2008-12-24
1,487 reads
Merry Xmas
I'm enjoying today with family and hope you are as well. Nothing complicated today, just some appropriate music!
Bruce Springsteen - Santa...
2008-12-24
1,467 reads
Blackberry Bold
It was only a year ago that I moved from the Blackjack to the Blackberry Curve and overall I was...
2008-12-23
1,413 reads
Blogs
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) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
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...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
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