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

In this review of Stellar Repair for MS SQL, we take a closer look at Stellar’s corporate-grade SQL repair solution, ...

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

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

SQL Server 2025 is introducing AI-native capabilities alongside new approaches for secure integration with large language models. Enterprises can now run local AI models such as Llama 3 via Ollama for ...

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

The structured query language is a powerful tool for connecting to many database systems that store data in tables organized into rows and columns. It's often used on the backend of business websites ...