SQL Server 2005 databases are set to the Full recovery model by default, so you may need to start creating log backups even if you haven’t ran into problems yet. The following query can be used to ...

Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't. One topic that has come up in several conversations with customers ...

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

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

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

An application that is based on Visual Studio for developing solutions for SSIS, SSAS, or SSRS is called Business Intelligence Development Studio, or BIDS. With SQL Server 2005, it was introduced. It ...

When business continuity relies on your budget. When you purchase through links on our site, we may earn an affiliate commission. Here’s how it works. “We need seven nines of availability. By the way, ...

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