A Strange Day at McDonalds
A few weeks ago I was running errands on a Saturday, with an almost final stop at Home Depot to...
2012-04-12
687 reads
Blog Posts
April 2012 – Monthly SQL Server Checklist
Another month goes by and it’s time again to ask… are your SQL Servers healthy? Have they been properly configured? ...
2012-04-12
892 reads
Be Extra Careful When Packing
Over the last couple of years I’ve gotten myself down to two small, carry-on bags for most of my trips....
2012-04-12
1,085 reads
Microsoft Brings Back the Old Certification Acronyms MCSE and MCSA, starting with SQL Server
The new certification structure has been announced by Microsoft and the changes are rather broad and sweeping. MCITP is gone....
2012-04-12
1,953 reads
Quick Reference: How Do I Read an Excel XSLM (Macro-Enabled) File in SSIS?
Excel 2010 (and presumably the next version of Excel) have taken some security precautions with regards to macros in Excel...
2012-04-12 (first published: 2012-04-09)
2,714 reads
Re-thinking security for customer service
This morning my son woke up to find his eBook reader frozen. It wouldn't unlock. It was fully charged (the...
2012-04-12
1,261 reads
Speaking at SQL Saturday #136 – Wellington, New Zealand
TweetG’day,
On Saturday 14th April I’ll be speaking at SQL Saturday 136 in Wellington, New Zealand.
My presentation is titled “Extended Events...
2012-04-12
983 reads
SQL Server 2012 RTM Cumulative Update 1
Microsoft has released SQL Server 2012 RTM Cumulative Update 1, which is Build 11.0.2316.0. I count 55 fixes in the...
2012-04-12
2,255 reads
SQL server: Deciphering Wait resource
When I was working with couple of frequent blocking issue in our live server, I have noticed different types of...
2012-04-12
32,124 reads
Using Databases on WP7
From version 7.5 (Mango) WP7 runs a version of SQL Server CE which is all setup waiting for your applications...
2012-04-12
39 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