Lost in Translation – Deprecated System Tables – sysfulltextcatalogs
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-17
629 reads
Blog Posts
PASS 2012 Countdown – 3 Weeks To Go
Another week down and there are now 3-weeks until this year’s PASS Summit. Take a moment and register now if...
2012-10-17
1,746 reads
PASS Election Results Posted
Congratulations to Wendy Pastrick, James Rowland-Jones, and Sri Sridharan on winning a two year term on the PASS Board of...
2012-10-17
805 reads
Querying database usage
A question that a DBA will often be asked is what databases are actively being used on my SQL Server?...
2012-10-17
3,428 reads
SQL In The City: Seattle
If you missed all the great speakers on the five city tour of SQL in the City, don’t despair. Many...
2012-10-17
1,146 reads
SQL Server Database Backup Report using T-SQL
Today, I am going to share few very useful scripts which will report us on Database Backup from different view...
2012-10-17
952 reads
Why Tune Queries?
It’s just a query against the database. If things are running slow, buy some more memory, a faster CPU or...
2012-10-17 (first published: 2012-10-15)
2,997 reads
Windows Server 2008 Cluster: Understanding the Cluster Log Behavior
In any system, logs are very important to troubleshoot the issue. In the case of windows cluster, cluster logs are...
2012-10-17
1,029 reads
Generate Uniqueidentifier with SSIS
If you are trying to generate Uniqueidentifier/Newid() in SSIS data flow, you will soon realize that there is no out-of-the-box...
2012-10-16 (first published: 2012-10-10)
11,500 reads
RML Utilities and SQL Server 2012
I’m working through some code that I haven’t touched recently and I’m running it for the first time on a...
2012-10-16
1,471 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