Never tried SSDT, so SSMS exclusively. For one thing, it doesn't require the additional Visual Studio install if essentially all your work is directly in the database.

PRINT and temp tables +1

Having worked in software development for 29 years, I understand what Gordon is saying about testing with "blinders" and not always recognizing how a user may blunder through a piece...

I started on my current team as the "low man", over eight years ago. The team was struggling (I knew this) and was known as one of the "armpits"...

In a test environment? This is exactly what they are for! In hindsight, you may kick yourself for not seeing things that should have been incorporated. But...

I once attended a session where the process for archiving state records in Michigan was discussed. They talked about maintaining records in a digital format and having to burn...

I find interesting the impact on productivity that the current policy is having. All employees in...

I have certainly done initial development on ideas that I then released to my team for further development. The initial code worked for my situation, and was an improvement...

I've always been fascinated with making mechanical / electrical things work the way you want them to by applying the right leverage / signal in the right location and at...

Like P Jones, I've never used C / C++ in my 26 years in the IT industry But similar to P Jones, I cut my teeth on 6502 Assembler,...

I work in the city (northern Metro Detroit) but get to live in my vacation home (10 acre farm in a rural area 50 miles north of Detroit).

I’ve always been...

Andy is simply sharing what works for him. This may or may not be useful for anyone else.

There is a difference between "fitting in" as in "becoming part of...

As a boss once told me, "Some customers are determined to save money, no matter what it costs!" (Particularly true when a customer does not want to pay you...

A developer once "proved" to me how much faster CLR was. He developed a simple TSQL function and a CLR function that did equivalent things. His test script...

I am a definite DIY. I grew up on a farm, currently live on a small farm, and anyone else who has done so knows that farmers learn to...