Thoughts on the 2018 (and beyond) PASS Elections – Part 1
Last week Wendy Pastrick of the PASS Board posted PASS Election 2018 Timeline. It’s a good post for a few...
2018-05-16
313 reads
Blog Posts
Webinar Followup: Overview of Azure Data Factory V2
About 3 weeks ago I presented a free webinar for Pragmatic Works where I talked about Azure Data Factory V2....
2018-05-16
381 reads
Webinar Followup: Overview of Azure Data Factory V2
About 3 weeks ago I presented a free webinar for Pragmatic Works where I talked about Azure Data Factory V2. You can watch the recording here if you missed...
2018-05-16
8 reads
When Simple Parameterization…Isn’t
I’m desperately working to finish up a new version of my book on Execution Plans. We’re close, so close. However,...
2018-05-16 (first published: 2018-05-07)
2,580 reads
Change SSAS Tabular Data Source using TOM
We’ve all been there. You made some adjustments to your Tabular model and you deploy it to the production server...
2018-05-15 (first published: 2018-05-08)
1,913 reads
Day 15 Server Logs
There are 6 types of logs available for MySQL environment, Logs are important information for DBA to troubleshoot or understand...
2018-05-15
212 reads
dbachecks – Which Configuration Item For Which Check ?
I love showing dbachecks to people. It’s really cool seeing how people will use it and listening to their experiences....
2018-05-15
320 reads
Discuss smart database backup in SQL Server 2017
So far, we’ve discussed several phases of backup that starts with planning, creating, strategizing and implementing. In this article, we...
2018-05-15
403 reads
Issue while using SQLCompare against Azure SQL DB
I’ve encountered an issue while trying to compare a local SQL Server database against an Azure SQL DB using Redgate...
2018-05-15
292 reads
Power BI Custom Visuals Class (Module 103 – Timeline by CloudScope)
In this module you will learn how to use the Timeline by CloudScope. The Timeline by CloudScope is designed for...
2018-05-15
909 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