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

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

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.

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

Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...

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

When people who have just started learning programming or have just entered the IT industry ask me, "What should I study ...

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