In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs), DBAs sometimes face a frustrating scenario: replication stalls when a secondary replica or subscriber is offline for maintenance, patching, or unexpected downtime. By default, SQL Server’s Log Reader Agent is cautious. It only marks transactions as ready for replication once they Read More …
Whether you’re a seasoned DBA or just exploring database tools, DBeaver offers a powerful, cross-platform GUI for interacting with PostgreSQL and many other databases. As a continuation of the previous blog post on installing PostgreSQL, this guide will walk through installing DBeaver and setting up a connection to the PostgreSQL instance we created. Step Read More …
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 …
This month’s T-SQL Tuesday is being hosted by ME. The subject I chose is “What are your year-end activities?” My post for T-SQL Tuesday #157 will outline some examples of tasks I work on as the year draws to a close. Date Dimension Tables Several platforms in our organization each year need to add dates 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 …
Happy Tuesday, blog reader. Have you ever come across a database you had not seen before or was in a different naming convention than you are used to seeing? Does this look familiar? Databases listed with 1, 2, 3, 4? What do those databases represent? Where did those databases come from? Would you believe me Read More …
Good day reader. This post is coming to you from a busy week in Texas, where the heat is starting to subside. The week’s topic will cover two options for restoring a SQL database. Have you ever come across a BAK file or LOG file where you were unsure what data was contained in the Read More …
Good morning dear blog reader. Today’s episode is fresh from a great weekend with the family. It is always fun to go on a road trip with my wife and son. Let’s talk more about SQL Server Installations since my previous post covered a similar topic. In this post, I felt I would stick with Read More …
