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.

Online analytical processing databases speed up the multi-dimensional queries common in business intelligence applications.

In SQL Server 2000, we had a nifty little utility called rebuildm.exe which would rebuild the master database in emergency situations. This utility was removed in SQL Server 2005 and has not been ...

In SQL Server, the initial dialect for stored procedures (or stored procs) was Transact-SQL, aka T-SQL; in Oracle, it was PL-SQL. Both databases have added additional languages for stored ...

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.

Relational databases and the software that access them can be invaluable tools to businesses. Popular relational database management systems include Microsoft SQL Server, Oracle Database, as well ...