Exposing SQL Server Risks in 1 minute

Often we find ourselves meeting new SQL Server environments for the first time and for SQL Server Reporting and/or Business Intelligence servers this is no exception.   Whilst your role may be purely business intelligence developer, it is handy to know where the current exposure to risks are (such as recoverability) that could potentially derail […]

Searching for Extra Terrestrial SSIS or DTS Package Content

So you have your SQL 2008 R2 or SQL 2012 server up and running and  ready to pull the pin on that tired old Analysis Services.  You are concerned about something breaking when you turn out those lights for the last time.   A last minute search of any ETL packages you suspect may still […]