Bovenkamp.us

Log in

Author: Derrick

  • Consulting Hardware Renewal Planning

    —

    by

    Derrick
    in

    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

    —

    by

    Derrick
    in

    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

  • Password Generator

    —

    by

    Derrick
    in

    https://1password.com/password-generator/

  • SQL Server Compatibility Level

    —

    by

    Derrick
    in

    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

    Derrick

    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

    —

    by

    Derrick
    in

    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

    Stuck Cisco Firepower Deployment = How to stop it

    —

    by

    Derrick
    in

    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

    Mobile devices quarantined in Exchange Online Office 365

    —

    by

    Derrick
    in

    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

    —

    by

    Derrick
    in

    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!!!

    —

    by

    Derrick
    in

    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…

  • Unable to install Microsoft-signed ClickOnce application

    —

    by

    Derrick

    I use this blog myself as my own personal reference for fixes to annoying problems. One such issue is being unable to install a Microsoft-signed ClickOnce application. If you get the following error, Your security settings do not allow this application to be installed on your computer. Run this command in Powershell as an Administrator.…

  • Meraki Split Tunnel Client VPN

    —

    by

    Derrick
    in ,

    If you need to do split tunnel with a Meraki VPN use the following commands so Windows knows where to send the traffic. I use this often so I can do split tunnel with a client’s Meraki Client VPN. In the example 192.168.1.0/24 is the remote network.