All Day, Training Day at SQLBits
It’s a somewhat late addition, but I have an all-day Training Day at SQLBits. It takes place on Thursday, February...
2019-01-23
236 reads
The Scary DBA
Critiquing Grant Fritchey: Circa 2008
For several years, I ran a regular feature on this blog, Speaker of the Month. I attend a lot of...
2019-01-22
163 reads
Get Your Learn On
There is one truth that I can say about technology with an absolute certainty: It’s going to change. Get your...
2019-01-21
156 reads
DevOps and Automation Will Eliminate the DBA
I’ve been reading about the death of the DBA ever since I first made the jump from full time developer...
2019-01-23 (first published: 2019-01-14)
2,693 reads
PowerShell to Simulate Load
Gathering metrics is quite difficult if there are no queries. So, if you’re working in non-production environments, but you still...
2019-01-17 (first published: 2019-01-07)
2,334 reads
Redgate Reviews 2018, Predicts 2019
Our boss came to us and said, “We need one more webinar to round out the year.” Well, we’re just...
2018-12-17
176 reads
Privacy and Protection in the Age of the GDPR
We’re seeing more and more GDPR-style laws coming out from various governments. With the GDPR starting to do enforcement at...
2018-12-10
241 reads
Database Fundamentals #20: Using the JOIN Operator, Inner Join
It is entirely possible to try to JOIN two tables on almost any field, as long as the two data...
2018-12-21 (first published: 2018-12-03)
2,522 reads
Forcing a Plan That Has a Plan Guide
The question that came up during a recent class I was teaching was: What if you have a plan guide...
2018-12-11 (first published: 2018-11-26)
1,821 reads
Query Store and Plan Cache Plans Compared
Query Store plans and the plans in cache are identical, right? There won’t be differences because the plan that is...
2018-12-03 (first published: 2018-11-19)
2,019 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