To wrap up the series on Database Deployment Challenges, Alexander takes a dive into the details of how he scripted a solution and comes up with several practical tips for getting the most out of any automated database deployment framework.… Read more
Often, an existing database application must evolve quickly by incremental steps. Alex describes a tried and tested system to provide an automated approach to deploying both new and existing database systems, whilst dealing with common security and configuration issues. … Read more
PowerShell has radically improved the ease of monitoring and adminstering Windows-based servers, and automating routine processes. The visionary leader of this project is Jeffery Snover, who is now Lead Architect for both Windows Server and System Center Datacenter. … Read more
When you are using SSIS, there soon comes a time when you are confronted with having to do a tricky task such as searching for particular connection strings in all your SSIS packages, or checking the execution history of scheduled SSIS jobs. You can do this type of work effectively in TSQL as Feodor explains.… Read more