News

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.
How SQL Works SQL, the structured query language, is a programming language for communicating with databases.
SQL injection is widely known and, because so much data in databases is sensitive, can be extraordinarily high-impact. Why do developers keep writing such bugs?
Read SQL Server 101 and learn more about SQL Server’s architecture and management basics. This useful guide also covers working with the SQL Server optimizer and execution plans. Learn more.
Joey on SQL Server How To Automate Tasks in Azure SQL Database Knowing how to automate tasks in the cloud will make you a more productive DBA.
The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...
To those uninitiated in how databases work, setting up MySQL for the first time can be daunting. Nevertheless, with a few pointers and concepts, you can quickly get a new MySQL instance up and ...
To SQL or NoSQL? That’s the database question But as technological lines blur, there's not always a clear-cut answer.