Restoring a Database from Azure
In a previous post, I described how you can use Azure storage to store SQL Server database backup files. This...
2019-03-01
495 reads
John Morehouse | Sqlrus.com
Adding Azure VM Boot Diagnostics
A couple of weeks ago, I blogged about boot diagnostics and how they can help you troubleshoot issues when virtual...
2019-02-22
221 reads
Achievement Unlocked – SQL Bits
Several weeks ago, while on a flight traveling home from San Francisco, I received an exciting email. I had submitted...
2019-02-15
485 reads
Azure Virtual Machine Boot Diagnostics
If you have ever rebooted a virtual machine and feel like you are in the dark to it’s current state,...
2019-02-08
354 reads
Modern Hardware with 64 CPUs
In today’s world, more often then not you might run into systems that have large beefy hardware. Hundreds of gigabytes...
2019-02-21 (first published: 2019-02-01)
2,471 reads
Microsoft Update Catalog
In today’s world of database administrations, there are a plethora of tools and resources that can be available to utilize...
2019-01-25
362 reads
Finding Cluster Log Errors
Sometimes you know that a problem occurred, but the tools are not giving you the right information. If you ever...
2019-02-04 (first published: 2019-01-18)
2,586 reads
Azure – Backing up to URL
In a previous post, I talked about some of the available storage options that can be used to back up...
2019-01-14 (first published: 2019-01-04)
432 reads
Azure – Creating a storage account
Azure offers a lot of features that enable IT professionals to really enhance their environment. One feature that I really...
2019-01-08 (first published: 2018-12-28)
2,497 reads
Azure Portal Enhancements – Switching Accounts
More and more I am impressed on the Azure Portal. Microsoft continues to make enhancements to the user interface (UI)...
2018-12-21
248 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers