Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas. SQL Server is an expensive part of your IT stack -- SQL Server Enterprise ...

Microsoft only just officially released SQL Server 2019 at its Ignite conference in Orlando, Fla., but it announced some key changes to licensing a little bit earlier. Don't worry -- they're all ...

SQL Server 2022: Here’s what you need to know Your email has been sent Three decades on, SQL Server is still a database workhorse that powers both an internal line ...

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...

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

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

Developers love database programming tips, tricks, and workarounds—especially those that slash development time or boost application performance. Here's a collection of such nuggets for developing SQL ...

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

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article introduces practical methods for ...

Fix SQL Server connection problems If you are a developer experiencing “Connect to Server” errors using SQL Server Management Studio on your local machine or development box, consult the checklist ...