Is Transparent Data Encryption just security theatre?
I love theatre. In six months I am putting on two one-act plays for a local festival, because I don’t...
2017-11-08
340 reads
Five reasons to be a technology speaker
I don’t think everyone should be a technical speaker. But I wouldn’t object if everyone spent a season trying. Why be a...
2017-11-08
380 reads
Contained Databases setup
Last weekI wrote about what is a contained database, the benefits and challenges, today as promised I'll show you how to setup one, how to configure a user and...
2017-11-08
19 reads
I Thought I Was An Introvert. Turns Out I Was Anxious as #@*] (Dear SQL DBA Episode 53)
In this week’s episode, I’m not answering a reader’s question. Instead, I’m talking about my personal experience with anxiety. This episode touches on on healthcare, religion, and squishy emotions...
2017-11-08
14 reads
Power BI Custom Visuals Class (Module 76 – Image Timeline)
In this module you will learn how to use the Image Timeline Custom Visual. The Image Timeline is a great...
2017-11-21 (first published: 2017-11-08)
1,372 reads
More Collation Confusion. (tempdb)
I’ve talked about Collation Confusion before. We had the dev and test instances at one collation and the production instance...
2017-11-08
434 reads
Connecting to an Azure SQL Databases
Connecting to an Azure SQL Databases is pretty simple and straight forward,as long as you know what you need in...
2017-11-08
344 reads
What Are These Backup Settings All About?
I ran across a client the other day that had these Backup and Recovery options set like the picture below...
2017-11-08
874 reads
Why do you want to use SQL Service Broker
Why use SQL Service Broker It enables you to execute SQL Statements faster and do the real work later. SQL Server...
2017-11-08
384 reads
Columnstore Indexes – part 115 (“Bulk Load API and Pressure”)
Continuation from the previous 114 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is dedicated to the...
2017-11-08
401 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers