Building The SQLSaturday Orlando Marketing Plan–Part 9
I’ve heard more than once that Meetup.com is a good way to reach new people so we’re looking at how...
2014-05-21
699 reads
Blog Posts
Cumulative Update – 10 for SQL Server 2012 Service Pack 1 Is Now Available !
The 10th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-05-21
982 reads
DBA Myths: A table with a primary key is not a heap
Typically when you see a heading like this you know the answer is “No” or “False” but in this case...
2014-05-21
2,642 reads
How SQL Server statistics are generated and updated
One of the easiest ways to increase query performance on your database is making sure your statistics are up-to-date. Statistics...
2014-05-21 (first published: 2014-05-16)
6,343 reads
PowerShell – OS Inventory and Disk Info – Consolidated Excel File – EMAIL
This script is used to discover all the server information and captures disk drive utilization details. The drive details are...
2014-05-21
1,199 reads
PowerShell – OS Inventory and Disk Info – Consolidated Excel File – EMAIL
This script is used to discover all the server information and captures disk drive utilization details. The drive details are...
2014-05-21
559 reads
Quick Tips – SQL Prompt Stop the Yelling
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-05-21
2,008 reads
Setting Up Your Custom Data Collector Set
Problem: From my previous post, we learned how to set up Data Collection in SQL Server. This is most suitable...
2014-05-21
599 reads
SSRS Nugget: displaying placeholders when no rows are returned
A few days ago there was an interesting question on the forum:
How can I get None in each cell of...
2014-05-21 (first published: 2014-05-15)
2,358 reads
Submitted My Application For the 2014 PASS Nominating Committee
I just finished up the short and not very painful application to be a candidate for the NomCom this year. ...
2014-05-21
496 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