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.

To find the database name you can pipe the output of Get-AzureSqlDatabasServer directly to Get-AzureSqlDatabase. You can see here that I'll be using a database name of myazuredatabase. [Click on image ...

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

What does database server actually mean? Find out inside PCMag's comprehensive tech and computer-related encyclopedia.

Microsoft's premade templates allows for the deployment of SQL databases without having to use complex PowerShell commands.

When I am working with an Oracle database, I still find myself using SQL*Plus for many quick and dirty database queries. In particular, I often look up constraints in SQL*Plus. In this post, I ...

Many see running SQL Server databases from Microsoft Azure or Amazon Web Services (AWS) as the best way to ensure IT performance in the face of growing data volumes and more complex analysis ...

Police in Richmond are investigating allegations that database servers containing sensitive and unencrypted customer data from the bankrupt tech retailer NCIX are being sold online.

Tim Kridel is an independent analyst and freelance writer with years of experience in covering technology, telecommunications and more. Just how much does the Department of Defense rely on Microsoft ...

What to do to avoid these problems? To protect your database and avoid the Recovery Pending error, you can take the following actions: First, save your backups in a different location. Make sure that ...