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

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.

There are hundreds of notable programming languages out there, but how do you know which ones will help you earn a comfortable living as a coder? Here's a hint: master SQL. Structured Query Language ...

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

PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...