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-02-24
373 reads
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,491 reads
Speaking at SQLBits and SQLRally
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
458 reads
Preparing a Technical Session Part 3: Writing an Abstract
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,534 reads
How easy to determine table dependencies ? TIP # 86
Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which ...
2015-02-24
532 reads
Missing Full Text Extensions in Express
I was tasked recently with removing the full text indexes in Adventureworks for a demo. The full text indexes were...
2015-02-23
994 reads
Book Review: Virtualizing SQL Server with VMware
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,378 reads
Exam Prep 70-463: Variables and Parameters
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,068 reads
Join me for Dashboards in a Day
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,255 reads
Tales of a DBA fed up with NOLOCK. Part 2
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,513 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers