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
338 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
15 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
9 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,368 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
428 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
341 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
864 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
383 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
399 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...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
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