FOR JSON Clause Mode With ROOT Option In SQL Server 2016
Hi friends, we will continue with FOR JSON clause in this blog and today we will learn formatting of query...
2015-07-06
381 reads
But I Don’t Have a Test Server…
I frequently see statements on forums along the lines of “I don’t have a test server, so I’m going to...
2015-07-10 (first published: 2015-07-06)
3,152 reads
New Extended Events for 2016
As we begin to get a grasp of all that is available with SQL Server 2016 and all of the new features, it is a great idea to see...
2015-07-06
41 reads
New Extended Events for 2016
As we begin to get a grasp of all that is available with SQL Server 2016 and all of the...
2015-07-06
1,274 reads
Adding a new keyboard shortcut in SSMS.
I love keyboard shortcuts. I’d rather keep my hands on the keyboard than move back and forth to the mouse....
2015-07-13 (first published: 2015-07-06)
2,782 reads
10 Best Advices to Choose an SQL Consulting Firm
Managing SQL Server can be exhausting, so more and more companies today choose either to delegate this task to some...
2015-07-06
724 reads
Columnstore Indexes – part 58 (“String Predicate Pushdown”)
Continuation from the previous 57 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have previously blogged on the predicate...
2015-07-05
841 reads
Announcing Columnstore Indexes Script Library
Today, the 3rd of July 2015 marks the 2rd anniversary of my very first Columnstore Indexes blog post in the...
2015-07-05
472 reads
Run SQL Server In A Container Today July 2015
Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official...
2015-07-03
813 reads
FOR JSON Clause With INCLUDE_NULL_VALUES Option In SQL Server 2016
Hi folks, Today we learn how to format query using FOR JSON clause with INCLUDE_NULL_VALUES option in SQL Server 2016....
2015-07-03
355 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers