The public cloud offers a myriad of options for providing high availability and disaster recovery protections for SQL Server database applications. Conversely, some of the options available in a ...

SQL Server instances, even if equipped with provisions like automatic backup and recovery, are not sufficiently protected against sudden, disastrous situations like multi-site database failure, ...

One configures SQL Server for high availability (HA) in anticipation of some event that will cause a critical application to go offline unexpectedly—a software glitch that causes an app to freeze or a ...

Microsoft announced on Oct. 30 that it expanded SQL Server passive use rights for organizations licensing SQL Server with Software Assurance (SA) coverage. Organizations with SA coverage on SQL Server ...

DH2i, a provider of multi-platform disaster recovery and cost improvement solutions, is being added to Microsoft's SQL Server High Availability and Disaster Recovery Partners List. The SQL Server High ...

Mike Chapple is associate teaching professor of IT, analytics and operations at the University of Notre Dame. Almost every agency business function relies on at least one database. These range from ...

With SQL Server 2000, there are myriad choices for backing up your database. Whether your database is small and changes infrequently or very large and changes rapidly, there is a backup strategy to ...

Microsoft has made a big bet this year that DRaaS will be a killer application for its Cloud OS and Azure service. Numerous players are making similar gambits. In today's new age of "always-on" ...

In SQL Server Management Studio (SSMS), you can see the SQL Server database state. Alternatively, you can use T-SQL commands to verify your database status. You can use the DATABASEPROPERTYEX function ...

With Extended Support for SQL Server 2008 and SQL Server 2008 R2 ending in July 2019, to be followed six months later by the end of Extended Support for Windows Server 2008 and 2008 R2 in January 2020 ...