SQL Server, Analytics, .Net, Machine Learning, R, Python
Mitch Wheat has been working as a professional programmer since 1984, graduating with a honours degree in Mathematics from Warwick University, UK in 1986. He moved to Perth in 1995, having worked in software houses in London and Rotterdam. He has worked in the areas of mining, electronics, research, defence, financial, GIS, telecommunications, engineering, and information management. Mitch has worked mainly with Microsoft technologies (since Windows version 3.0) but has also used UNIX. He holds the following Microsoft certifications: MCPD (Web and Windows) using C# and SQL Server MCITP (Admin and Developer). His preferred development environment is C#, .Net Framework and SQL Server. Mitch has worked as an independent consultant for the last 10 years, and is currently involved with helping teams improve their Software Development Life Cycle. His areas of special interest lie in performance tuning
Thursday, February 12, 2009
SQL Server Management Studio Tools Pack
Every so often in the middle of a task, you can get stymied by the simplest of things and by the time you've spent 15 minutes looking for a shortcut, you give in to temptation and go off at a tangent to try and solve the minor problem yourself.
Some time ago I wrote a simple and easy to use generic tool to script out a Table/Database as INSERT statements. Well, I couldn't find it today! After downloading 2 scripts that wouldn't work for some undiscovered reason(!), I resisted the temptation to knock something up, did a quick search and found Mladen Prajdić's SMSS Tools Pack 1.5. Not only does it have the generate a table as INSERTS as a right-click action within SSMS but a whole lot of other really nice to have features (the full feature list is here), including Window Connection Coloring.
It's available for SQL Server 2005 and 2008 in full or Express versions.
MSN, Email: mitch døt wheat at gmail.com