Building a SQL Server Inventory – Part 2
Last time I went through my script to gather server information for my inventory. Today I’m going to go through...
2012-05-31
4,159 reads
Blog Posts
Cross Database Views and Schema Binding
One of the most interesting things I've found as a DBA is learning about features in other RDBMS platforms. Sure...
2012-05-31
2,605 reads
DBCC CHECKDB
Quite often when I see a new SQL Server setup, a CHECKDB has never been run on the databases. It’s...
2012-05-31 (first published: 2012-05-29)
118,725 reads
Denali – Day 31: Discontinue and Breaking/Behavior change features
Denali – Day 31: Discontinue and Breaking/Behavior change features Discontinue Features: As discussed about Deprecated will going to discontinue with that...
2012-05-31
1,752 reads
How to Give your .NET application HA
By David Postlethwaite
I was at a meeting the other week when someone mentioned that you could specify two SQL Servers...
2012-05-31
1,741 reads
How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server? (Republished)
How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server? (Republished)
One of...
2012-05-31
6,563 reads
Never, Ever Use Clustered Indexes
This whole concept of the clustered index as a foundational structure within SQL Server is just plain nuts. Sure, I...
2012-05-31
2,363 reads
No More SQLRally In the US
I was disappointed to see the mention in the Connector today that there would be no SQLRally 2013 in the...
2012-05-31
1,692 reads
Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1 (Republished)
When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get...
2012-05-31
3,843 reads
SQL Saturday #167 – Columbus GA
The Columbus GA SQL Users Group will be hosting their first ever SQL Saturday on September 8th 2012 at Columbus...
2012-05-31
1,713 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