Using a series of demos drawn from his latest book, Bill guides you through the maze of issues you'll face as you connect to, manage, and monitor SQL Server instances—including the new SQL Express ...

Microsoft SQL is a relational database you can configure to run as multiple copies, or instances, on a single computer. When running a small business, keeping multiple instances of Microsoft SQL on a ...

Hey all, got a strange questions. I've recently been handed a project to build a SQL server setup to accommodate 60, production, instances of MS SQL. We're on the verge of landing a big customer who ...

As SQL Server 2008 and 2008 R2 reach the end of support in 2019, you’ll have an opportunity to upgrade to a cloud database service. Follow this step-by-step guide to manage change effectively as you ...

Microsoft announced this week that it plans to release a "General Purpose" version of its Azure Arc-enabled SQL Managed Instance (MI) at the "general availability" (GA) commercial-release stage, ...

Maintaining a SQL Server environment is a potentially complex endeavor. Here are 10 tips for ways you can minimize complexity and reduce stress. Based on my SQL Server consulting practice, here are ...

OK, So, I have a single database residing on one server, and I have 2 *other* servers that both handle incoming data from multiple clients. I want both servers to be able to save their data into this ...

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, ...