Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

Now, go to the Database tab. Assuming that your SQL Server database is running on another server, this tab will be empty. Click the Change Database button.

SQL Server system databases are stored local, but the app databases are stored on SAN storage provided by a NetApp. The NetApp is doing an asynchronous mirror to it's counterpart.

The master database houses the greatest number of system tables, although every database on an instance of SQL Server also contains system tables. Note that all system tables are not truly tables.

Outside of SQL Slammer, a poorly secured SQL Server implementation can make it easy for malicious attackers to crack applications and databases and access sensitive information.

Microsoft's SQL Server database software offers two easy-to-use functions, one of which encrypts data using a passphrase, the other decrypting it with the same passphrase.

Procedure to move Microsoft SQL Server database to a new location, painlessly, if you’re running low on disk space, added a new drive array, or just curious.

Joey on SQL Server Why Activity Monitor May Be Hurting Your SQL Server's Performance As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data.

How to Find All Scheduled Jobs in SQL. Microsoft's SQL Server database software includes a job scheduling system which lets you perform routine business activities such as reporting and database ...

It’s time for the next version of SQL Server, Microsoft’s flagship database product. The company today announced the first public preview of SQL Server 2019 and while yet another update to a ...