Parameterization Part 6: Simple vs. Forced Parameterization
This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan...
2014-11-27
7,537 reads
Blog Posts
Use -eq in Powershell
I was writing a quick script to work with files and I only wanted to process one file for each...
2014-11-27 (first published: 2014-11-17)
6,039 reads
Audit Database File Size Changes
Recently I shared an article on how to track the growths and shrinks that occur within database files. I shared...
2014-11-26
2,576 reads
Audit Database File Size Changes
If you just so happen to be running on SQL Server 2012 or later, you will need to change your event sessions that were tracking file changes. It is...
2014-11-26
17 reads
Exam Prep 70-463: More about Dimensions
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-11-26 (first published: 2014-11-20)
7,023 reads
How to burn down your house while frying a turkey
It’s an odd query, yes, but in preparation to write this post I actually typed the above phrase into my...
2014-11-26
1,253 reads
SQL Saturday Parma – English Slide decks available to download
My SQL Saturday Parma slide decks are available to download on SlideShare.
The main topic of those presentations is database lifecycle management (DLM)...
2014-11-26
13 reads
Vital Statistics and Health Checks
This post has nothing, absolutely nothing, to do with SQL Server. It does, however, relate to your career as a...
2014-11-26 (first published: 2014-11-17)
6,233 reads
What is Azure Data Factory?
The Azure Data Factory is a service designed to allow developers to integrate disparate data sources. It is a platform...
2014-11-26
2,066 reads
When the Problem is Not Them. It’s You.
Hello Dear Reader! I’ve been the Data Platform Management Lead at Pragmatic Works for almost two years now. It’s been...
2014-11-26
1,252 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