PASS Excel BI VC: Improvements to Excel Pivot Table

Please join the PASS Excel Business Intelligence Virtual Group onn March 22nd 11AM Eastern for Microsoft’s Program manager Alexander Lahuerta....

Schedulers To Rule Them All

Sometimes things just don’t make sense.
One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled.  This...

SQL Bits in less than a month

I’m getting excited, and you should as well. Join me at a fantastic conference in the UK this spring. Register...

SQL Server: DBCC CHECKDB Command with Complete Explanation

SQL Server is used widely for the management of database. It is possible that the data gets corrupt due to...

VS Code PowerShell Snippets

Just a quick post, as much as a reminder for me as anything, but also useful to those that attended...

When NOLOCK LOCKS!

This is hardly breaking news, but it’s important to know: when using NOLOCK table hints in SQL Server, it can...

An Introduction to Containers and Docker

By Chris Gibson

This is the debut blog post  of  Chris Gibson. Chris is in expert in Microsoft  Windows and is...

Quickly Creating Test Users in SQL Server with PowerShell using the sqlserver module and dbatools

One of the most visited posts on my blog is nearly two and half years old now – Add User to...

Return to Birmingham for SQLSaturday Bham 2017!

It's been 2.5 years since I last spoke atSQLSaturday Birmingham, and I'm eager to make a return, this time with...

VMware Updates In-Guest Clocks When You Say Not To

VMware’s VMTools package has some options for synchronizing the in-guest clock with the time of the ESXi host. By default,...