Author: Derrick
-
Fix Slow Windows 10 or 11 L2TP VPN
Disconnect from the VPN. Go to Services.msc -> Routing and remote access -> change “start type” to Automatic (Delayed start) and click “Start” Connect to the VPN.
-
Introduction to Database Corruption
Please Join, Steve, Kiana and I for a presentation on “Introduction to Database Corruption” this coming Wednesday. February 17, 2021 at 6:00pm Pacific time we will be presenting a free webcast training on SQL Server Database Corruption. After repairing dozens of corrupt databases we are going to share our experiences. Some of the good, the…
-
Consulting Hardware Renewal Planning
Now that I’m multiple years into consulting with Steve Stedman at Stedman Solutions I’m beginning to get a handle of my hardware needs and how to pre plan for purchases. This is firmly important because I believe not being ready financially to replace computers on time adds to a the possibility of taking on debt.…
-
SQL DBOwner
If you need to create a DBOwner User and Update all databases to be owned by DBOwner Once you create the DBOwner user this query will create a query to update the database owner to be DBOwner
-
SQL Server Compatibility Level
Recently I was working on a client’s SQL Server and made some changes to their databases compatibility level frequently I see the level set at 100 which corresponds to SQL Server 2008 and 2008 R2. Anyways I ran into a multiple databases set for Level 100. The SQL Server version was SQL Server 2014 so…
-
Reset OneDrive for Business on Mac
—
by
I use OneDrive for Business now and sometimes it looses its brain and normal fixes like closing and reopening or rebooting don’t solve the problem. In that case the best way to fix it is to do a full reset of the OneDrive Application. Quit OneDrive. Go to OneDrive in your Applications folder. Right-click the…
-
References from Valued Customers
Spending nearly my entire career working in Healthcare means I’ve been raised to be confidential. Whether we sign a confidentially agreement or not Steve and I treat each of our customers with the same confidentially a patient in a healthcare setting would not only expect but also has both a legal and moral right to get.…
-
Stuck Cisco Firepower Deployment = How to stop it
One of my biggest frustrations with Cisco Firepower Threat Defense is when deployment gets stuck. Normally 1-3 minutes is all it takes to deploy change after making it but once you see it go back 5 or 10 you usually have a problem. Some screenshots online have hours and even hundreds of hours basically it…
-
Mobile devices quarantined in Exchange Online Office 365
If you have ever had Exchange Online quarantine one of your mobile devices it can be entirely frustrating. Recently I ran into a problem after enabling MFA for all users on an Office 365 tenant where no matter how many times I allowed the quarantined device from the Exchange Admin Center or from Power Shell…
-
Installing SQL from a mounted ISO
I recently read an article by my good friend Randolph about not using a windows mounted ISO to install SQL server. This got my thinking, I have seen issues before. I’d say 98% of the time it works fine so the problem is rare but I have come across it before. Therefore I also don’t…
-
Its Always DNS!!!
Wow never has there been a truer System Administrator Truth. I can’t tell you how many problems I’ve seen that end actually being caused by a DNS problem. Just last week the internet ground to a halt while I was at home on my iPad. After getting up and checking the cable modem and the…