How many heap tables do you have? :Quick Tips

Nothing exciting, just a general script. How can you see what heaps you have laying around?

exec sp_MSforeachdb @command1 ='
use [?]
SELECT...

JFK

“There is little value in ensuring the survival of our nation if our traditions do not survive with it. And...

Guest blog post at SQLAuthority – How many vCPUs are too many?

Last night my first guest blog pots over at SQLAuthority has gone live! It is the next in the “Notes...

Powershell in a Month – Day 3 – Commands

This is part of my Powershell Challenge, to learn more about Powerhsell (PoSh) using the Learn Windows Powershell 3 in a Month...

Power BI for Office 365 video

A demonstration of Power BI for Office 365, showing you how all the various tools and technologies work together: Power...

Learn About PCI Today

I’ll be presenting PCI for the SQL DBA today at  1 pm EST for the PASS Security Virtual Chapter. Depending...

How to reset the SA password in SQL Server

Getting locked out of a SQL Server can happen in a number of ways.  You could inherit a server that...

Notes from SQLSaturday in Oregon Nov 16, 2013

I wanted to take time to thank our sponsors, speakers and volunteers for making #sqlsat265 a big success.  Over 400...

What Happens In Vegas…

…stays in Vegas, except when it comes to chocolate. After walking more than 1500 miles over the past 9 months,...

#SQLRelay 2013 R2 – Week 2

If you haven’t heard of SQL Relay and you live in the UK then shame on you. SQL Relay is...