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. A fundamental skill for DBAs is to have ...

-- A.P. One of the criticisms directed at Microsoft is that SQL Server is so easy to use that IT pros can't take it seriously. Fortunately for our skunk works project, though, we can take full ...

Out of all the programming languages you need to learn in the IT industry, SQL is one of the most important. SQL is so integral to modern big data access and organization processes that it’s never a ...

The SQL Slammer worm (w2.SQLSlammer.worm), also known as Sapphire (F-Secure), w32.SQLexp.worm (Symantec), and Helkern (Kaspersky), exploits known vulnerabilities in Microsoft SQL 2000 servers. It has ...

SQL Server guru Denny Cherry is going to be telling stories during his upcoming session "Things You Should Never Do In Microsoft SQL Server" at the Nov. 17-22 Live! 360 conference at the Royal Pacific ...

In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server. Other profiling tools have ...

Donabel Santos is really passionate about Microsoft SQL Server. She’s a co-owner and senior SQL Server developer, database administrator, and trainer at QueryWorks Solutions, a Vancouver-based ...

Microsoft's SQL Server Migration Assistant lets you move your data and schema to different SQL Servers. Here's what you need to know about the tool. Image: Dilok/Adobe Stock The Microsoft SQL Server ...