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.
This means that, when you understand how it works, it can be used in elegant and clever ways. As part of this, we do have to look at the link between SQL and relational databases.
Cloud providers offer a wide range of database versions, including both SQL and NoSQL options, allowing developers to select the most suitable solution for their specific application requirements.
To SQL or NoSQL? That’s the database question But as technological lines blur, there's not always a clear-cut answer.
Database connectivity gives desktop and Web applications much of their value. .NET developers have products and framework objects that can tie a front-end application to SQL Server, MySQL, Sybase, ...