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

Virtualizing SQL Server: 8 Things To Avoid

Last year I wrote an article for SQL Server Pro Magazine on things to avoid when virtualizing SQL Server. I finally got around to putting the article into slide format and posted it to Slideshare. You’re welcome. The full link to the slides is here: http://www.slideshare.net/ThomasLaRock/virtualizing-sql-server-8-things-to-avoid If you find that you have been doing one … Read more

Doing It Right: Performance Monitoring and Troubleshooting

Polling Versus Tracing: Which One Is Better?

You sit down at your desk. It’s 9:10AM and your coffee is still warm. There is a smell of bacon in the air. Suddenly your phone rings. The trading system is down. The time for quick thinking is now. Where would you begin to troubleshoot this scenario? A lot of people will reach for the biggest … Read more

What To Do If Your Database Catches Fire

What To Do If Your Database Catches Fire

I need to deep fry a turbaconducken. This isn’t a want, no. This is a primal need of mine. I feel so strongly about this that it’s on my bucket list. It is positioned right below hiring two private investigators to follow each other, and right above building an igloo with the Inuit. Deep frying a … Read more

Virtualizing SQL Server: 8 Things to Avoid

Today I had another article go live over at SQL Server Pro. Here is a quick excerpt: I have been involved in virtualization projects for about ten years now. In that time I have had the opportunity to track my own list of best practice items. It’s a list I share freely with customers that … Read more