SQL Server Diaries

Security is good.  Or to state that differently, lack of security is very bad.  So in the case of a SQL Server database, security is of the utmost importance.  For this reason DBAs work with security professionals to protect the data hosted on their servers.  The truth is that SQL... [Read More]

Or, how to recover and regain control of an SQL Server 2000 instance. [Read More]

SQL Server Integration Services (SSIS) was introduced with the 2005 version to replace the functionality of the SQL Server 2000 Data Transformation Services (DTS).  SSIS provides DBAs and database developers with the tools to create packages with which data can be exported, transformed and imported from/to various data sources such... [Read More]

During a recent database migration I encountered strange behaviour when scripting out views, stored procedures and triggers. The issue was reported by the development team who noticed that object code lines were being split into two lines. After fixing the objects affected by this problem I investigated the cause and... [Read More]

When developing application code it is always recommended that all source code is backed up, preferably using a version control application to allow for code sharing and providing a change rollback. Using a tool such as SQL Server Management Studio, a developer can store database code developed with SSMS in... [Read More]