PASS Linux for the SQL Server DBA Webinar – Dec 13
Join me for a session on Linux administration for the SQL Server DBA as part of the PASS SQL Server...
2017-12-04 (first published: 2017-11-26)
1,124 reads
Blog Posts
SQL Homework – December 2017 – View the log
Last homework of the year. Last month was to create a view. This month it’s time to take a look...
2017-12-04
314 reads
System.ConsoleColor error while running powershell in SQL agent job step
Issue: While running powershell in SQL agent job step, I am getting below error: –
A job step received an error...
2017-12-04
991 reads
The Myth Of Tomorrow
“We’ll fix it in the mix.”
“It’s good enough for right now.”
“We’ll worry about that later.”
“Your check is in the mail.”
Of...
2017-12-04
732 reads
T-SQL Tuesday #97 – Setting learning goals for 2018
This is my first opportunity hosting a T-SQL Tuesday and am super excited!!T-SQL Tuesday is the brainchild of well respected SQL Guru...
2017-12-04
950 reads
Why I Use AdventureWorks for Demos
I know that when some people see AdventureWorks, their vision turns all red around the edges, their blood pressure spikes...
2017-12-04
366 reads
Enterprise Analysis Services Development: Interview with Alberto Ferrari and Marco Russo
Between sessions at the PASS Summit, I had the privilege of interviewing Alberto Ferrari and Marco Russo; SSAS Maestros and...
2017-12-03
423 reads
A Novel Idea for High Availability in SQL Server on Linux
Over the past year we’ve learned about how SQL Server on Linux is implemented, leveraging SQLPAL and the team is pretty...
2017-12-02
452 reads
A Novel Idea for High Availability in SQL Server on Linux
Over the past year we’ve learned about how SQL Server on Linux is implemented, leveraging SQLPAL and the team is pretty confident in their architectural decisions as indicated in this...
2017-12-02
3 reads
Azure Virtual Machine + Premium Disk Throughput Calculator
I keep having to refer to the virtual machine size page and the disks pricing page to work out how...
2017-12-02
365 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