The DBA Routine Posted on SSC
This was fun to write, though it's hard to boil everything down to 10 big steps. I thnk as an...
2007-11-30
1,444 reads
Blog Posts
Another use of OpenRowSet()
From time to time, I need to dump out the result from a SP, such as sp_lock or sp_who.
Traditionally,...
2007-11-29
1,399 reads
MS, kill Begin/End!
It's funny - sorta - how you become used to the quirks of the tools you. I try not to rant too...
2007-11-29
1,411 reads
Why Don't People Go to Free Training?
I was having this discussion recently with Shawn Weisfeld, President of ONETUG and it's definitely a frustrating topic. As a...
2007-11-28
1,420 reads
Community Search vs Brute Force Algorithms
I was reading an interview with Jimmy Wales (the Wikipedia guy) in Selling Power magazine (I have ecletic reading preferences...
2007-11-26
1,356 reads
Google CIO and IT Strategy
CIO Magazine has a interesting article about Douglas Merrill, the CIO of Google. One of the things he dicusses in...
2007-11-26
1,698 reads
Passed 70-431
After putting it off for six months, I finally took - and passed - 70-431 yesterday. I know, I'm probably one of...
2007-11-25
1,437 reads
Honeypots in the Database
As a follow up to my post about Cesar Cerrudo's new whitepaper, earlier this month David Litchfield talked about putting...
2007-11-23
2,349 reads
Whitepaper on Malware to Attack Databases
Cesar Cerrudo of Argeniss Information Security has put out a new whitepaper (.pdf format), Data0: Next generation malware for stealing...
2007-11-23
1,966 reads
Buying a New Cell Phone
For the page 10 months or so I've been using a Samsung Blackjack, before that I used various Blackberries for...
2007-11-21
1,427 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