Only as Good as Your Auditor
I wrote Only as Good as Your Auditor for SQLServerCentral because its something I’ve explained to people over and over...
2017-04-04
650 reads
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
425 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
441 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
16 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
359 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
889 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
401 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
436 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
532 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
713 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers