CREATE DATABASE

Ryan Byington has written an entry on changes needed for reading performance counters data when logged as non-admin on the box. Basically the change required needs adding yourself to Performance Monitor Users group. For accessing performance counter on 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...