Retrieve OS and SQL versions, database names and database sizes

We are planning a migration of our older SQL Server databases to one of the latest versions or possibly decommission them.  To have a better idea of the environments, our management requested a report containing the operating system versions, the SQL Server versions, the database names and the database sizes... [Read More]

Fatal error while reading the input stream from the network

One of the SQL Server Alerts implemented on all instances checkd for errors with a severity level of 20 and which is described as “Fatal Error in current process”. A similar alert can be created by Right-Clicking on the “Alerts” folder under SQL Server Agent, selecting “New Alert” and filling... [Read More]

Hardening an instance might invalidate the support agreement

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]

Securing an SSIS Params Table using Keys

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]