Eliminating Successful Backup messages with Powershell and SMO
As a DBA, I enjoy knowing that the better job I do, the less likely it is that any of...
2012-01-17
935 reads
Blog Posts
Error when creating a subscription
When creating a subscription in SQL Server sometimes the following error will occur:
The remote server "%s" does not exist, or...
2012-01-17
1,908 reads
Free SQL Performance Tool Worth Checking
First, I’d like to wish my readers a very safe, happy and prosperous 2012 (santé, properité, et bonheur). This is...
2012-01-17
1,625 reads
Goals – 6 month checkup
Last week’s resolutions post reminded me that it’s time for another status check on the goals I set for myself...
2012-01-17
821 reads
Hungarian Notation is misunderstood
Hungarian notation refers to a identifier naming convention. The variable indicates the variables use – as opposed to what they are....
2012-01-17
980 reads
Missing Indexes
SQL Server has means built into it to track possible missing indexes. This used to be found through the use...
2012-01-17 (first published: 2012-01-12)
3,824 reads
PASS Data Architecture VC presents: Audrey Hammonds–Database Makeover: Renovate Your Data Model
Subject: Database Makeover: Renovate Your Data Model
Start Time: Thursday, January 19, 2011 12:00 PM US Central Time (January 19, 2011...
2012-01-17
492 reads
SQLServerCentral Webinar #15
Once again, I’m the moderator for a webinar coming up at the end of the month, on Jan 31, 2012....
2012-01-17
823 reads
TOP WITH TIES
I have been working with SQL Server for quite a few years now, and it still happens quite often that...
2012-01-17
6,233 reads
#meme15 – Use. Twitter. Why?
Should an average Jane or Joe professional use twitter?
Yes.
Why?
Because, I’m using it.
Not enough reasons? <grumpy face> I knew you wouldn’t...
2012-01-16
674 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