Data Warehouse from the Ground Up at SQL Saturday Orlando, FL on Oct. 10th
SQL Saturday #442 is upon us and yours truly will be presenting in Orlando, Florida on October 10th alongside Mitchell...
2015-09-29
1,025 reads
Blog Posts
Fixing MSI errors during patching
Patching is an activity that is frequently performed by DBA’s. It is the responsibility of a DBA to keep the...
2015-09-29
22,807 reads
Load Testing Your Storage Subsystem with Diskspd – Part II
In this post we’re going discuss how to implement load testing of your storage subsystem with DiskSpd. We’re going to craft tests to measure bandwidth and latency for specific...
2015-09-29
12 reads
Pratical Use of a SQL Server Database Snapshot
I was doing a database code deployment the other night and the first step in the release plan was “Take...
2015-09-29 (first published: 2015-09-23)
7,098 reads
Predicate Order is Critical
I have mentioned predicate order previously and wanted to make sure I drive home the importance of the predicate order...
2015-09-29 (first published: 2015-09-23)
3,192 reads
Session Event Metadata
There is a wonderful amount of metadata available to be perused in Extended Events. Part of the trick is to know where and how to find it. In this...
2015-09-29
4 reads
Deployed Session Settings
Deployed Session Settings are stored within the system databases and then exposed via system catalog views. These settings help define a session. This article shows how to access those...
2015-09-28
8 reads
Exercism
I’ve been looking to work on my programming skills a bit and try some new languages. I’d like to grow...
2015-09-28
871 reads
Exercism
I’ve been looking to work on my programming skills a bit and try some new languages. I’d like to grow...
2015-09-28
483 reads
PASS Summit 2015: Recommendations and Invitations (#sqlpass #Summit15)
The last week of October, we’ll be at the PASS Summit in Seattle, WA. As some of you already know – and as I...
2015-09-28 (first published: 2015-09-09)
1,262 reads
Blogs
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...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers