PASS Summit 2015 Highlights
The week of the PASS Summit is always one of the highlights of my year. Even though I keep connected...
2015-11-04
285 reads
Blog Posts
PASS Summit Recap and Experience
The day finally came and I was fortunate, no I was blessed to be a part of the PASS Summit...
2015-11-04
535 reads
Performance and using of VARCHAR boxes as filters in SSRS reports
Very few people have thought about this performance killer. It is all about report parameter of text type.
The initial situation
There...
2015-11-04 (first published: 2015-10-22)
2,429 reads
Questions from “SQL Server Security for Everyone”
I recently gave my SQL Server Security for Everyone session at Summit 2015. (I’m still in awe about that by...
2015-11-04
516 reads
Why Ask Why?
Spend any time around a 4 year old, and you will inevitably find yourself involved in a conversation which evolves into this:
Please do this thing Why? Reasonable answer Why? Restatement...
2015-11-04
5 reads
A Mess of Nested Transactions
Transactions are an area that I often find are used badly, or not used at all. Transactions without any error...
2015-11-03
797 reads
Columnstore Indexes – part 72 (“InMemory Operational Analytics”)
Continuation from the previous 71 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have previously written on the Rowstore...
2015-11-03
548 reads
Configuring the Azure SQL Database Firewall
Azure SQL Database is a Platform as a Service (PaaS) that provides a relational database for use over the internet....
2015-11-03
588 reads
DLM Dashboard moves to 50 Databases – For FREE
I love DLM Dashboard. It’s the product that I’ve written myself, in various ways since SQL Server 6.5. My versions...
2015-11-03
739 reads
Git Push in SQL Source Control
I’m excited. Git support is growing in SQL Source Control and the release recently contains Git push/pull support. If you...
2015-11-03 (first published: 2015-10-22)
2,297 reads
Blogs
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...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
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