ExpressProfiler for SQL server

When I installed the free SQL Server Express edition one of the tooling I missed was SQL Server Profiler which comes with the paid version of SQL Server. Today I found a nice replacement: Express Profiler. It’s simple but good enough for seeing what queries get fired to the database. And it’s small (a 140kb .exe file) and portable. So just put it on your DropBox in the <portable_apps> folder and you can use it everywhere! Have fun,

Generate random testdata with T-SQL

Writing software is step one, testing it thoroughly is also very important. Sometimes you need to have some more test data in your database to see how well it performs when the dataset gets larger. Or you want to test how well your search solution is doing or paging is done within your application. Of course you could create data by hand or create a little program to fire data insert statements to your database. But the fastest way is to create a T-SQL script. When generate test data, it’s alw... [More]