Azure Data Platform Resources
A few months ago I created a GitHub repository for the purpose of building and maintaining a list of resources...
2016-09-30
853 reads
The Scary DBA
Volunteering With PASS
I was just asked how many times I’ve been to the PASS Summit. This year will be my 12th consecutive...
2016-09-29
763 reads
Networking and the PASS Summit
PASS Summit 2016 is fast approaching. If you’re going, time to start making plans. If you’re not going, sell your...
2016-09-27
419 reads
Query Store and What Happened Earlier On Your Server
Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what...
2016-10-06 (first published: 2016-09-26)
1,876 reads
Query Store and Plan Forcing: What Do You Use It For
If you’re working with Azure SQL Database or you’ve moved into SQL Server 2016, one of the biggest new tools...
2016-09-28 (first published: 2016-09-19)
1,256 reads
The Clustered Index Is Vital To Your Database Design
This is post #9 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
You get one clustered index per table.
That...
2016-09-19 (first published: 2016-09-12)
2,514 reads
Kilt Day! PASS Summit 2016, Thursday
Thursday at the PASS Summit is Kilt Day.
This means you should wear a kilt. Whether you do it in support...
2016-09-07
600 reads
Query Store, Force Plan and “Better” Plans
I am endlessly fascinated by how the Query Store works. I love teaching it at every opportunity too. Plus, almost...
2016-09-12 (first published: 2016-09-06)
1,351 reads
Azure SQL Data Warehouse Execution Plans
Azure SQL Data Warehouse can sometimes feel like it’s completely different from SQL Server, but under the covers, it is...
2016-08-29
1,086 reads
PASS Board Update
Time for another update.
The minutes for the June in-person meeting have been approved and are now ready for your information....
2016-09-07 (first published: 2016-08-25)
1,134 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