My Adventures with the SQL 2005 Security Cache
Introduction
For that past couple of months I have been chasing performance issues with one of the most high profile servers...
2010-03-09
498 reads
Adventures in SQL
Why Do My SQL 2008 Compressed Backups Shrink?
Introduction
Recently a coworker was doing some research with SQL 2008 Backup Compression on a very large database. During the testing...
2010-02-25
419 reads
Why Do I Need All These Servers?
Introduction
I am frequently getting requests for a new server to do this or that. Running through the usual questions to...
2010-02-23
468 reads
Stored Procedure to Sequentially Run SQL Agent Jobs
Introduction
Here is another one of my utility scripts. Lately it seems like all I am blogging about is utility scripts,...
2010-02-01
2,530 reads
Stored Procedure to Get SQL Job Execution Status
Introduction
Ever need a programmatic way to figure out if a SQL Agent job is running? I did. After spending a...
2010-01-31
2,543 reads
Using sp_ExecuteSql to Run Dynamic SQL
Introduction
Lately it seems like I am being bombarded by Dynamic SQL and people who insist it is the only way...
2010-01-21
629 reads
Stored Procedures to Store and Get Database Users with All Permissions
Introduction
Traditionally when doing a restore, moving a database, etc. a DBA would simply go into Management Studio and use the...
2009-12-31
1,780 reads
Script Individual User Rights in a Database with PowerShell
Introduction
Tonight on Twitter the call went out on #SqlHelp looking for a way to script just database permissions for a...
2009-12-31
1,428 reads
A Busy/Accidental DBA’s Guide to Managing VLFs
Introduction
Properly managing VLFs can make or break the performance of your databases. There is a ton of information out there...
2009-12-21
864 reads
How to Shrink TempDB in SQL 2005
Introduction
From time to time you find yourself needing to shrink some space out of TempDB. Shrinking database files is never...
2009-12-17
3,043 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
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...
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