DBA 101: Comparing two SQL plans
Simple post today: How to compare two plans in SSMS.
This task is a task that is often done by a...
2017-04-18 (first published: 2017-04-14)
2,049 reads
Blog Posts
Dropping Foreign Keys The Lazy Way
Hello!
So, on another blog a long time ago, I wrote a couple of posts about foreign keys and what step...
2017-04-18
132 reads
How to write understandable code for your future self
This story originally appeared in Hacker Noon on February 10, 2017.
I can't tell you the number of times the title of this post has crossed my mind as I...
2017-04-18
25 reads
I’m Speaking! Code PaLOUsa!
This summer I’m going to try something a little different. I’ll be speaking at a technology conference that is not...
2017-04-18
376 reads
Power BI and Data Security – Compliance and Encryption
As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern....
2017-04-18 (first published: 2017-04-10)
1,559 reads
2017-04-18
253 reads
The Connection to the Primary Replica is not Active
In this post, I’m going to talk an issue that I found when joining replica or database on secondary replica...
2017-04-18
1,727 reads
The Connection to the Primary Replica is not Active
In this post, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group. This error mostly appears when we...
2017-04-18
21 reads
T-SQL Tuesday 89 – Roundup
I asked the SQL Server community to write about their experience/opinion about the changing world we live in and how...
2017-04-18
428 reads
Tuning Parallelism on SQL Server
Thoughts on how to think about parallelism in SQL Server - and how to tune it.
2017-04-18
20 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers