Disk Benchmarking with SQLIO
Benchmark your server's storage with various block-sizes and centralize the results foe easy analysis.
Created: 1/16/2015
Dial-up Sounds Explained
Ever wondered what all that noise was when establishing a dial-up connection?
Created: 2/5/2014
SQL Server Virtual File Stats
Easily view the cumulative I/O stats for each SQL Server database file.
Created: 8/17/2013
Bringing RESTful Services to C++ Developers
Bringing RESTful Services to C++ Developers
Created: 8/12/2013
Simple Debugging with AllocConsole
AllocConsole is a debuggers friend - now made easier with STD-I/O redirection.
Created: 2/20/2013
Java is a Horrible Language
Linus Torvalds, the creator of my second favorate operating system expresses discontent with java - and I couldn't agree more.
Created: 2/17/2013
Enable or Disable Schema Replication
A straight forward approach to enabling of disabling the automatic replication of schema changes in transactional replication.
Created: 2/10/2013
Page Splits per-Second Over Time
A script to get you on the easy road to page-split baselining.
Created: 2/9/2013
Alter the Fill Factor on all GUID Columns
Easily decrease the fill factors on all of those uniqueidentifier/GUID columns.
Created: 2/9/2013
Finding Duplicate SQL Statistics
A quick and efficient view to find duplicate statistics on your SQL Server tables.
Created: 2/9/2013
Finding Duplicate SQL Indexes
A quick and efficient view to find duplicate indexes on your SQL Server tables.
Created: 2/9/2013
Get Table Row Counts
A script to quickly retrieve the count of rows from all tables in a database.
Created: 2/9/2013
Read File as Table
Allows you to easily select from a file on the file system as if it were a table.
Created: 2/9/2013
Split Array
SplitArray is a powerful table SQL function which splits delimited values into a row-set.
Created: 2/9/2013
Get First and Last day of Month
Two simple functions to get the first and last day of a month.
Created: 2/9/2013
Format Currency
Easy currency formatting of numbers in SQL Server using a scalar function.
Created: 2/9/2013
Format Number and Decimal Value
Easy formatting of numbers in SQL Server using a scalar function.
Created: 2/9/2013
String and Numeric Padding
SQL functions used to left and right pad a values with 0s (or some other value),
Created: 2/9/2013