#SQLNewBloggers
The SUM of Nothing: #SQLNewBlogger

I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that Look Too Easy. I decided to give you a few thoughts from me on the SUM one. Another post for me that is simple and hopefully serves as an example for people trying to get…
The SUM of Nothing: #SQLNewBlogger
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that Look Too Easy. I decided to give you a few thoughts from me on the SUM one. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The Sum of Nothing I am guessing more people working with SQL know that if you have a NULL in your data and try to sum the column, you get the NULL ignore.
voiceofthedba.com
October 5, 2026 at 1:00 PM
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger

I was creating a question on sp_readerrorlog and realized that this procedure is different from the one it wraps: xp_readerrorlog. This post digs into a few differences. Another post for me that is simple and hopefully serves…
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
I was creating a question on sp_readerrorlog and realized that this procedure is different from the one it wraps: xp_readerrorlog. This post digs into a few differences. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The New System Stored Procedure For most of my SQL Server career, it’s been a habit to use xp_readerrorlog to query the log.
voiceofthedba.com
September 16, 2026 at 1:00 PM
Using the SIGN() Function: #SQLNewBlogger

I was trolling the docs and noticed the SIGN() function. I have never written this in production code, but it is an interesting function. This post looks at where I might use this and when the need arises. Another post for me that is simple and hopefully…
Using the SIGN() Function: #SQLNewBlogger
I was trolling the docs and noticed the SIGN() function. I have never written this in production code, but it is an interesting function. This post looks at where I might use this and when the need arises. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
voiceofthedba.com
August 26, 2026 at 1:00 PM
Why Use TRY_PARSE(): #SQLNewBlogger

Someone asked why I would use TRY_PARSE after I posted a question at SQL Server Central: Getting the Average. Isn’t is slower? A fair question. This quick post looks at why. Another post for me that is simple and hopefully serves as an example for people trying…
Why Use TRY_PARSE(): #SQLNewBlogger
Someone asked why I would use TRY_PARSE after I posted a question at SQL Server Central: Getting the Average. Isn’t is slower? A fair question. This quick post looks at why. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. A Quick Setup The question above has the setup code, but what if I add another row?
voiceofthedba.com
August 12, 2026 at 1:01 PM
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger

I was messing around with SQLCMD and I realized something I hadn’t known. I’ve never tried it, but the batch separator has to be separate, which I’ll show. Another post for me that is simple and hopefully serves as an example for people…
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve never tried it, but the batch separator has to be separate, which I’ll show. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The Batch Terminator The default batch terminator in SQL Server tools is “GO”.
voiceofthedba.com
June 17, 2026 at 1:01 PM
Funny Money: #SQLNewBlogger

While wandering around the documentation looking for some Question of the Day topics, I learned something new about the money data type. This post discusses what I learned. Another post for me that is simple and hopefully serves as an example for people trying to get…
Funny Money: #SQLNewBlogger
While wandering around the documentation looking for some Question of the Day topics, I learned something new about the money data type. This post discusses what I learned. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The Money Type Did you know that you can add a currency symbol to the money data type for assignment?
voiceofthedba.com
June 10, 2026 at 1:01 PM
UNION vs UNIONALL: #SQLNewBlogger

While writing another post I realized my UNION query didn’t work as one might initiall expect, so I decided a short post was worth writing. This is based on a previous post on QUOTENME(). Another post for me that is simple and hopefully serves as an example for…
UNION vs UNIONALL: #SQLNewBlogger
While writing another post I realized my UNION query didn’t work as one might initiall expect, so I decided a short post was worth writing. This is based on a previous post on QUOTENME(). Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Missing a Row…
voiceofthedba.com
June 3, 2026 at 1:01 PM
Get a Range of Sequence Values: #SQLNewBlogger

I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks at how the proc works. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The…
Get a Range of Sequence Values: #SQLNewBlogger
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks at how the proc works. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The Setup I have a sequence object, IDCounter, that is an integer with an increment of 2. The next value that is returned is shown here:
voiceofthedba.com
April 22, 2026 at 1:00 PM
Identity Columns Can’t Be Updated: #SQLNewBlogger

I’m not sure I knew identity column values could not be updated. I ran into this while trying to solve a problem recently and had to check the error I was getting. This post shows what happened. Another post for me that is simple and hopefully…
Identity Columns Can’t Be Updated: #SQLNewBlogger
I’m not sure I knew identity column values could not be updated. I ran into this while trying to solve a problem recently and had to check the error I was getting. This post shows what happened. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Setup…
voiceofthedba.com
February 25, 2026 at 2:02 PM