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...

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...

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...

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...

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...

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...

SQL Code Guard v2.7 and SQL Server 2008R2: bad news and good news

Hi all!
Bad news: SQL Code Guard v2.7 is not working with SSMS from SQL Server 2008R2 (and below).
Good news: I...

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...

50 Shades of Brown – The Series

That’s right I’m cashing in on the “50 Shades” franchise and twisting it to meet my own sordid needs to...

A Handy function

If you like learning about internals use the undocumented function to get the FileID:PageID of your table rows and use...