Lightweight Statistics Profiling (with a potential bug)
The great thing about new versions of SQL Server is the fact that they are packed full of new features...
2017-02-13
399 reads
Blog Posts
Monday Coffee 2017-02-13
Man, if there was an award for procrastinating I’d definitely be in with a shout for today (I write these...
2017-02-13
306 reads
Open Source Power BI Desktop Workshop
I’ve created a free, open-source workshop to teach people the capabilities and features of Power BI Desktop. I was inspired...
2017-02-13
1,153 reads
The Foundry and Data Masking
There’s a group at Redgate that investigates new ideas and products. They’re called the Foundry, and they do some cool...
2017-02-13
474 reads
Devops without management buy in?
I was talking to someone at a meetup recently who was really keen on doing continuous deployment for their database...
2017-02-10
59 reads
Devops without management buy in?
I was talking to someone at a meetup recently who was really keen on doing continuous deployment for their database...
2017-02-10
52 reads
Devops without management buy in?
I was talking to someone at a meetup recently who was really keen on doing continuous deployment for their database but they had a number of issues, the main...
2017-02-10
8 reads
Devops without management buy in?
I was talking to someone at a meetup recently who was really keen on doing continuous deployment for their database...
2017-02-10
458 reads
Fix SQL Server Commvault Backup Failures After an Upgrade
One of my friend sent an email that backups of a SQL Server 2016 instance are failing suddenly when the...
2017-02-10
1,248 reads
Friday Reading 2017-02-10
Fun week, performed some RAM upgrades for my production SQL boxes which for one server, somehow fried its motherboard, hard...
2017-02-10
371 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