Pairing your on-prem SQL Server with a cloud-based instance for high availability has its challenges, but they can be overcome. Here’s how. The geographic distribution of cloud data centers makes it ...

Well, in version R2, the tool offers a new way of looking at managing your server databases. Here's what you'll drool over. I've mentioned the SQL Server Utility briefly in past posts, but I want to ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

When trying to install SolidWorks on a Windows computer, you may encounter an issue when the installation is trying to install Microsoft SQL Server. So, the installation works fine until it reaches ...

Organizations can use SQL Server to reduce downtime, manage and secure databases, and discover patterns in mission-critical information to improve business intelligence. To rebuild a corrupted master ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Microsoft's relational database engine has had the same licensing model since 2012. The new version released this week brings significant changes that brings SQL Server closer to Azure SQL's licensing ...

Microsoft announced today that SQL Server 2008 R2 is released to manufacturing just 20 months after SQL Server 2008, the platform on which it is built. SQL Server 2008 R2 (codenamed Kilimanjaro) ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...

Organizations running SQL Server 2005 will be cut off when it comes to official support next year, Microsoft announced this week. SQL Server 2005 will exit its "extended support" product lifecycle ...