A Small Collection of SQL Azure Queries
We have been doing some more work with SQL Azure lately, so I have put together a small collection of...
2011-03-11
2,544 reads
Glenn Berry
SQL Server Videos on Channel 9 From Microsoft
Here is a collection of 13 short (less than 10 minutes each) videos about improvements in SQL Server Denali, and...
2011-03-09
1,840 reads
Las Vegas SQL Server User’s Group Presentation on March 10
I will be giving a virtual presentation via LiveMeeting on March 10, 2011. The S3OLV User Group meeting starts at...
2011-03-09
644 reads
Visual Studio 2010 SP1 Released
Microsoft has released the RTM version of Visual Studio 2010 SP1, which is available on the MSDN Subscribers web site.
Microsoft’s...
2011-03-08
753 reads
March 2011 Version of SQL Server 2005 and 2008 Diagnostic Queries
Another month, and another new version of my SQL Server Diagnostic Information queries for both SQL Server 2005 and SQL...
2011-03-08
648 reads
SQL Server Hardware Selection Presentation from Rocky Mountain Tech Trifecta
I just wanted to post a link to my presentation on Hardware 201: Selecting and Sizing Database Hardware for OLTP...
2011-03-05
510 reads
SQL Server 2008 R2 RTM Cumulative Update 6 Released
Microsoft actually released SQL Server 2008 R2 Cumulative Update 6 on February 21, 2011, so I am a little late...
2011-03-01
1,070 reads
Rocky Mountain Tech Trifecta on March 5
I will be attending and speaking at the Rocky Mountain Tech Trifecta in downtown Denver on March 5, 2011. This...
2011-03-01
497 reads
Don’t Be Afraid of Windows Failover Clustering!
One of the more exciting features in SQL Server code-named “Denali” (which is the current official name for the next...
2011-02-28
1,862 reads
Some Suggested SQL Server 2008 R2 Instance Configuration Settings
Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level...
2011-02-25
13,787 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