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
Blog Posts
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
Data compression
This post examines the compression of a database named Bankware (BW) at a client site. The database size was 300+...
2015-03-04
281 reads
Data compression
This post examines the compression of a database named Bankware (BW) at a client site. The database size was 300+ GB. The tests for BW were done on the sk-bankware server...
2015-03-04
21 reads
Data compression
This post examines the compression of a database named Bankware (BW) at a client site. The database size was about...
2015-03-04
732 reads
Data compression
This post examines the compression of a database named Bankware (BW) at a client site. The database size was 300+ GB. The tests for BW were done on the sk-bankware server...
2015-03-04
21 reads
I want to blog but …
I don’t know how to get started.
Pretty simple. There are a number of free blogging sites out there. Personally I...
2015-03-04
672 reads
Latches, Spinlocks & Lock-Free Data Structures – my SQLRally Nordic session
Whew, this was an intensive session about Latches, Spinlocks & Lock-Free Data Structures at the SQLRally Nordic conference in Copenhagen. I...
2015-03-04
589 reads
Presenting with Tegile at Lincoln SQL Server Users Group Thursday
This Thursday I will be joining an open discussion with Tegile Systems and the Lincoln SQL Server Users Group on...
2015-03-04
475 reads
Small presenter tip: changing display mode automatically after presenter view
This morning Adam Machanic (blog | twitter) asked the following question on Twitter:
Anyone know if it's possible to configure PowerPoint 2013...
2015-03-04
690 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