Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

It appears that the long wait for SQL Server 2005—the successor to Microsoft's renowned SQL Server 2000—will be well worth it. SQL 2005 promises to be a polished, powerful product with significant new ...

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

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

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

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

Even if generative AI hides SQL behind the curtain, it will continue to play a critical role in how we interact with and use data. In May 1974, Donald Chamberlin and Raymond Boyce published a paper on ...

In an earlier tip I discussed how indexes can speed up processing. It's only fair that I also talk about when indexes don't help. First: Because indexes don't always help but do always increase the ...

Microsoft is integrating AI features directly into SQL Server for the first time. The new version also brings JSON support ...

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