SQLServerCentral.com Content tagged Editorial, T-SQL

Old Dog, New Tricks

Thu, 02 Feb 2012 07:00:00 UT

Steve Jones learns a new trick working with T-SQL, and is surprised how easy it is. He recommends you work on updating your skills over time as well.

Implicit and Explicit Conversions

Thu, 17 Mar 2011 06:00:00 UT

Code that depends on implicit conversions can live for years in production without issue. However Steve Jones says that you shouldn't depend on these conversions

More Triggers

Fri, 12 Nov 2010 07:00:00 UT

This Friday Steve Jones talks about database design and specifically asks how you prefer to design triggers.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

The Real SQL Server Experts

Mon, 25 May 2009 06:00:00 UT

T-SQL is not a language to be admired from a distance for its grace, sophistication and integrity. It is a tool designed to allow "normal" developers and DBAs to build database business applications as smoothly and efficiently as possible.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Online T-SQL Scripts and Copyright

Mon, 20 Apr 2009 06:00:00 UT

The issue of copyright for online scripts is a grey area. If a script is published without any form of copyright notice, most people assume that it is freely available for reuse. It's not necessarily the case.

Falling Over our Assumptions

Wed, 08 Apr 2009 06:00:00 UT

There's a saying about what it says about a person to assume something. However it's something we all do every day. Phil Factor brings us a guest editorial about assumptions in SQL code.

The T-SQL Paradigm

Fri, 03 Apr 2009 06:00:00 UT

This Friday, Steve Jones looks for opinions on what you think of the T-SQL language. Is it well structured or does it really need help?

Guest editorial: SQL Code Metrics

Tue, 17 Feb 2009 07:00:00 UT

In which Phil Factor toys with the thought of producing quality metrics for SQL code, before dismissing the idea as foolhardy.