PASS Board: Year-End Wrap-Up
This month concludes my second full year on the PASS Board of Directors and my first full year on the...
2016-12-19
418 reads
The Scary DBA
OPTIMIZE FOR Hints When Parameter Sniffing is Turned Off
While presenting recently and talking about dealing with bad Parameter Sniffing, I got the question; what happens to OPTIMIZE FOR...
2016-12-12
642 reads
Presentations for SQL Server Beginners
Tired from all those blog postsFor my final blog post in the #gettingstarted, #iwanttohelp series, I decided to curate a...
2016-12-23 (first published: 2016-12-05)
3,290 reads
Database Clone
There are a bunch of ways you could create a database clone. Backup and restore is one method. Export/Import is...
2016-12-19 (first published: 2016-11-28)
2,626 reads
PowerShell to Test a Query
So you want to do some tuning, but you’re not sure how to test a query on it’s performance. Not...
2016-11-23
1,361 reads
SQL Server on Linux: Boring
As a concept, SQL Server on Linux is thrilling. Due to this, the OS doesn’t stand in the way of...
2016-11-22
637 reads
Query Data Store Data
The data in the Query Data Store is what makes all the magic happen. From collecting the aggregate performance metrics...
2016-11-28 (first published: 2016-11-21)
1,282 reads
Book Review: Marshmallow Test
Different people approach their career in different ways. My working assumption, all the time, is that I don’t know enough...
2016-11-18
441 reads
Azure Data Platform Learning Resources
I know that more and more of you are moving more and more resources into the Azure Data Platform. In...
2016-11-09
620 reads
PASS Board Update: Post-Summit 2016
Monday
I got in on Sunday and chose to have a small dinner with a couple of friends, quiet, preparing.
Monday was...
2016-11-08
430 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