Compañero Conference and SQL Modernization Roadshow
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to...
2017-09-27
555 reads
Getting a New R Package–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-06 (first published: 2017-09-27)
1,804 reads
Error – Unable to retrieve child resources in Azure Storage Explorer
Hello friends, Please find the link of this article here – https://social.technet.microsoft.com/wiki/contents/articles/40188.error-unable-to-retrieve-child-resources-in-azure-storage-explorer.aspx
2017-09-27
899 reads
Just Check ALL the Boxes
Today I ran into something on a client server I unfortunately see too often. The DBA goes through the trouble...
2017-10-05 (first published: 2017-09-27)
1,666 reads
SQL Puzzle – Prime Numbers
My goal here is to have something fun (and hopefully educational/thinky) (and yes, I did just make up the word...
2017-09-27
462 reads
Concatenation Truncation – Are your strings being truncated?
It wasn’t until recently that i paid attention to truncation during concatenation, but that’s because whenever I used concatenation before...
2017-09-27
1,226 reads
Auditing Data Access in SQL Server for GDPR Compliance
In relation to the GDPR, I’ve recently been looking at the tools available within SQL Server to support auditing our...
2017-10-05 (first published: 2017-09-26)
5,818 reads
SQL Clone, Redgate Licensing, and Cookies
SQL Clone is amazing, and it can really save time and disk space for many organizations. I’ve got a series...
2017-09-26
643 reads
Clustered vs Nonclustered: Index Fundamentals You Need To Know
Photo by Patrick Tomasso on UnsplashHow many times have you known that adding an index would improve query performance but you weren’t exactly sure which type of...
2017-09-26
1,866 reads
DELETE data on SQL Server HEAP table – Did you know…
Before I complete my question let me provide context. I've received an alert saying that a specific database could not...
2017-10-04 (first published: 2017-09-26)
2,698 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers