Tally Table Alternatives: #SQLNewBlogger
We published an article recently at SQL Server Central on Tally Tables in Fabric from John Miner. In it he showed how this can be efficient. A day after...
2025-03-21 (first published: 2025-03-12)
6,970 reads
We published an article recently at SQL Server Central on Tally Tables in Fabric from John Miner. In it he showed how this can be efficient. A day after...
2025-03-21 (first published: 2025-03-12)
6,970 reads
2025-03-19
547 reads
This was an interesting thing I saw in a Question of the Day submission. I hadn’t thought about the issue, but apparently DATEADD truncates values rather than rounding them....
2025-03-19
141 reads
We all know security is important, but we sometimes make the job harder when we don't handle data appropriately.
2025-03-19
168 reads
I had someone reach out about generate_series() recently, saying they hadn’t realized this was a new feature in SQL Server 2022. They were wondering if it was better than...
2025-03-17 (first published: 2025-03-05)
377 reads
2025-03-17
492 reads
It can be hard to change peoples' habits and get them to adopt new technology.
2025-03-15
100 reads
I grabbed this book over the 2024 holiday season as it was on sale and recommended by the DevOps practitioners over at ITRevolution. A Radical Enterprise looks at a...
2025-03-14 (first published: 2025-02-28)
124 reads
2025-03-14
377 reads
“I’m sick of hearing about Red Gate.” The first article in the book has this title, which might seem strange, but the short piece then talks about how many...
2025-03-14
33 reads
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Comments posted to this topic are about the item Limit the Blast Radius
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers