No Such Thing as a DevOps DBA
Sjor Takes (b|t) has just barely started blogging, but he’s got a great post about a discussion he had with...
2015-03-02
772 reads
Blog Posts
Rochester SQL Server User Group February Meeting - Slides & Demos
On Thursday, February 26th I presented “Easing Into Windows PowerShell” to a packed house at the Rochester SQL Server User Group meeting. Thanks to Matt Slocum (blog | twitter)...
2015-03-02
3 reads
Should I check tempdb for corruption?
You all know that checking our databases for corruption regularly is a must. But what about tempdb? Do you need...
2015-03-02
4,575 reads
SQL Judo’s Monthly Challenge – March 2014 – Powershell something
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...
2015-03-02
801 reads
SQL Server Quickie #22 – The Buffer Pool
Today I have uploaded the 22th SQL Server Quickie to YouTube. This time I’m talking about the Buffer Pool in...
2015-03-02
683 reads
SQLBits XIV – Welcome to the UK
A number of you will have heard of SQLBits before. It’s Europe’s largest conference dedicated to SQL Server. What was...
2015-03-02
625 reads
SQLSaturday Phoenix Wrap-Up
We had a great day at SQLSaturday Phoenix this weekend! The weather was beautiful (about 60°F warmer than at my home...
2015-03-02
243 reads
This one enhancement makes AlwaysOn Availability Group better in SQL Server 2014 !
I keep getting questions on what is improved other than the increased number of secondaries(8 now) with AlwaysOn Availability Group(AG) in...
2015-03-02 (first published: 2015-02-19)
7,978 reads
Triggering a System Center Configuration Manager deployment task
A slightly different topic today.
Once you have built up knowledge, you become the person that people ask to solve things....
2015-03-02 (first published: 2015-02-18)
6,532 reads
Introducing MergeUI
What is it? MergeUi is a addin (VSPackage) for Visual Studio / Sql Server Data Tools projects. It is a ui...
2015-03-01
38 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