Identifying Blocking via Extended Events
There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can...
2015-03-05 (first published: 2015-02-24)
10,520 reads
There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can...
2015-03-05 (first published: 2015-02-24)
10,520 reads
Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and...
2015-02-24
463 reads
So you’ve come up with a great idea for a session and now you have to translate that idea into...
2015-03-05 (first published: 2015-02-24)
5,538 reads
Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which ...
2015-02-24
539 reads
I was tasked recently with removing the full text indexes in Adventureworks for a demo. The full text indexes were...
2015-02-23
1,001 reads
It’s not often that you’ll see me write a lengthy book review. Most book reviews are fluff telling you to...
2015-02-23
1,389 reads
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-03-10 (first published: 2015-02-23)
8,080 reads
Seats are limited – act fast!
This week I will be hosting two free events at the Microsoft Office in Alpharetta, GA...
2015-02-23
1,268 reads
Feb 16, 2015
Dear Diary,
A few weeks back I introduced HAL002 to a database managed by some annoying devs. They were...
2015-03-04 (first published: 2015-02-23)
7,524 reads
T-SQL EXCEPT and INTERSECT
Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same...
2015-03-03 (first published: 2015-02-23)
9,054 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers