Speaking at SQL Saturday Pensacola!
I’m proud to announce that I will be speaking at SQL Saturday Pensacola on June 3rd 2017! Check out the amazing schedule!
If you don’t know what SQLSaturday is, it’s a...
2017-05-26
6 reads
Blog Posts
Speaking at SQL Saturday Pensacola!
I’m proud to announce that I will be speaking at SQL Saturday Pensacola on June 3rd 2017! Check out the amazing...
2017-05-26
345 reads
Tuning Parallelism on SQL Server
Parallelism and MAXDOP
There’s no doubt that parallelism in SQL is a great thing. It enables large queries to share the...
2017-05-26
5,300 reads
Find when your SQL Server database grew
A quick post that is hopefully useful, I wanted a quick way to find the time, size of the database...
2017-05-25
325 reads
PowerShell Remoting in Multi-Platform Environments using OpenSSH
So in my last post I told you about how I started my journey on learning PowerShell, let’s keep going down that path together. In this post I’m going...
2017-05-25
6 reads
PowerShell Remoting in Multi-Platform Environments using OpenSSH
So in my last post I told you about how I started my journey on learning PowerShell, let’s keep going...
2017-05-25
527 reads
Restore to a point in time–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-05-25
720 reads
Save on IT/DevConnections this fall
For the first time in many years, I won’t be at IT/DevConnections this fall. I’m disappointed to miss the event,...
2017-05-25
549 reads
Speaking at SQL Saturday Atlanta (#652)
I am so excited and honored to have been selected to speak at SQL Saturday Atlanta (#652) this year. This...
2017-05-25
326 reads
SSRS Subscription Schedules – Enhanced
With the ability to create content delivery schedules, or to subscribe to report content delivery, it becomes very important to also know when the various reports are scheduled to...
2017-05-25
297 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers