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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…