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
406 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,348 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
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers