Have you ever received the dreaded error from SQL Server that the TempDB log file is full? Only to open SSMS and be greeted with a message that prevents you from connecting. Oh no.. my number one troubleshooting tool is not usable. Time to fire up a command prompt and connect via DAC, right? Well, Read More …
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?” What’s your first move? For me, it starts with the SQL Server Error log. I zero in on the timeframe the requester mentioned and begin my investigation. Quick Review via SSMS For a fast, no frills check: Connect to the server Read More …
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs encounter: accessing a SQL Server instance when you don’t have the SA password, and no login has SysAdmin privileges. Problem Have you ever inherited a SQL Server instance or been called in to troubleshoot, only to discover that no one has Read More …
Hello, again reader… Today, I will discuss a gotcha I ran across with SQL Server Temporal Tables. In my day-to-day environment, we do not use Temporal Tables widely. However, a few are in use, and a few are coming down the pipeline for new projects. If you have not heard of Temporal Tables, you can Read More …
Good morning dear reader. Today I am writing this blog while sitting at a trampoline park. My six-year-old son loves this place, and we tend to find ourselves here at least one day, most weekends. The discussion on tap for today is about SQL Transactional Replication. Recently, I had a request in my work queue Read More …
Have you ever run across an issue that made you take a step back and scratch your head? Recently, I had this exact situation hit my Inbox. One of the development servers started alerting due to the Index Maintenace job failing. The first day, I ignored it because it was a development server. On day Read More …
No, No, not those dumps: SQL Server Memory dumps!! Recently, I was on Slack and wondered into the #firstresponderkit channel. I am a big fan of all the First Responder Kit utilities by Brent Ozar ( b | t ). I don’t usually poke my head in this channel. This particular day I was browsing Read More …
Recently, I was alerted to a network file share that was running low on disk space. This interesting as there was only one process that used this particular location to store SQL Backups. We have a nightly job that runs full copy only backups of a couple critical databases that are scrubbed and restored to Read More …
Do you frequently use the “log_reuse_wait_type_desc” column in the sys.databases view? Have you ever seen the type of OLDEST_PAGE? You are not the only one!! Recently I was troubleshooting an issue with a database where the log was growing and the virtual logs would not clear after executing a transaction log backup. So I took Read More …
Two weeks ago I was on-call and at 4:45AM Saturday morning my phone rang and the dreaded contact “NOC” was on the screen. After finding my phone and answering, the NOC technician explained that we had a Tier 2 server that had the log drive out of space. After letting them know I would check Read More …
