9 points before backing up SQL Server databases

Backing up SQL Server Databases

 Backing up your SQL Server database is essential for protecting your data. The word Backup refers...

Choose your Hash Bucket Count very wisely in Hekaton!

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Today I have...

Free Online SQL Server Training for the Week of November 24, 2013

If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...

Friday Followup For November 22, 2013

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

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

It sure would be grand to have interesting interviews

Coincidentally, in a week of debate and thinking and writing on IT interviews and candidates, XKCD has gifted us with...

Reblog: November 15 to November 21

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...

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

Fill Factor and wasted space: Quick Tip

This is a little excessive, but here's a quick script to show you your fill factors per table that are...

JFK

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