HOW TO: Improve Database Performance Without Changing Code

I’ve stated before that great database performance starts with great database design. So, if you want a great database design you must find someone with great database experience. But where does a person get such experience? We already know that great judgment comes from great experience, and great experience comes from bad judgment. That means … Read more

HOW TO: Restore the Master Database in SQL Server 2014

I like having a routine. Most people do, I suppose. There’s some comfort in knowing what lies ahead, what comes next. The same holds true for restoring the master database in SQL Server 2014, because it’s the same routine as what I posted for SQL Server 2012. For those of you too lazy to click … Read more

Size Matters: Table Rows and Database Data Pages

I’m on my way to the PASS Business Analytics conference today. If you are attending, and you are reading this blog post, come find me and Rob Collie (blog | @powerpivotpro) during the welcome reception on Wednesday night; we’d love to talk data. Speaking of data…I was finishing up a session at the Colorado Springs SQL Saturday recently … Read more