SQL Server Clustered & NonClustered Indexes Explained
When using row level indexes there are two types Clustered and NonClustered both of which are there to make data...
2017-05-16
98 reads
What Do You Do When Performance Sucks?
So you are a SQL Server DBA, and you are responsible for a database, which gives you a hard time....
2017-05-16
572 reads
Query Store Questions From The Field
I have had several Query Store questions come in from customers lately. Some of the questions stemmed from things read...
2017-05-16
97 reads
Query Store Questions From The Field
I have had several Query Store questions come in from customers lately. Some of the questions stemmed from things read...
2017-05-16
383 reads
A (mostly) Unwired Week at #MSBuild
Part of a series looking back at Build 2017, going over the 20+ pages of notes I took.
Last week I...
2017-05-15
671 reads
Trying GO with SQL Server
Not the batch separator, but the GO language.
I’m always interested in learning new things, and GO has been one of...
2017-05-15
1,124 reads
SQL Saturday Atlanta Precon – The Complete Primer to SQL Server Virtualization & Cloud
If you are attending this year’s SQL Saturday in Atlanta, GA, on July 15, I urge you to attend my preconference training session...
2017-05-15
382 reads
Why shouldn’t I shrink my database log file?
TL;DR: It’s pretty pointless and can cause performance issues.
Let’s start by asking why you might want to shrink your log....
2017-05-15
487 reads
Creating Azure Database for MySQL and using Azure Cloud Shell
After using Microsoft SQL Server for over 10 years going back to MySQL feels weird BUT with Azure it is...
2017-05-15
392 reads
Monday Coffee 2017-05-15
After the latest cyber attack I’ve had a fun weekend making sure all my devices are fully up-to-date with the...
2017-05-15
382 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