#SQLNewBlogger
The #MS_DatabaseConnector## Role: #SQLNewBlogger

I had seen these roles in various instances, but never dug into the new Fixed Server roles added to SQL Server. They are supposed to help ensure the principle of least privilege is followed. In this post, I look at one of these, the…
The #MS_DatabaseConnector## Role: #SQLNewBlogger
I had seen these roles in various instances, but never dug into the new Fixed Server roles added to SQL Server. They are supposed to help ensure the principle of least privilege is followed. In this post, I look at one of these, the ##MSDatabaseConnector## role. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as…
voiceofthedba.com
November 4, 2026 at 2:00 PM
Experimenting with CHOOSE: #SQLNewBlogger

I was looking over the CHOOSE() function while editing an article at SQL Server Central. I realized there isn’t a documentation note on how many parameters can be included. I decided to test. This post looks at the tests and results. Tl;dr It appears 3925…
Experimenting with CHOOSE: #SQLNewBlogger
I was looking over the CHOOSE() function while editing an article at SQL Server Central. I realized there isn’t a documentation note on how many parameters can be included. I decided to test. This post looks at the tests and results. Tl;dr It appears 3925 is the most arguments. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as…
voiceofthedba.com
October 28, 2026 at 1:00 PM
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
TRY_PARSE Limitations: #SQLNewBlogger

I got a notification from a question I’d posted at SQL Server Central: Getting the Average. A user had posted their repro didn’t work, with no real comment. As a SQLNewBlogger FYI, that type of post shows poor communication and a lack of communication. I see…
TRY_PARSE Limitations: #SQLNewBlogger
I got a notification from a question I’d posted at SQL Server Central: Getting the Average. A user had posted their repro didn’t work, with no real comment. As a SQLNewBlogger FYI, that type of post shows poor communication and a lack of communication. I see that a lot and it’s a challenge in the modern world. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as…
voiceofthedba.com
August 5, 2026 at 1:00 PM
Changing the Owner Removes Permissions: #SQLNewBlogger

This is actually inspired by an article SQL Server Central, which taught me something new. I decided to verify what was in the article and do some research. The summary tl;dr if you change the schema owner, all permissions are dropped. Another…
Changing the Owner Removes Permissions: #SQLNewBlogger
This is actually inspired by an article SQL Server Central, which taught me something new. I decided to verify what was in the article and do some research. The summary tl;dr if you change the schema owner, all permissions are dropped. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as…
voiceofthedba.com
July 15, 2026 at 1:01 PM
Capturing My Own Metrics: #SQLNewBlogger

A customer was trying to compare two tables and capture a state as a performance metric. In this case, they were wanting to use Redgate Monitor and custom metrics, but since the tables were in a Memory-Optimized table, they couldn’t as Redgate Monitor runs…
Capturing My Own Metrics: #SQLNewBlogger
A customer was trying to compare two tables and capture a state as a performance metric. In this case, they were wanting to use Redgate Monitor and custom metrics, but since the tables were in a Memory-Optimized table, they couldn’t as Redgate Monitor runs inside a transaction. Note, there are workarounds, but they’re clunky. Fortunately, I had a quick solution, which involved…
voiceofthedba.com
July 8, 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
QUOTENAME Basics: #SQLNewBlogger

Recently I ran across some code that used a lot of QUOTENAME() calls. A colleague was having some trouble with the code, but what struck me was that I hadn’t often delved into the details of QUOTENAME and how it can be used in different ways. I’d always just passed…
QUOTENAME Basics: #SQLNewBlogger
Recently I ran across some code that used a lot of QUOTENAME() calls. A colleague was having some trouble with the code, but what struck me was that I hadn’t often delved into the details of QUOTENAME and how it can be used in different ways. I’d always just passed in a string as a single parameter. This post looks at a few details of how this function works.
voiceofthedba.com
May 20, 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
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an example of why it can behave weirdly. This post looks at something you might not realize unless you remember this is an aggregate function. Another post for me…
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an example of why it can behave weirdly. This post looks at something you might not realize unless you remember this is an aggregate function. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBlogger…
voiceofthedba.com
April 15, 2026 at 1:04 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
February 18, 2026 at 2:14 PM
January 14, 2026 at 2:13 PM
Database Collation Matters for Unicode: #SQLNewBlogger voiceofthedba.com/2025/12/03/d...
December 3, 2025 at 2:22 PM
Finding the Last Last Name in SQL: #SQLNewBlogger voiceofthedba.com/2025/11/19/f...
November 19, 2025 at 2:14 PM
The Challenge of Implicit Transactions: #SQLNewBlogger voiceofthedba.com/2025/09/24/t...
September 24, 2025 at 2:12 PM
Sparse Columns Can Use More Space: #SQLNewBlogger voiceofthedba.com/2025/09/10/s...
September 10, 2025 at 1:43 PM
Adding a Named Default Constraint to a Table: #SQLNewBlogger voiceofthedba.com/2025/06/25/a...
August 11, 2025 at 1:32 PM