Putting Corrections in Perspective using Power BI
My enthusiasm for analyzing stock market data using Power BI – even after publishing two posts recently (this and this) – is at...
2015-10-13
550 reads
Blog Posts
Running Parameterized Queries against SQL Server using PowerShell
For many years I didn’t really think about the implications of how I was retrieving data from my SQL Servers...
2015-10-13
15,774 reads
SQL Data Generator–Masking Production Data
I learned a new trick with SQL Data Generator that I wasn’t aware of previously. I think this is a...
2015-10-13 (first published: 2015-09-30)
4,150 reads
SQL server Encryption – Transparent Data Encryption
In the previous blogs we saw the use of certificates to encapsulate symmetric keys. How it benefits the user by...
2015-10-13
559 reads
Trace Flags in Azure SQL Database
One of the ways that you take more direct control over your SQL Server instances is through the use of...
2015-10-13 (first published: 2015-10-05)
1,214 reads
A tSQLt Mistake – Debugging a Test
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t...
2015-10-12
746 reads
A tSQLt Mistake – Debugging a Test
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t...
2015-10-12
436 reads
Argenis Without Borders: Fun For a Good Cause
This is the second year of Argenis Without Borders and the second year that I’m taking part. Last year we...
2015-10-12
516 reads
Attending PASS Summit? Take a great Tuesday precon!
We’re just two weeks away from the PASS Summit in Seattle, and there is most definitely still time to get...
2015-10-12
608 reads
Backup Deployed Sessions
There is a wealth of information within Extended Events. Throughout this series, I have been working on exposing that wealth...
2015-10-12 (first published: 2015-10-05)
536 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