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)
264 reads
GarryBargsley
[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)
987 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
32 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)
256 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
197 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)
538 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)
608 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)
381 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)
889 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
439 reads
Blogs
A New Word: Mottleheaded
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
Microsoft Purview GA menu’s
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Connect to Power BI as a Guest User in another Tenant
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
I have never seen an insert statement with -= tablename in place of values
We have a third part software and looking at some of their SQL we...
Automate reports for when the SQL database was last used
Hi, I'm working on cleanup activity of deleting databases that aren't in use or...
Question of the Day
Disable All the Indexes
How do I disable all the indexes on the dbo.Logger table?
See possible answers