T-SQL Tuesday #89 Invitation – The times they are a-changing
T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called...
2017-04-04
421 reads
Columnstore Indexes – part 102 (“CCI with Secondary Rowstore Indexes on SQL 2014”)
Continuation from the previous 101 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In SQL Server 2014 we have received...
2017-04-03
439 reads
Understanding Keys and Certificates with Always Encrypted
This post attempts to explain in simple terms what keys are involved in Always Encrypted, how they get used, and the implications of those facts.
2017-04-03
13 reads
Lone DBA Podcast
I recently had the pleasure of being a guest on a Podcast episode with the SQL Data Partners Carlos Chacon...
2017-04-03
354 reads
Good DevOps Books to Read
I was interviewed recently at DevOps.com talking about the database as a part of DevOps. As part of the interview,...
2017-04-03
886 reads
What Is SQL Saturday?
I was recently approached and asked, “What is SQL Saturday? I actually get asked that question more times than not...
2017-04-03
392 reads
Learning Azure From The Web
I’m working on a technical blog post that I hope to be putting up soon. I’ve run into a number...
2017-04-03
429 reads
Hiding tables in SSMS Object Explorer
Extended Properties
Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had no...
2017-04-03
517 reads
Sampling Distribution and Central Limit Theorem
In this post am going to explain (in highly simplified terms) two very important statistical concepts – the sampling distribution and central...
2017-04-03
700 reads
Test the SQL Server database collation with PowerShell and dbatools
If your server collation is different to your database collation then you may find that you get an error similar...
2017-04-03
664 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers