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.

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.

Native support for JSON in the upcoming SQL Server 2016 was buried among the many goodies announced earlier this month for the flagship RDBMS, but it's the feature most requested by data developers, ...

DuckDB is an in-process SQL database built for speed, simplicity, and analytics. Often called the “SQLite for analytics,” it runs directly inside your application, with no server setup, and handles ...

Graph database vs. relational database In a traditional relational or SQL database, the data is organized into tables.