State of Database DevOps Survey
Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe you’re automating all the things or maybe you’ve got a completely manual set of processes....
2019-12-06
53 reads
The Scary DBA
Tracking CPU Use Over Time
A question that I’ve seen come up frequently just recently is, how to track CPU use over time. Further, like a disk filling up, people want to know how...
2019-12-16 (first published: 2019-12-02)
665 reads
Containers: Upgrading SQL Server from 2017 to 2019 RTM
Throughout the pre-release of SQL Server 2019, I was demoing an effectively instant, and magical, container upgrade from 2017 to 2019. However, when I finally downloaded the release bits...
2019-12-05 (first published: 2019-11-25)
323 reads
Your First Jupyter Notebook
In April, I said I was going to start learning Jupyter Notebooks. It’s November. Let’s get going with your first Jupyter Notebook. A quick aside before we start. I...
2019-11-28 (first published: 2019-11-19)
717 reads
Docker, Git and DBATools
For those who don’t know, last week was the PASS Summit. It’s an amazing event every year, but this last week, I saw a ton of indications that our...
2019-11-20 (first published: 2019-11-11)
621 reads
You Are A Coder
So, you say you’re a DBA. I say you’re not. You say you’re a system administrator. I say you’re wrong. We are all coders now. Every single one of...
2019-11-04
38 reads
Talk To Me At PASS Summit 2019
I say this all the time, but shockingly few people take advantage. Say hi to me. Please. I’m going to be at PASS Summit next week. I’ll be presenting...
2019-11-01
9 reads
Well Trained Staff
I’ve had the opportunity in the last month to do a couple of different consulting visits, one private and one through my employer, Redgate. The goals of each of...
2019-10-28
19 reads
Passwords = A Good Thing
Those my friends are, in my opinion, one of the single most wonderful things on earth, white chocolate macadamia nut cookies. Now, you may not like those. So, picture...
2019-10-23
107 reads
Every Execution Plan Is An Estimated Plan
I consider myself to be the most responsible for making such a huge deal about the differences between what is labeled as an Estimated Plan and an Actual Plan....
2019-11-05 (first published: 2019-10-22)
518 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