2012-10-13
6 reads
Blog Posts
2012-10-13
4 reads
2012-10-13
5 reads
24 Hours of PASS Recordings Available
If you missed any of the great 24 hour of PASS sessions from September you
can now watch the recordings.
http://www.sqlpass.org/UserLogin.aspx?returnurl=%2fLearningCenter%2fSessionRecordings%2f24HoursFall2012.aspx
Details...
2012-10-12
1,076 reads
24 Hours of PASS videos online
All the videos for the sessions at 24 Hours of PASS (Fall 2012) are available for free. Check the session schedule for...
2012-10-12
743 reads
Ask the Unicorn: How to become a DBA?
Every now and then I get a question in e-mail and I usually just reply and leave it at that. ...
2012-10-12
686 reads
Dallas, TX to Pittsburgh, PA A #sqlsat171 Story!
First SQL Saturday in Pittsburgh
It was an honor to speak at the first SQL Saturday in Pittsburgh. The company I
We...
2012-10-12
629 reads
How to move the FullText catalog with SQL Server 2005 ?
4 simple steps to move FullText catalog with SQL Server 2005 :-
1. Detach the database which contains the FullText Catalog....
2012-10-12
1,064 reads
I’m Not Attending #sqlpass Summit 2012 and I’m Sorry For Myself
I really wanted to attent PASS Summit this year, I’ve never attended before. I was preparing myself mentally since the...
2012-10-12
688 reads
Introduction to SQL Server 2008
There are still some seats left on the SQL Server 2008 A Comprehensive Hands-On Introduction that I will be presenting...
2012-10-12
570 reads
Blogs
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
Forums
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers