SQL Server 2008 Surface Area Configuration
Ever wondered what happened to the SQL 2005 Surface Area Configuration Utility in SQL SERVER 2008.
Well you can accomplish pretty...
2010-09-14
874 reads
Blog Posts
SQL Server Security Checklist
In this post, I continue my checklist series that will eventually become a new book. The focus of this checklist...
2010-09-14
1,658 reads
Task Manager - Don't Believe the System Idle Process Percentage
This morning my laptop went to a crawl. I looked, and sure enough, there was an AntiVirus scan running. Argh!...
2010-09-14
3,560 reads
The SQLSaturday Squirrel
A bit of mid week humor. Recently I met up with Jack Corbett to review our room options for SQLSaturday...
2010-09-14
536 reads
T-SQL Tuesday #10 - Indexes
It’s time for T-SQL Tuesday again, the brainchild of Adam Machanic (Blog|Twitter), and this month’s topic is Indexes. A thanks...
2010-09-14
1,637 reads
24 (28) Hours of PASS on Sep 15, 2010
It’s back with a slightly different format this time, 28 hours of seminars delivered over two days, and it’s all...
2010-09-13
568 reads
Database automation and appliances
10 years ago IT professionals considered database technology “mature” and analysts were preparing to...
2010-09-13
13 reads
Database automation and appliances
10 years ago IT professionals considered database technology “mature” and analysts were preparing to slide it into a commodity status… But on the Exabyte era, we depend on databases...
2010-09-13
13 reads
Getting Drive Info, Part 4, the SSIS Script Component
In this installment of the Getting Drive Info series (Part 1, Part 2, Part 3), SSIS will be used to...
2010-09-13
1,340 reads
Getting Drive Info, Part 4, the SSIS Script Component
In this installment of the Getting Drive Info series (Part 1, Part 2, Part 3), SSIS will be used to collect and save the drive information. SSIS provides multiple...
2010-09-13
10 reads
Blogs
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...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
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