Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

Microsoft's drive to put Azure SQL Data Warehouse on more equal footing with SQL Server is finally paying off. Azure SQL Data Warehouse gets less press than its online transaction processing brethren, ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

SQL Server 2016, the next major release of Microsoft’s flagship database and analytics platform (which is available as a Community Technology Preview [CTP] as of this writing), includes exciting ...

When you use index views in the right situations, they can dramatically improve the performance of SQL Server queries. Tim Chapman explains why performance testing is the best way to tell if indexed ...

SQL Server 2025 shifts optimisation from a reactive activity to an intelligence-driven discipline. Built-in intelligence is embedded directly into the platform, reducing reliance on external tooling.

MELBOURNE, Australia, Nov. 10, 2016 /PRNewswire/ — DataVeil Technologies, a leading provider of data masking software, has announced that DataVeil 3.4 featuring a static data masking capability for ...

REDMOND, Wash. — Feb. 23, 2009 — Microsoft Corp. today announced SQL Server Fast Track Data Warehouse, a new set of reference architectures for data warehousing that will help eliminate many of the ...

Explore how SQL Server 2025 reshapes the modern data platform with AI-ready capabilities, developer-first enhancements, hybrid modernisation and practical upgrade readiness guidance. For many years, ...

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. In a previous TechRepublic column about SQL Server ...