Active August – Final Recap
Well, I had a pretty good week this week. I made an effort and met all my goals:
Eat smaller portions...
2009-08-31
1,324 reads
Blog Posts
Backing up to NUL vs Backup with Truncate only
Or “It’s 10pm, do you know where your log records are?”
Something that I’ve started to see recently is the idea...
2009-08-31
2,238 reads
Decompressing on Compression in SQL Server 2008....
Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...
2009-08-31
9,518 reads
Notes On the Jacksonville Code Camp
I drove up to Jacksonville Friday afternoon for the 2009 Jacksonville Code Camp led by my friend Bayer White. I...
2009-08-31
1,641 reads
Project Gemini
Dan English put up a blog post on his experiences with installing Gemini. His post is loaded with screen shots...
2009-08-31
1,365 reads
Scripting Server Side Traces
If you’ve never used SQL Server Profiler, you truly don’t know what your missing. And that statement has an intentional...
2009-08-31
1,648 reads
Setting Realistic Goals & Learning to Adjust
There is a lot of advice out there about how to get more done and how to accomplish one's dreams. I...
2009-08-31
2,028 reads
SQL Lunch Calendar
We have been working hard trying to get speakers to complete the year for our SQL Lunch schedule. I am...
2009-08-31
1,718 reads
Submitted PASS Board Of Directors Application
Well after much deliberation I have decided to submit an application for the PASS Board of Directors. I embark on...
2009-08-31
1,416 reads
The Pain of Multi-Threading!
Alas, this isn’t really a SQL post, but thoughts on efforts to share work that has been previously done by...
2009-08-31
1,436 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