What Agent Job is Running – Back to Basics
It is quite common to be required to investigate performance issues on the server. With this, it is occasionally necessary to be able to interpret an obfuscated job name....
2016-12-23
34 reads
Blog Posts
What is Constraints in TSQL?
Constraints let you define the way the Database Engine automatically enforces the integrity of a database. Constraints define rules regarding the...
2016-12-23
322 reads
Actual Chats: RIGHT OUTER joins in the wild
Colleague:
I think I just encountered my first Right join
*shocked* Me:
huh. weird.
a rare Right Join has appeared!Colleague:
catch it!Me:
You use ON. It's...
2016-12-22 (first published: 2016-12-06)
2,885 reads
Database Backups – Back to Basics
In this article, we will explore database backups. More specifically, how do you truly know if you have a successful backup? Here's a hint: it has to deal with...
2016-12-22
7 reads
Database Backups – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-22
686 reads
Quick Command Shells–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-12-22
609 reads
SSIS Custom Logging Levels
In my ongoing series on ETL best practices, I recently wrote about the importance of logging in extract-transform-load processes. For...
2016-12-22
482 reads
Windows Server 2016 and SQL Server 2016 – A match made in heaven!
For all these years Windows Server 2016 is the Windows version I was waiting for, and this blog post will explain why...
2016-12-22
1,257 reads
Windows Server 2016 and SQL Server 2016 – A match made in heaven!
For all these years Windows Server 2016 is the Windows version I was waiting for, and this blog post will explain why I’m super excited about this! With Windows Server 2016,...
2016-12-22
4 reads
Automating DBCC Page
Way back in 2006, Paul Randal documented DBCC PAGE on his Microsoft blog at http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/10/625659.aspx. In his post, you will...
2016-12-21
417 reads
Blogs
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...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
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