Author: Derrick
-
How to delete DTA Tables
This script will remove the database tuning advisor tables in the MSDB database on a SQL Server.
-
Windows VPN Stops working
Sometimes this can be caused by the IKE and IPSec services. Try the following,
-
SQL Server Alerts eMail
This query will setup email Alerts for severity levels 19 to 25 and errors 823 to 825. It will also create an SQL Agent Operator for you. Reused from http://databasehealth.com/server-overview/quick-scan-report/quick-scan-report-alerts/
-
Backups
Today I want to talk about backups. I’m not going to get into all the details about RPO and RTO but just the overall 50,000 foot level sentence that can help you make decisions about what you need. Back in High School I used to work on older Diesel powered Mercedes Benz for my best…
-
PGP Key
If you need to contact me securely please use the PGP Key below. Also check out my page at https://keybase.io/bovie2k
-
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…