Corrupt Temporary Statistics in SQL Server 2014 Readable Replica
Earlier this week, the Database Strategy Team at my company was contacted about queries that were failing on one specific...
2015-12-10
1,600 reads
Blog Posts
DBA Myths: Database file extentions
Every now and again I hear or read that the only file extensions for a SQL Server database are mdf,...
2015-12-10 (first published: 2015-12-02)
2,328 reads
Performance Tuning with sp_BlitzIndex
Just a small blog post about how I used sp_BlitzIndex for the first and how awesome that was. sp_BlitzIndex is one...
2015-12-10 (first published: 2015-12-07)
3,283 reads
Promote Community
When I present at any given event, I generally assume that the people attending have heard of the event that...
2015-12-10
492 reads
SQL F.A.D. – Trace flag 834 and columnstore indexes - Syndication – WaterOx Consulting
Trace flags can be good Are special codes we, the DBA, can use to change the way the SQL Server...
2015-12-10
573 reads
SQL Server – Trace flag changes in Dynamic data masking in SQL Server 2016 CTP 3.0
Hi friends, In new CTP version SQL server 2016 which is 3.0, I was trying to explore the new masking...
2015-12-10
486 reads
SQLSaturday Message Templates – Copy From Other Events
For those of you with access to the SQLSaturday admin site (used by event leaders) one of the things you...
2015-12-10
599 reads
The Hour of Code 2015
This year I was interested to see that they did the Hour of Code in the elementary school my daughter...
2015-12-10
634 reads
T-SQL Clippy
I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a...
2015-12-10
39 reads
T-SQL Clippy
I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a...
2015-12-10
37 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