Key Discovery III
In Part I and Part II of the series, I discussed documenting and discovering Primary Keys and Clustered Indexes. In...
2010-02-02
1,706 reads
Blog Posts
PASS Acquires SQLSaturday
I’ll write more about this tomorrow, but for now I’m reposting the release from Rushabh Mehta, President, PASS:
It gives me...
2010-02-02
314 reads
Providing Online Help for Powershell Modules
As a finishing touch for the SQL Server Powershell Extensions 2.0 Release I wanted to provide an online version of...
2010-02-02
2,003 reads
RedGate Releases SQLSearch - FREE!
RedGate Releases SQLSearch - FREE!
SQL Search - Released
My friends at RedGate have released a new FREE Tool. Please read on to learn...
2010-02-02
804 reads
Reflections on ‘Visibility, the Art of Being Noticed’ by Phil Factor
If you have not read the Master of Phrenetic Phoughts’ article, please do so here. I enjoyed very much the...
2010-02-02
967 reads
SQLSaturday Bequeathed to PASS
I guess you could look at this one of two ways. Either PASS acquired SQL Saturday, or we (Andy, Brian,...
2010-02-02
580 reads
Three Engine Improvements in SQL Server 2008 R2
The upcoming (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI area...
2010-02-02
953 reads
Three Engine Improvements in SQL Server 2008 R2 (Updated)
The upcoming release (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI...
2010-02-02
427 reads
Find Efficiencies or Add Horsepower?
In our world sometimes it’s worth the time and effort for in depth tuning to get the machine to run...
2010-02-01
664 reads
I don’t care
I had meant to check what was up with my Toshiba laptop since I was curious. I gave up last...
2010-02-01
336 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