Is Your Data Open to Abuse? T-SQL Tuesday
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-03-24 (first published: 2017-03-14)
1,885 reads
TempDB Multiple Datafiles
Problem
Most DBAs are aware that (prior to SQL 2016) one of the most common, post installation changes that needs to...
2017-03-28 (first published: 2017-03-14)
5,987 reads
Google Cloud Spanner – Next big thing in the database world?
Last month Google announced the public beta for Cloud Spanner, and I would like to share few details around this since it’s a big news! So, what exactly is...
2017-03-14
14 reads
Google Cloud Spanner – Next big thing in the database world?
Last month Google announced the public beta for Cloud Spanner, and I would like to share few details around this...
2017-03-14
788 reads
Extreme situations require extreme commands
The title is adapted from a child-hood movie of mine and is my daily (database-related) WTF moment and it is...
2017-03-14
383 reads
A Collection of SQL Server Help Scripts
[read this post on Mr. Fox SQL blog] Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked on or used SQL Server they will likely have...
2017-03-13
18 reads
A Collection of SQL Server Help Scripts
[read this post on Mr. Fox SQL blog]
Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked...
2017-03-13
1,517 reads
Using tSQLt to Find Min/Max Times
I love tSQLt. It’s a good way to write tests that can determine if your code is actually working. Since...
2017-03-13
1,148 reads
Using Virtual Desktops for Presentations
Today I was reading William Durkin‘s fine post on Presentation Mode in SSMS vNext when inspiration struck.
One of the things that...
2017-03-13
511 reads
Why You Should Change the Cost Threshold for Parallelism
I’ve written several times about the Cost Threshold for Parallelism and it’s relationship to your execution plans, how to determine...
2017-03-23 (first published: 2017-03-13)
3,118 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