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
849 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
762 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
405 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,861 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,252 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,511 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
598 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,347 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,083 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,131 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers