Value stream management involves people in the organization to examine workflows and other processes to ensure they are deriving the maximum value from their efforts while eliminating waste — of ...

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

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

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.

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

I have a bunch of phone number fields which for reasons beyond my control STORED THE FORMATTING DATA IN THE DATABASE (DAMN YOU WINDOWS 98 BRING BILL GATES IN HERE ...