CREATE DATABASE

Ever wanted to see data visually in excel without going through the complex wizard? Juice analysis has posted one of the neatest hacks to get graphical representation of data. The hack uses simple function REPT. Microsoft Excel 12 has similar functionality Read More...

Ever got lost in reading the call stack trace from .NET profiler? I do in the recursive calls to functions. Other times I just want to get a feel of the application call stack to identify which areas should I be focusing on. Josh Williams has written Read More...

Check out the CLR Profiler team's blog . It is a collection for all the great articles profiler team is writing. Some of my favorites are - VSTS FAQ is great introduction on using profiler. Using VSTS Performance Tools to Speed Up Your App (Part 1) is Read More...

Slava has written a great post on the information available in SQL Server DMV - sys.dm_os_sys_info. This is a great resource for finding Windows system information, such as the CPU tick count, hyperthread ratio, physical and virtual memory, as well as Read More...

By default, SQL Server 2005 Express Edition and SQL Server 2005 Developer Edition do not allow remote connections. To configure SQL Server 2005 to allow remote connections, complete all the following steps: Enable remote connections on the instance of Read More...