sql server

Pillars of PowerShell: Windows OS

Introduction This is the fifth blog post continuing the series on the Pillars of PowerShell. The previous post in the series are: Interacting Commanding Debugging Profiling The Windows Operating System (OS) is something a DBA should know and be familiar with since SQL Server has to run on top of it. I would say that on…

Disable Lock Escalation in SQL Server

If a lot of rows or pages are locked, the SQL Server escalates to a table-level lock, to save resources. Each single lock takes approx. 100 bytes. So if you have many locks it takes a lot of resources to manage them. (There is a great blog about lock escalation, if you want some more…

The First PASS Summit Bloggers’ Meetup

We are stoked to announce the first ever PASS Summit Bloggers’ Meetup! What: PASS Summit Bloggers’ Meetup 2014 When: Thursday, November 6th, 5pm – 7pm Where: Sports Restaurant & Bar, 140 4th Ave North, Suite 130, Seattle, WA 98109 How: Please comment with “COUNT ME IN” if coming — we need to know attendance numbers….