Brent Ozar - SQL Server DBA Rotating Header Image

Posts Tagged ‘sqlserver’

SQL Server 2008 Sucks

SQL Server 2008 is coming fast, and there’s going to be a bunch of web posts and magazine articles telling you how great it is.  I’m going to play devil’s advocate for a minute and tell you why SQL 2008 sucks.
The good stuff isn’t backwards compatible.
We can’t immediately upgrade every server in the shop.  Not [...]

SQL Server consolidation interview video

Want to watch a free 5-minute video about the basics of Microsoft SQL Server consolidation? No? Maybe you just want to see me talking with my hands while wearing a guayabera. (If you get the chance to grab one of the Quest guayaberas, grab one. They’re choice.) Either way, [...]

SQL Server Consolidation: Plan for SQL Server 2008

When you’re building a consolidation plan, stop to think about when each database will be migrated to a newer version of SQL Server.
With SQL Server 2008 coming fast, some content owners will want to move their databases to 2008 as soon as it comes out in order to take advantage of things like the resource [...]

DBA 101: Using Perfmon for SQL Performance Tuning

Database administrators need to know each SQL Server’s weakest link so we know where to focus their hardware budgets and time. On any given server, we need to know what the slowest component is, and where it’ll pay off to invest hours and dollars. This is performance tuning, and the first place to [...]