Log Shipping – Standby Mode
Hello, dear blog reader. This week’s blog is coming to you from the home office. Finally, my son is back in school, and the house has some peace. For...
2022-09-05 (first published: 2022-08-23)
278 reads
[How-To] SSRS migration
Good evening. Today’s episode is coming to you from my home office, where I feel motivated to write a blog in the comfort of my home. Today we will...
2022-08-08 (first published: 2022-07-26)
1,020 reads
Transactional Replication: Where did my data go???
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...
2022-07-27 (first published: 2022-07-12)
263 reads
SSRS Subscription E-Mail Error
It is that time again. This time coming to you from a Mcdonald’s so my son can get out some energy, and it is 105 degrees outside. This will...
2022-07-19
33 reads
Connecting to an Azure SQL Database
Are you starting to experiment with Azure SQL Databases? Is your company interested in moving to the Cloud and asking you to investigate different options? This blog will show...
2022-01-08
198 reads
How Long has Your SQL Server Been Online
This week’s blog post will help you check your SQL Servers up-time. There are numerous reasons I can think of that you would want to know how long your...
2021-12-15 (first published: 2021-12-07)
548 reads
Decoding SSRS Subscription Agent Jobs
Hello and welcome back… It has been a few months since I have published a blog post. More like 126 days, to be exact. Unfortunately, I have been dealing...
2021-11-22 (first published: 2021-11-16)
626 reads
Quickly Identify Configuration Drift In Your Environment
As you sit and wonder about when the next Star Wars movie is going to come out, do you ever get the thought of “I wonder if all my...
2021-08-04 (first published: 2021-07-13)
385 reads
Where are my SQL Server Errors?
Have you ever opened the SQL Server Error Log and wondered, “where are all the errors?” Digging through the Error Log to find what you need can be a...
2021-06-02 (first published: 2021-05-20)
897 reads
SQL Agent Jobs – When Success is Failure
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...
2021-03-31
440 reads
Blogs
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Why use XACT_ABORT?
This came up one day at my work when a developer was using it....
Using AI for Data Conversion
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
Forums
sp_lock memory leak
I spotted this in the release notes for CU17 in SQL Server 2022: KB3616559...
Migration related issue
I migrated DB server from 2017 enterprise to 2019 enterprise. After the migration, every...
How Much AI Code Would You Use?
Comments posted to this topic are about the item How Much AI Code Would...
Question of the Day
Browsing for Instances
I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?
See possible answers