SQL Server 2017 CU 27 Just Released by Microsoft
Today Microsoft released SQL Server 2017 CU 27 (KB 5006944) . Here are the latest updates for each version of SQL Server. If you need… Read More »SQL Server 2017 CU 27 Just Released by Microsoft
Just Released! – Using Database Health Monitor Course
Thousands of people are using Database Health Monitor but there can be a learning curve. So we’ve come up with a way to speed up… Read More »Just Released! – Using Database Health Monitor Course
Informational Ransomware Video
A quick warning to ALL businesses. Ransomware is on the rise! We have seen too many people get hit with ransomware and we just hate… Read More »Informational Ransomware Video
Cannot resolve the collation conflict
One possible cause of the “Cannot resolve the collation conflict” error message is that your database collation doesn’t match the TempDB Collation. Recommendation for cannot… Read More »Cannot resolve the collation conflict
Pulling PSE Outage Data Into SQL Server
As part of documenting the craziness of this storm I have created a script that I run every 5 minutes that pushes data into a… Read More »Pulling PSE Outage Data Into SQL Server
Cyclone Bomb Storm In the Pacific Northwest
This post will be updated with the status of the things as the Cyclone Bomb storm progresses over the next couple days. 10/24/2021 – 8:00am… Read More »Cyclone Bomb Storm In the Pacific Northwest
Do You Want to Learn How to Use SQL Server?
For some reason, you want to learn how to use SQL Server, but the steps to get started can be overwhelming. I have created a… Read More »Do You Want to Learn How to Use SQL Server?
When might you need to restore from backup?
What are some of the common scenarios that may cause you to need to recover from your SQL Server backups? Dropped or truncated table: What… Read More »When might you need to restore from backup?
Backup and Recovery – flooding and hurricanes, are you covered?
So how about flooding or hurricanes? I live in the United States Pacific Northwest, about as far away from Florida as you can be in… Read More »Backup and Recovery – flooding and hurricanes, are you covered?