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 ...

In-Depth Build Your Own 'Skunk Works' Business Intelligence Project with SQL Using SQL Server, you can build a BI platform without getting your organization's top brass involved. By Andrew Peterson 07 ...

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 ...

If you're in the process of planning an enterprise-wide data warehouse, proper planning is a prerequisite. But what if you're just getting started and you've got a tight, almost non-existent budget?

Microsoft last week announced a wave of new features for its data platform, along with the SQL Server 2017 name and what Microsoft calls a “production quality” beta release. Other important changes ...

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 ...

I had the pleasure to spend some time with my old friend at Microsoft, Mark Souza, while speaking at the SQL Saturday event in Dublin, Ireland. Now keep in mind that Mark and I have known each other ...

Microsoft has relied on the "better together" concept to sell Windows client and Windows Server as a package. It also has done the same with previous versions of Office and Windows. But on May 12 -- ...