Trusting the tools!

Well, it's been a crazy few weeks! Paul and I have been booked solid with client engagements, Immersion Events, conferences and other things (like chapter editing for the upcoming SQL Server Deep Dives Volume 2) and so I've been a bit behind with blogging. I have a ToDo list of items to blog about but […]

Microsoft eLearning Resources – BI and 2008 R2

In addition to the SQL Server 2008 Database Infrastructure and Scalability content that Paul and I delivered for SQL Server 2008, and the content that our colleague Bob Beachemin (blog) delivered (Clinic 10164: Essential SQL Server 2008 for Developers), our colleague Stacia Misner (blog|twitter) also delivered content for SQL Server 2008 titled and available as: Clinic […]

Microsoft eLearning Resources – Clinic 10259 (SQL 2008 DBIS)

When SQL Server 2008 was in beta, Paul and I worked on a project to create content that would "jumpstart" folks in learning and working with SQL Server 2008. We delivered these "new features" courses at various locations and finally, we recorded the content. All of this content is now available FOR FREE from Microsoft […]

Favorite SSMS Options – and some gotchas

Whenever I setup a new machine, I like to set a few default options in SSMS. Here are my favorites: Tools, Options Environment Fonts and Colors Text Editor font: Lucida Console (a bit thicker and it's a fixed-width font) Text Editor: Selected Text (under display items) Item foreground: Black Item background: Yellow (looks like a […]

RunAsRadio Interview about Developers and DBAs – whose job is it?

A couple of weeks ago I wrote a blog post titled Whose job is it anyway? It's an interesting debate and something I've been hearing more and more – that SQL Server is a "set it and forget it" technology – a black box where you just don't need to know how it works to do […]

Database Maintenance Best Practices Part III – Transaction Log Maintenance

This is a tough topic. It's a big topic and more than any other – I think there are a lot of misunderstandings about what the log is for, why it's so critical and ESPECIALLY when/why it gets extrememly large. Simply put, it gets large when it's not managed correctly. OK, there are times when […]

Database Maintenance Best Practices Part II – Setting FILLFACTOR

When you decide to rebuild or reorganzie an index, you have an option to set something called FILLFACTOR. This is probably the MOST IMPORTANT thing to understand about index maintenance and reducing fragmentation (especially in databases that are prone to it). Unfortunately, we need to dive into some internals to really understand why this is […]

Database Maintenance Best Practices Part I – clarifying ambiguous recommendations for Sharepoint

OK, it seems as though there's A LOT of confusion about what steps are required for proper database maintenance. And, it seems as though some recommendations are being given as "quick fixes" without any real recommendation for root cause analysis. I'm not saying that the generalizations are horribly wrong but in many cases they're just […]

SQL Server 2008 Central Management Servers – have you seen these?

There's a new feature of SQL Server 2008 that during beta was called a Configuration Server… In RTM it was renamed to a Central Management Server. It's not overly obvious and without knowing how cool it can be – you might skip right by it. And, if you're using SQL Server 2008 to manage 2000, […]