Jesse's SQL Blog

Focuses on SQL Server, especially T-SQL development and programming, with the aim of presenting projects and problems in SQL Server and the thought process behind delivering a solution.

Wednesday, June 15, 2022

Calculate Age in SQL

›

I found a very cool way on StackOverflow to calculate age in SQL: DECLARE @bday date = '6/16/1970' DECLARE @as_of date = GETDATE()...

Monday, March 14, 2022

C# SqlCommand Query Timeout

›

Intriguing article about how to fix a query timeout from a SqlCommand in C#.

Monday, March 7, 2022

Identity Functions

›

This article does a good job of summarizing the various functions you can use to grab the primary key value of the row just inserted into ...

Monday, October 11, 2021

sys.modules vs INFORMATION_SCHEMA.ROUTINES

›

One thing I have to remember is that INFORMATION_SCHEMA.ROUTINES.ROUTINE_DEFINITION only returns 4000 characters, which can mean that a sea...

Friday, May 7, 2021

How much space does all this take up?

›

Good posts on how to query the database to see how much space is used (specifically by tables, but also other types). I like this query: S...

Thursday, April 8, 2021

SQL XML String Splitter

›

I don't use this method often enough to memorize it, so I'm making a bookmark for MSSQL Tips article on how to implement. One trick...

Wednesday, January 6, 2021

MS-DOS Batch File Copy with Date-Stamped Name

›

I created a batch file to copy the compiled exe of a Winform app, and then backup the source code to an archive folder named with the date/...

›

Home

View web version

About Me

Jesse McLain: I am a database developer focusing on ETL/BI development. My technological background centers on Microsoft SQL Server technologies such as T-SQL programming, SSIS, and SSRS, but also includes Informatica, Visual Foxpro, and application development such as Visual Basic and Java. I can be reached via email at dbdvlpr@hotmail.com.

View my complete profile