SQL Server 2012 SP1 CTP4 Is Now Available !
Service packs are very critical and important. It is very important from product upgrade & bug fixing point of view.
Microsoft has...
2012-10-11
707 reads
Blog Posts
Why I Love the SQL Server Community
As many of you are aware, a SQL Server security patch came out this week (MS12-070 - Vulnerability in SQL Server...
2012-10-11
1,008 reads
Windows Server 2012 and Hyper-V
I recently went to a Microsoft event in Denver on Windows Server 2012 and Hyper-V improvements. Harold Wong (b | t)...
2012-10-11
1,374 reads
Gain exclusive control of a database
Last night a client tried to ruin a script to enable Read_Committed_snapshot on a SQL database. There were so many...
2012-10-10
553 reads
Grant Execute Permission on All Stored Procedures
Right out of the box, SQL Server makes it pretty easy to grant SELECT, INSERT, UPDATE, and DELETE to all...
2012-10-10
13,153 reads
Lose #5 Before #sqlpass
Win Valuable Prizes!
Impress Your Friends!
This week we’re starting up a health and weight loss competition that I hereby dub #PASSGameOn,...
2012-10-10
964 reads
PASS 2012 Countdown – 4 Weeks To Go
One week down and we are now 4-weeks from this years PASS Summit. Hopefully, you have already registered for the...
2012-10-10
1,136 reads
Slides and Scripts from Idera Auditing SQL Server presentation
I had a few folks ask me for the slides and SQL scripts from the Auditing SQL Server webinar I...
2012-10-10
1,563 reads
Speaking at SQL Saturday #145 in Nashville
I will be speaking at SQL Saturday #145 in Nashville, TN to speak on one of my favorite topics – Virtualizing...
2012-10-10
759 reads
SQL Server:Understanding The Page Free Space (PFS) Page
In my earlier post, we have discussed about GAM and SGAM Page and Data Page. In this postlet us discuss about...
2012-10-10
6,384 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers