SQL Server Policy Based Management by Example
What steps do you go through to validate SQL Server configurations after a server build? Even a single server can...
2015-06-16
1,570 reads
Blog Posts
The Company Meeting
I’m leaving today for a trip to Cambridge, UK. I do this 2-3 times a year, but this one is...
2015-06-16
631 reads
T-SQL Tuesday #67 – Extended Events
This month’s T-SQL Tuesday topic is about extended events and comes from Jes Borland (B|T).
Like in most environments, we utilize...
2015-06-16 (first published: 2015-06-09)
1,889 reads
A walk-through of creating the Activity Tracking template using Extended Events.
It’s the second Tuesday of the month and that means T-SQL Tuesday time! T-SQL Tuesday is a blog party started...
2015-06-15 (first published: 2015-06-09)
2,336 reads
Adventures with NOLOCK
Some of the beauty of being a database professional is the opportunity to deal with our friend NOLOCK. For one reason or another this query directive (yes I am calling...
2015-06-15
10 reads
Check out SIOS iQ!
I’m learning how beneficial SIOS iQ is to your virtual SQL Server environments, and you should too.
SIOS iQ is a new...
2015-06-15
531 reads
Columnstore Indexes – part 56 (“New DMV’s in SQL Server 2016”)
Continuation from the previous 55 parts, the whole series can be found at http://www.nikoport.com/columnstore/
Before starting to dive into the specific...
2015-06-15
681 reads
Marketing Materials for PASS Chapters
I brought this back with me from SQLSaturday South Florida. It’s postcard sized and laminated, and information dense in a...
2015-06-15
418 reads
Notes From SQLSaturday #379
Notes from the trip:
Made the trip down without stopping and without getting stuck in traffic – a first!Attended speaker dinner on...
2015-06-15
356 reads
Rename a database
Renaming a database isn’t something you do frequently but it does have bit of a gotcha. First of all let’s...
2015-06-15
613 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
BCA KCP Summarecon Mall Serpong Telp:0821°7555°651
Telp&Wa 628217555651 Down Town Walk, Summarecon Mal Serpong Unit DGF, Jl. Boulevard Raya Gading...
Alamat BCA KCP ITC BSD Telp:0821°8200°203
Telp&Wa 628218200203 Ruko ITC BSD, Jl. Pahlawan Seribu Blok R No. 41 & 42,...
Alamat BCA KCU ALAM SUTERA Telp:0821°8200°233
Telp&Wa 628218200233 Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec. Serpong, Kota...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers