Skip to content
Twitter Email LinkedIn
Menu

GarryBargsley.com

GarryBargsley.com

Primary Menu

  • Home
  • About
Search

Category: Troubleshooting

SQL Temporal Tables — Gotcha!!!

Posted onNovember 1, 2022October 31, 20224 Comments

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 …

CategoriesBlogging, SQL, Troubleshooting

Transactional Replication: Where did my data go???

Posted onJuly 12, 2022July 10, 2022Leave a comment

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 …

CategoriesAzure, Blogging, SQL, Troubleshooting

SQL Agent Jobs – When Success is Failure

Posted onMarch 31, 2021March 30, 2021Leave a comment

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 …

CategoriesBlogging, Troubleshooting

Checking your dumps!!!

Posted onOctober 6, 2020October 10, 2020Leave a comment

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 …

CategoriesBlogging, dbatools, First Responder Kit, SQL, Troubleshooting

Why a 60GB Database Backup Grew to 1TB in Size

Posted onAugust 11, 2020August 10, 2020Leave a comment

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 …

CategoriesBlogging, SQL, Troubleshooting

OLDEST_PAGE Log Reuse Wait type

Posted onSeptember 24, 2019September 20, 20191 Comment

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 …

CategoriesBlogging, SQL, Troubleshooting

The Story of the Stubborn Transaction Log

Posted onJanuary 26, 20182 Comments

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 …

CategoriesBlogging, SQL, Troubleshooting

Ghost Replication and the Growing Log File

Posted onJanuary 13, 2018Leave a comment

I know it is a weird time to be putting out a blog post.  But I have 28 hours to keep my goal of 52 blogs in 52 weeks going.  You say it is only week two and you are this far behind.  This week was hectic since I was on-call at work. So I Read More …

CategoriesBlogging, SQL, Troubleshooting

Recent Posts

  • 100 Blog Posts Milestone
  • T-SQL Tuesday #157- “End of Year Activity” – RECAP
  • T-SQL Tuesday #157 – Closing out 2022
  • T-SQL Tuesday #157 – “End of Year Activity”
  • SQL Temporal Tables — Gotcha!!!

Recent Comments

  • gbargsley@gmail.com on 100 Blog Posts Milestone
  • Brent Ozar on 100 Blog Posts Milestone
  • Chris on [How-To] SSRS migration
  • gbargsley@gmail.com on [How-To] SSRS migration
  • Chris on [How-To] SSRS migration

Latest Tweets

My Tweets

Archives

  • July 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • January 2022
  • December 2021
  • November 2021
  • July 2021
  • May 2021
  • March 2021
  • February 2021
  • January 2021
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • December 2019
  • November 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • February 2019
  • January 2019
  • December 2018
  • July 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • September 2017
  • August 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017

Categories

  • #100DaysOfCode
  • Azure
  • BBQ
  • Blogging
  • dbachecks
  • dbatools
  • First Responder Kit
  • MSSQLTips
  • PASS
  • PowerShell
  • SQL
  • SQL Saturday
  • SSRS
  • Troubleshooting
  • Tsql Tuesday
Copyright © 2023 GarryBargsley.com. All Rights Reserved. | Clean Journal by Catch Themes
Scroll Up
  • Home
  • About
Share On Facebook
Share On Twitter
Share On Linkedin
Share via E-Mail
 

Loading Comments...