It’s common that users only have access to certain folders in an Azure Data Lake Storage container. These permissions are provided not through Azure RBAC (role-based access control) roles...
2021-02-09 (first published: 2021-02-04)
189 reads
Story time: A few months ago I was in a meeting where we were all asked how we could take on a complex, but very necessary task. As they...
2021-02-09
8 reads
It’s time for the fourth post in my series about performing regular server reviews. In the first post, we took a look at setting up your local environment. The...
2021-02-09
31 reads
Figma — one of the most popular and fastest growing digital design tools today — was recently voted “the most exciting design tool of 2021.” In many organizations, a...
2021-02-09
9 reads
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly...
2021-02-09
184 reads
It’s blog party week for T-SQL Tuesday, and I think this is a good choice for a topic. The host this month is Mikey Bronowski, and his invitation is...
2021-02-09
163 reads
Blog posts have been few and far between from SQL Undercover lately but what better to try and get us back in the swing again than with T-SQL Tuesday....
2021-02-09
139 reads
This month’s T-SQL Tuesday is being hosted by Mikey Bronowski. The subject he chose is “The outstanding tools of the trade that make your job awesome.” Tools are the...
2021-02-09
18 reads
It’s been a while since I’ve posted on a T-SQL Tuesday topic and glad to see the topic being discussed by Mike Bronowski (blog) on tools. Throughout my career,...
2021-02-09
154 reads
This series looks at the Advent of Code challenges. I started the Advent of Code at the beginning of December 2020, but life quickly got in the way. Weekends...
2021-02-08 (first published: 2021-01-27)
267 reads
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
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