Esther Schindler who is the editor of the email newsletter DevSource Update recently wrote about Visual C++ and Microsoft’s LINQ Project that adds the ability to use SQL code directly in VB and C# programs (emphasis mine): Ever since the PDC, developers and the press have been talking about the LINQ technology that Microsoft showed off. …
Anyone know of a T-SQL Code Formatter?
I know I’m the tool man (with Xtras.Net) but I can’t seem to find a T-SQL code formatter and wondered if anyone else knows about one? I’m got someone inhouse who writes his SELECT, INSERT, and UPDATE statements in stored procs as if his monitor were infinitely wide, and only ever uses the tab or enter …
Features I REALLY want in TSQL, Part #3
Refactoring. Yes, I want refactoring in TSQL/SQL Server. What do I mean by Refactoring in SQL? Specifically, I want to be able to evolve my database schema without breaking the application. For me at least, I frequently evolve the naming of my database schema as I’m adding features to deployed apps, but it is really …
Features I REALLY want in TSQL, Part #2
This next feature isn’t exactly a TSQL feature, and it is not highly visionary, but after spending literally the past eight (8) hours (I kid you not) using SQL tools to manipulate data and evolve some table structures, I remembered it is something I really would like to see. What I’d like to see added …
Features I REALLY want in TSQL, Part #1
I believe SQL was invented back in the 70’s back by E.F.Codd (don’t shoot me if I’m wrong; I’m not a historian.) Given the collective wisdom about programming back then, SQL is an amazing language. I probably use TSQL more often than any other because of ad-hoc queries into my company’s SQL Server database. However …