SQL Server Diaries

I came across a tool that some might find useful.  The Forfiles on Microsoft Technet utility (forfiles.exe) is preinstalled with Windows Server 2003 and later.  Forfiles enables batch processing of files.  One use of this utility would be to delete old backup files to remove dependencies on items such as... [Read More]

Also known as Globally Unique Identifiers, GUID values consist of a string of alphanumeric values which in principle should be unique across all machines of the network.  GUID values are stored in a database table using the uniqueidentifier (Transact-SQL) data type and requires 16 bytes of storage space per row.... [Read More]

Managing SQL Server applications can be a bit tricky, especially in an enterprise scenario with tens or hundreds of applications deployed for a large user-base across geographically dispersed locations.  With a bit of planning, events such as database migrations, DBMS upgrade, or server virtualisation to name a few, can be... [Read More]

Database Mail provides functionality to send email using T-SQL and is the successor to SQL Server 2000’s SQL Mail. Although SQL Mail is still available in SQL Server 2005, it is provided for backward compatibility only and the Books Online reccomend that Database Mail is used instead. [Read More]

When performing a database migration from one SQL Server instance to another, the DBA has to transfer all logins which have access to the database.  The transfer will only be successful if the logins retain the same passwords to reduce the impact on the end users, and more specifically, the... [Read More]