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

Read and learn about the most common SQL Server services running under your OS (operating system). Tibor writes about five SQL Server database types that each perform a specific role. He also provides ...

I've been playing around with the new SQL Server Data Tools, and although many have complained about missing features compared to the "Data Dude" Visual Studio projects and other tools that SSDT ...

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?

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

Microsoft releases SSMS 22 Preview 5 with GitHub Copilot fixes and clarifies its support and update policy for developers.

At Microsoft Build, SQL Server 2025 enters public preview with major enhancements in AI integration, performance, reliability and developer tools -- reaffirming Microsoft’s continued investment in its ...

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