Browse by Tags

• .NET
• Testing
• Tools

• A Little Bit Scripting Saves the Day

  Recently, I got sucked into importing Excel sheets into a database. I had thought, well that's easy with a tool such as SQL Server 2000 DTS Import/Export Wizard or SQL Server 2005 Import/Export Wizard. Needless to say, the Excel import business ran into Read More... Posted Tuesday, March 06, 2007 12:06 AM by Linchi Shea | 3 Comments Filed under: Scripts, Perl, Tools

• Parse the sqlio.exe Output

  Let's say you run sqlio.exe as follows: D:\sqlIO -kW -t32 -s30 -dE -o1 -fsequential -b8 -BH -LS Testfile.dat The output typically may look like this: sqlio v1.5.SG using system counter for latency timings, 1999980000 counts per second 32 threads writing Read More... Posted Wednesday, February 21, 2007 11:12 PM by Linchi Shea | 4 Comments Filed under: Testing, Scripts, Perl, Tools Attachment(s): grepSQLIO.zip

• Msql -- A Little Wrapper Goes a Long Way

  Have you ever run into a situation where you'd like to search many of your SQL Server instances to look for a specific piece of information? Ideally, you should maintain an inventory database of all your SQL Server instances so that all you need to do Read More... Posted Tuesday, January 09, 2007 9:37 AM by Linchi Shea | 3 Comments Filed under: Scripts, Perl, Tools, .NET Attachment(s): msql.zip