9 Tips for Faster SQL Server Applications

Wanna make your SQL Server applications go faster? Here are 9 simple tips that will give you a better chance for success. They’re not carved in stone, but they’re a good place to start.

Automating the Setup of the Local Developer Machine

On both Windows and Linux, the chore of setting up a development workstation can take several days, and there always seem to be a few configuration settings that get missed. You can reduce the time and tedium dramatically by automating the process by using Vagrant to set up the operating system, followed by your choice of provisioning, configuration management and orchestration applications such as Puppet, Chef, Ansible, Salt, Docker, Chocolatey and Boxstarter. Vishwas shows how to make it easy to do with Vagrant, Chocolatey and Boxstarter.

Development Delusions: That it is Enough to Build a Better Mousetrap

You've written a superb, clever, application that you are trying to encourage your colleagues to use. They're not interested. Why? You've neglected the documentation. Surely, the saying goes 'Build a better mousetrap and the world will beat a path to your door'? Nope, not without comprehensive and complete documentation and marketing, it won't. Documentation is the secret of ensuring that good software will succeed.

Extended Procs

Execute SQL Scripts in paralel for real performance tests

Ever tried to simulate a production environment in a development one but realized that you couldn't easily start 500 executions simultaneously ? This script will help you out.

usp_dependencytree

displays a graphical tree of dependencies of an object

Find Mismatched Views and Stored Procs

Find missing and mismatched views and stored procs between 2 Databases

Truncate All Tables

Script to Truncate all tables part1

Generate C# class code for table

For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.

Isolation Levels in SQL Server 2005

Isolation levels are used to prioritize the acccess to a resource. SQL Server 2005 extends upon the support for isolation levels in 2000 with several new features including an additional level.