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

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

The Microsoft SQL Query Analyzer is part of the client tools that come with Microsoft SQL Server 2000 Enterprise Edition. It's designed to analyze the SQL queries that you or a program makes that ...

Microsoft recently updated SQL Server Data Tools (SSDT) with support for Visual Studio 2012, improved LocalDB functionality and new SSDT Power Tools. SSDT, if you're unfamiliar with it, is a ...

In the midst of my playing around with the new SQL Server Data Tools, the Visual Studio 2012 Release Candidate came out. So I thought I'd upgrade... In the midst of my playing around with the new SQL ...

SQL Server 2008 Installation Strategies and Best Practices Part 2 of 5 Greetings, last week I initiated this blog series which focuses on best practices and installation strategies when deploying SQL ...

One of the most useful features in Microsoft's System Center Operations Manager (SCOM) product is its reporting engine. Even though there is nothing overly difficult about its installation process, ...

GitHub hosts a wide range of database repositories that support developers working with database systems, SQL tools, and modern data engineering workflows. These open source database tools help power ...