It’s time to switch to a new development tool for SQL Server and Azure SQL. Here’s how to get started with the MSSQL ...

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

AI thrives on data but feeding it the right data is harder than it seems. As enterprises scale their AI initiatives, they face the challenge of managing diverse data pipelines, ensuring proximity to ...

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

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS).

The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new ...

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 last several articles, I’ve been describing the benefits of reading and analyzing the benchmarking case studies vetted and released by the Transaction Processing Council (www.tpc.org). I’ve ...

Every business needs a well-designed database management tool. Finding a well-organized, functional system that allows your team to perform data-related tasks with ease is crucial to the success of ...

DBeaver is a free, open-source, cross-platform SQL client and database administration tool. It is designed to support a wide variety of SQL and NoSQL databases, including MySQL and PostgreSQL. Its key ...