So it came up that several of our devs are writing their TSQL entirely in code using ADO.NET and submitting their queries that way.<BR><BR>Initially the idea was sprocs for all inserts, updates, etc..

Making your T-SQL work smarter for you by having it work as a code generator. Part 1 in a series. Want to save some time writing code? Many DBAs use the trick I'm going to show you this week to: A) ...

I am using TSQL to extract data and drop it to XML. The problem is that the system consuming this XML file must have the xmlns="blah" portion appearing first, otherwise it fails. How the heck can I ...

You can be among the first to get your hands on the cool new 'Juneau' database development tools if you're willing to test them and provide feedback to Microsoft. The company is now courting TSQL ...

Get your hands on the upcoming SQL Server development tools. All you need to do is join the program and provide feedback to the mothership. You can be among the first to get your hands on the cool new ...