Scriptio [http://www.codeplex.com/scriptio] is a little utility I wrote when I was unhappy with the scripting features in SQL Server 2005. The biggest problem I faced was that I couldn't script a DROP and CREATE in the same file. I'm pretty sure that&…
I'm in Germany for the PASS conference this week. We all went out to a bar in downtown Dusseldorf called Zum Schiffer (or something like that). I snapped a few pictures and wanted to get them posted for the group. [https://billg.sqlteam.com/content/images/60567-PASS%20Europe-0463_…
What a night! Mario Chalmers hits a last second three to send the game into overtime and KU rolls from there. Twenty years ago when KU won their last national championship I was at KU. I just had to head down to Lawrence and enjoy the party again. These pictures…
I attended the SQL Server 2008 launch in Los Angeles for PASS. It was VERY nice to leave sub-freezing Kansas and arrive in warm, sunny Los Angeles. My pictures of the keynote didn't turn out all that well unfortunately. The ones I took before it started turned out…
I'll be in Los Angeles for the launch this week. I'll be the PASS representative at the Heroes Community Booth in the Microsoft Pavilion. When you enter the Microsoft Pavilion we'll be all the way back in the left corner. Come by and say…
Francois Ajenstat posted today that Microsoft expects to release SQL Server 2008 to manufacturing in the third-quarter of 2008 [http://blogs.technet.com/dataplatforminsider/archive/2008/01/25/microsoft-sql-server-2008-roadmap-clarification.aspx] . > Microsoft is excited to deliver a feature complete CTP during the Heroes Happen Here launch wave and a release…
Microsoft just updated the SQL Server 2005 Best Practices Analyzer [http://www.microsoft.com/downloads/details.aspx?FamilyId=da0531e4-e94c-4991-82fa-f0e3fbd05e63] . There are over 60 new rules included in this release. You can find more information on the SQLCAT blog [http://blogs.msdn.com/sqlcat/archive/2008/01/18/sql-server-2005-best-practices-analyzer-january-2008-now-available.aspx] .…
[https://billg.sqlteam.com/content/images/60447-image_2.png]One of the joys of being a consultant is trying to keep track of remote desktop connection information for a dozen clients. Each one has multiple servers so the combination of clients, machines, user names and passwords add up quickly. Recently…
Microsoft just released an updated Read80Trace that works on SQL Server 2005. The name is simplified to just ReadTrace. ReadTrace is a command-line utility that analyzes a SQL Server trace file and summarizes performance. The new version has a more graphical interface. The original was one of the most helpful…
It looks like SQL Server 2008 CTP5 should be available for download on Friday. It's already in Connect for certain testing groups.…