SQL Server 2005 Partitioned Tables and Indexes

While getting ready for the PASS Community Summit in Orlando this week (where I plan to talk about SQL Server 2005 Partitioned Tables/Indexes), I realized we were close but not quite ready to release the post-beta II whitepaper on MSDN. So, in preparation for PASS we decided to post a pre-release of the partitioning paper […]

PASS in Orlando, September 27 – October 1 – Are you going to be there?

Each year as the weeks approach my September trip to Florida, I hear about hurricane after hurricane. I always wonder why conferences choose September (or August or October for that matter) in Orlando?? However, having said that – I’ve been to Orlando in September for the last 3 years and the weather’s always been perfect! […]

SQL Server 2005 – Profiler with Performance Monitor Integration and a bit more with Management Studio

I began setting up for Profiler and Performance Monitor by first launching Profiler and then launching Performance Monitor within it (there’s an icon for PerfMon second from the Right or you can select Performance Monitor from the Tools Menu). I had already created a Performance Monitor Counter Log so all I needed to do was […]

SQL Server 2005 – Management Studio Scripting Option and SQLCMD (loving it!)

One of my favorite features of Management Studio is the ability to “script” a step rather than execute it. Within SQL Management Studio, each dialog has 4 different options from which to choose (these are including the typical OK/Cancel) but also add a couple more at the top of the dialog:   At the top […]