SQL in the City Streamed: June 2018
Next week, Redgate Software, will be putting on SQL in the City Streamed. These events are a great way to...
2018-06-07
274 reads
The Scary DBA
Extended Events, the system_health Session, and Waits
I advocate for, use, document, teach, and just downright love, Extended Events. They are so much better than the old...
2018-06-04
364 reads
Query To Retrieve Statistics Data: dm_db_stats_histogram
Starting with SQL Server 2016 Sp1 CU2, a new way of directly querying statistics, specifically the histogram, has been introduced:...
2018-06-11 (first published: 2018-05-29)
2,166 reads
Why PASS?
In case this is your first time hearing of it, PASS is the single largest community of Microsoft Data Platform...
2018-05-21
716 reads
A View Will Not Make Your Query Faster
Twice recently, one on a blog post, and one in a forum post, I’ve seen people state, unequivocally, without reservation...
2018-05-14
324 reads
YouTube Channel Update: 11 May 2018
I’ve been busy getting the videos up on YouTube. If they’re helpful to you, please subscribe. Some point soon I’ll...
2018-05-11
231 reads
When Simple Parameterization…Isn’t
I’m desperately working to finish up a new version of my book on Execution Plans. We’re close, so close. However,...
2018-05-16 (first published: 2018-05-07)
2,591 reads
Automating Automatic Indexing in Azure SQL Database
I’ve been in love with the concept of a database as a service ever since I first laid eyes on...
2018-05-07 (first published: 2018-04-30)
1,953 reads
YouTube Channel Update: 27 April 2018
Despite a hiccup recently on Twitter where I managed to spam all my followers with links to my YouTube videos...
2018-04-27
470 reads
Presentation Tools
Let’s face it, the core of a presentation is you. Your knowledge and your ability to share that knowledge through...
2018-04-23
301 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