Temporal tables were a new feature in SQL Server 2016. They allow for the tracking of changes without having to set up change tracking, change data capture or triggers. For certain uses, they are not a replacement for something like change data capture, but would work if the purpose is simply having a record of … Continue reading How to Configure SQL Server Temporal Tables
I recently needed to configure log shipping for multiple databases at once as part of a migration project. I turned to PowerShell to do this. But before we get to that part, this post assumes that you’ve done the upfront work to create shares for the backups to write to and for the backups to … Continue reading How To Use Powershell to Configure Multiple Databases for Log Shipping
I recently was thrust into a conundrum. I suddenly found myself in need of a speaker for a recent SQL Server Meetup this month. My co-organizer and I had one week to find a presenter, set up a new Meetup, and then publicize so people outside of Meetup would know about it. I decided that … Continue reading What I Learned From Giving My First Presentation
Dear readers, it’s been a little while since my last blog post. Life is busy and so I’ve been away for a little bit. I am hoping to get back into the swing of things with more blogging though. Here’s what I’ve been up to. Keeping a SQL Server Meetup going. I’ve been working with … Continue reading What I’ve Been Doing Recently
I am telling my story about steps I took to handle burnout, but I want to put a disclaimer at the beginning. I am not a mental health professional. Do not construe anything I say to be professional mental health advice. I’ve always wanted to be a high impact person. I want my life to … Continue reading Steps I Took To Handle Burnout
So, I realize it’s now almost April of 2021 when I’m posting this. Normally this sort of post would come out in January for the previous year. However, I have a reason for this being late and I’ll actually post about that separately. Showing My Blog Some Love In mid-2020 I decided to give my … Continue reading Top 3 Most Popular Posts of 2020
I currently manage 5 AlwaysOn Availability Groups. Two are on SQL Server 2014 and overdue for an upgrade, while three of them are on SQL Server 2017. From time to time I have run into a couple of different situations that I needed to troubleshoot and I want to tell you where to look and … Continue reading My Availability Group Database Isn’t Synchronizing
Query Store came out in SQL Server 2016. It was the next evolution of Microsoft’s attempts to provide valuable performance data. In this post you’re going to learn a bit about the history of native monitoring in SQL Server, why you should be using the Query Store, as well as how to view the information … Continue reading SQL Server Query Store Overview
Over the last 9 weeks I took you on a journey of skills and career topics related to being a SQL Server DBA. We looked at the Production DBA. We saw skills and career topics from the beginning to mid-career to Senior DBA. Then we looked at the Development DBA and their skills and career … Continue reading Measuring Your DBA Skills
Unable to Start SQL Server In my own local SQL Server I ran across a problem starting the SQL instance. I went to SQL Server configuration Manager and manually started the SQL Server instance. The UI showed the instance had started. I opened SSMS and tried to connect. And I waited, waited and waited … Continue reading Insufficient System Memory – Failed Allocate Pages