How I learned to write TSQL
Category:
tsql-programming
I primarily work with SQL Server, but my favorite book on TSQL is the one that I learned with: The Transact SQL Cookbook.
Category: tsql-programming
Can you write a story in 11 words or less?
Category:
tsql-programming
“Sam Beckett, revised: Code again, error again, monitor better.”
Using APPLY for calculations
Category:
tsql-programming
Here’s a little TSQL snack. I picked this up in a presentation by Itzik Ben-Gan at the PNWSQL user group recently, and it’s become a fast favorite.
Free Poster! Guide to SQL Server Isolation Levels
Category:
tsql-programming
Looking for the isolation levels poster? It moved, you can get it here.
Date Rounding Tactics and the Tiny Devil of SMALLDATETIME
Category:
tsql-programming
With every new year I think a little bit about time and dates. This posts looks a little more at that in TSQL.
Invalid metadata in views and user defined functions
Category:
tsql-programming
This week a question on the Twitter #sqlhelp hash tag reminded me of a detail of SQL Server that I learned the hard way, but forgot to blog about.
Review: A day of doing many things at once with @AdamMachanic
Category:
tsql-programming
At SQLPass this year I was fortunate to attend “A day of doing many things at once: Multitasking, Parallelism, and Process distribution” by Adam Machanic (blog | twitter). This was a day long post-conference.