SQLAdmin

I would like to see a list of available collations on a given SQL Server database installation, and a combination of fn_helpcollations() an...

There are several guides on how to configure the Windows Server 2008 (R2) firewall to allow SQL Server access. I would like to add some ite...

SELECT CHAR(52)+CHAR(50) AS [the_answer];

When I have to establish a database mirror or restore a database in another environment, I usually restore direct from the original backup f...

The number of Virtual Log Files (VLF) in a database is discussed by several persons. I have some listed in the Reference section below. Mic...