6 Techniques For Troubleshooting Your Code
This post is a response to this month’s T-SQL Tuesday #105 prompt by Wayne Sheffield. T-SQL Tuesday is a way...
2018-08-30 (first published: 2018-08-14)
3,832 reads
Blog Posts
ARM vs Classic Deployment in Azure
When Azure Resource Manager (ARM) was created back in 2014, I (like many) thought, “What does that mean?” Up until...
2018-08-30
304 reads
Async Network IO SQL Wait
Over the last few days we have been tracking down the cause of some really high async network IO waits. ...
2018-08-30 (first published: 2018-08-15)
3,028 reads
Custom Data Purging in SQL Monitor
In talking to a customer recently, they were worried about the amount of data kept by SQL Monitor. That’s a...
2018-08-30
407 reads
Helpful Undocumented Stored Procedure “sp_MsForEachDB”
This week’s post will be a short one to talk about a very helpful stored procedure in SQL Server called...
2018-08-30
278 reads
Maps in Power BI. Do I really need them?
(2018-Aug-30) While preparing for a recent Power BI Toronto meetup session, I found a very valuable whitepaper on Maps in...
2018-08-30
1,117 reads
Repair Visual Studio for Mac: Extension node not found in path
A few months ago I ran into a problem after updating Visual Studio for Mac, where it would not start....
2018-08-30
347 reads
Talking Data: Six Word Stories
In six words, can you give a compelling description of your data?
I’m taking the Microsoft DAT248x course as part of...
2018-08-30
326 reads
The unwanted Side Effects of enabling Read Committed Snapshot Isolation
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-08-30
2,165 reads
A software architect replaces a relational database with a relational database
Content warning: This is the second (and final) rebuttal essay about why someone is wrong on the Internet. It is...
2018-08-29
308 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers