A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine's system databases. Tim Chapman discusses these system databases. A fundamental skill for DBAs is to have ...

Super-fast performance, robust toolset and better security options make Microsoft's latest database management system a must for most shops. It's easy to be overwhelmed by the raft of new features in ...

In the past, the question of how to perform auditing under SQL Server has had a simple answer: Do it yourself. But now, SQL Server 2000 has eased the burden of auditing by introducing an extensive and ...

Microsoft released SQL Server 2012 Service Pack 2 this week. The SP2 release goes by the "RTM" (release to manufacturing) nomenclature, according to Microsoft's announcement. That's an old-fashioned ...

At the upcoming Visual Studio Live! Las Vegas developer conference, SQL expert Denny Cherry will share essential indexing ...

The next-generation edition of Microsoft's flagship relational database system, SQL Server 2017, took a step closer to general availability with this week's launch of the first Release Candidate ...

Microsoft this week released SQL Server 2012 Service Pack 2. The SP2 release goes by the "RTM" (release to manufacturing) nomenclature, according to Microsoft's announcement. That's an old-fashioned ...

This article explains how to repair the MDF file using the native repair methods and how to use a Reliable MDF file Repair ...

SQL Server isn't on the kind of update schedule that characterizes Visual Studio these days, when it's unusual for two months to go by without some sort of release. But one version is getting a new ...