If you are a SQL programmer, learning recursive SQL techniques can be a boon to your productivity. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of ...

The ability to write parts of SQL queries in natural language will help developers speed up their work, analysts say.

Note – This book abbreviates SQL Server 2008 Reporting Services as SSRS and SQL Server 2005 Reporting Services as SSRS2K5. New features available in SSRS and not in SSRS2K5 are labeled with “New in ...

The best things in life are free. Sign up for our email to enjoy your city without spending a thing (as well as some options when you’re feeling flush). Our newsletter hand-delivers the best bits to ...

SQL is a convenient way to manage and query your data, but badly written queries can tie up your database. Here are seven common SQL traps and how to avoid them. Database developers have it tough.

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception. Database engines like SQL Server are incredibly complex ...

Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works. Database ...