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
214 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
481 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
343 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,465 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
342 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,446 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)
428 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,494 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
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers