Knowledge Base
Search Results ...
Automating SQL Server Patch Rollouts with PowerShell
The importance of regularly updating your SQL server cannot be overstated. With each patch, you get a host of bug fixes, security updates, and new features that can significantly improve the performance and security of your databases. However, manually pat[.....]
Cross-Site SQL Server Failover in Energy Sector DR Planning
The integrity and availability of data are of critical importance in the Energy sector. As such, Disaster Recovery (DR) planning should be at the forefront of any robust IT strategy. One of the most reliable ways to ensure data protection and high availabi[.....]
Migrating DB2 Data into SQL Server Using SSIS
The process of migrating DB2 data into SQL Server can be an intimidating task, but with the right tools and guidance, it can be achieved successfully and efficiently. One of the most reliable tools for this is SQL Server Integration Services (SSIS). SSIS i[.....]
Always On Availability Groups in SQL Server 2012: Real-World Design
Always On Availability Groups, a feature introduced in SQL Server 2012, gives you a high-availability and disaster-recovery solution. With this, you get a failover environment for a discrete set of user databases, known as availability databases. This solu[.....]
Detecting Log Shipping Latency in SQL Server 2008
Log shipping is a high availability and disaster recovery strategy that provides a disaster recovery solution at the database level. It is a process that allows you to automatically send transaction log backups from a primary database on a primary server i[.....]