The Power of Data in the Cloud
Today we had a full-day event in Microsoft about the data offerings and possibilities in the Microsoft cloud platform – Azure....
2015-11-19
704 reads
Blog Posts
Webinar Followup: Migrating your SQL Server VMs to Azure with PowerShell
Earlier this week I presented a free webinar for Pragmatic Works where I discussed how to migrate virtual machines to...
2015-11-19
1,308 reads
CHECKDB - The database could not be exclusively locked to perform the operation
…so the job failed….again…you know the one – that darn Integrity Check job: Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma...".: 100% complete ...
2015-11-18 (first published: 2015-11-16)
11,325 reads
In-Memory OLTP Table Checkpoint Processes Performance Comparison
Checkpoint processes and other internal processes have undergone major changes for In Memory OLTP tables and transactions. The following article...
2015-11-18
685 reads
Naught to Speaker pt 3
Becoming a speaker is one heck of a journey. Early this year I submitted a session to speak at Pass...
2015-11-18
615 reads
One Tool to Rule Them All – Almost
There we so many cool announcements at the PASS Summit this year, but one of my favorites was the “One...
2015-11-18
599 reads
Selectively Locking Down Data - Gracefully
I have a situation where I need to retrieve the data in an encrypted column from, but don’t want to give all my users access to the symmetric key...
2015-11-18
4 reads
Viewing Extended Properties for Information
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
I’ve...
2015-11-18
1,327 reads
[T-SQL Tuesday] Data modeling: The trouble with prefixes
This month, Mickey Stuewe (b|t) hosted T-SQL Tuesday, giving us a topic of “data modeling gone wrong“. This is a fantastic...
2015-11-17
411 reads
[T-SQL Tuesday] Data modeling: The trouble with prefixes
This month, Mickey Stuewe (b|t) hosted T-SQL Tuesday, giving us a topic of “data modeling gone wrong“. This is a fantastic...
2015-11-17
396 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