Joel Snyder, Ph.D., is a senior IT consultant with 30 years of practice. An internationally recognized expert in the areas of security, messaging and networks, Dr. Snyder is a popular speaker and ...

“We need seven nines of availability. By the way, our budget is $14.” Customer with lofty High Availability (HA) goals and no real budget to support it, unfortunately, is a common scenario for IT ...

Here’s one big advantage to moving to Microsoft Azure SQL Database—you never have to patch. That’s right. The various SKUs available in Azure’s Platform-as-a-Service (PaaS) offering are automatically ...

Each version of Microsoft’s SQL Server comes with five years of full support, followed by five years of security-only updates. Here are five questions to ask before your next upgrade. 1. Should My ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

I am looking for suggestions on an alternative product for comparing SQL schema and data with Microsoft SQL server (2012). Up to this point in time our company has used Red Gate SQL Compare and SQL ...

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

Joel Snyder, Ph.D., is a senior IT consultant with 30 years of practice. An internationally recognized expert in the areas of security, messaging and networks, Dr. Snyder is a popular speaker and ...