This book aims to provide SQL developers with knowledge to get the most out of SQL Server 2012. How does it fare? From the book’s title I expected an in-depth discussion of the various aspects of the ...

In part 1, we looked at generating T-SQL style code. In part 2, let's get this thing to run! Last time, I showed how a single SELECT statement can be built to create an executable string of T-SQL.

Every release of SQL Server results in a more robust programming environment. SQL Server 2000 continues with that tradition, including many enhancements that strengthen the productivity and ...

I've been playing around with the new Microsoft service, currently in preview and it's time to show off what it can do. Have you ever struggled with a database performance problem or ever struggled to ...

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

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.

Despite a misleading title, this book aims to provide SQL developers with the knowledge to get the most out of SQL Server 2014. Firstly, from the book’s title I expected an in-depth discussion of the ...