A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s
A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s
I just want to pass along a few...
2010-05-01
1,160 reads
Blog Posts
SSIS : Data Flow paths
I had a very interesting bug that had me running around for over a week. Turns out the bug was...
2010-05-01
875 reads
TempDB Internals
TempDB Internals: TempDB is very important DB in sql server, generally sql server automatically takes care of the storage management...
2010-05-01
1,860 reads
A DMV A Day – Day 30
The DMV for Day 30 is sys.dm_os_buffer_descriptors, which is described by BOL as:
Returns information about all the data pages that...
2010-04-30
3,263 reads
Marathon Schedule
Finally I am putting down to paper my marathon race list for this season. Some of my favorite races are...
2010-04-30
1,482 reads
PASS Update #30 (Surveys)
Recently we released the results of the annual survey to determine interests for the 2010 Summit. That’s a step in...
2010-04-30
2,050 reads
Plagiarism
It seems to rear it’s ugly head more and more these days. Once again I found some content from my...
2010-04-30
1,936 reads
SCRUM Training with Alistair Cockburn
I wanted the SCRUM Master certification this year, and could have gone local, but I wanted to get the training...
2010-04-30
2,100 reads
Six Months
“Show up for work on time for six months and then we’ll talk. Until then, I have four words for...
2010-04-30
2,173 reads
Two Ways to Get System and Server Information on SQL Server from Management Studio / Enterprise Manager
To collect information for your SQL Server Infrastructure, there are two ways I can recommend.
The first, as mentioned from...
2010-04-30
10,058 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