Mid-year update on my goals
I recently saw that Steve Jones had posted an update on his 2009 goals and realized that is was about...
2009-07-07
368 reads
Blog Posts
Shrinking the Log
It seems that I see more and more posts about people trying to shrink their transaction logs. It's getting to...
2009-07-07
1,850 reads
Upcoming News and Events
There are a lot of exciting events happening in the next 2 months that you should be involved in so I...
2009-07-07
822 reads
Behind on Blogging
One of the things I recommend to people that are looking to get into blogging is that they write 10...
2009-07-06
353 reads
Episode #3 It's All About The Tools TV Show
Russ Fustino from Microsoft just sent me the link to episode #3 that was filmed at SQLSaturday #14 in Pensacola....
2009-07-06
485 reads
Object Grouping Best Practices: Using Schemas for Logical Separation
Originally written in French last year, now revised for you in my native language below:
You've probably all noticed a change...
2009-07-06
3,497 reads
Presenting at SQL Saturday Baton Rouge
I'll be presenting two sessions at the SQL Saturday event in Baton Rouge on August 1. I'll be presenting a...
2009-07-06
482 reads
Recovering Missing Templates in Visual Studio
Recently I decided to expand my coding knowledge and picked up a Visual Basic book. I’ve been working in this...
2009-07-06
785 reads
Richmond SQL Server Users Group
Actually a combination meeting of the Richmond .NET and SQL groups, put together for me. They normally meet on consecutive...
2009-07-06
740 reads
So Now I’m Gilligan, Finally
Okay I was tagged by Tim Mitchell on the Deserted Island scenario started by Tim Ford which goes like this:
So...
2009-07-06
490 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