We’re speaking at PASS Summit 2013!
PASS liked our “Mouth Wide Shut” interviewing session from last year so much that they’ve decided to have us back...
2013-05-22
606 reads
Jen McCown
My 2013 SQL Saturday Schedule!
I’ve finally gotten my gear together for (what I consider) the “speaking season”. Here are the SQL Saturdays that I’m...
2013-05-16
615 reads
Use Powershell to find and punish – er, delete – rogue files
I like to know what’s on the drives that are supposed to be dedicated to data and log files. So I...
2013-05-13
1,087 reads
Quick Tip: Navigating to a UNC within SQLPS
I’ve been getting a funky error with a new Powershell script, running as a SQL Agent job step. Let’s pretend for the...
2013-05-06
763 reads
Quick Tip: Where’s my SQL Server Job History?
Here’s a quick mystery. You have a SQL Server with several jobs that appear to be running properly and on...
2013-04-29
1,194 reads
In which we compare CISPA to Rick Astley
Wherever you click, either CISPA or Rick Astley is there…
I’m studying up on CISPA for a segment on our webshow....
2013-04-20
589 reads
Remembering Alan Weber, @Aauugold
We lost someone this week. We lost a fellow SQL-ite, a Twitterer, a DBAs@Midnight chatroom live chatter. We lost someone...
2013-04-05
839 reads
The New MidnightDBA.com is live!
GUYS! GUYS! GUYS!!! We’ve finally completed the MidnightDBA.com facelift that many of you have been begging (nagging, pining, etc.) for,...
2013-04-02
627 reads
T-SQL Tuesday #40 Roundup: Files and Filegroups
Good day all, and happy T-SQL Tuesday #40! Yes, this event has officially hit middle age now. I fully expect...
2013-03-18
849 reads
Twitter Talk Theatre, Episode 1: “RAID is good enough!”
But We’ve Never Had a Disaster Before!
This week, some of my Twitter followers were kind enough to chime in on...
2013-03-07
698 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