October Blog Post Wrap-up

Just Released! – Using Database Health Monitor Course

Wed, 27 Oct 2021

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 the learning curve. You will learn most everything that you want to know about database…. Read more…

Informational Ransomware Video

Tue, 26 Oct 2021

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 it! Learn more about Ransomware in the video above. And see if you’re safe from… Read more…

Cannot resolve the collation conflict

Mon, 25 Oct 2021

One possible cause of the “Cannot resolve the collation conflict” error message is that your database collation doesn’t match the TempDB Collation. Recommendation It is recommended that the collation of your database match the collation TempDB. It is possible that… Read more…

Pulling PSE Outage Data Into SQL Server

Sun, 24 Oct 2021

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 SQL Server database. Here is how it works, in the TSQL code I hit the… Read more…

Cyclone Bomb Storm In the Pacific Northwest

24 Oct 2021

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 The weather forecasters are saying things like the biggest storm to ever hit the Pacific… Read more…

Do You Want to Learn How to Use SQL Server?

Fri, 22 Oct 2021

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 Getting Started with SQL Server class that we sell for just $19.99. At that price… Read more…

Raving Fan September 2021

Fri, 22 Oct 2021

This is a great application for SQL Server DBAing. We have a web based product but this one is so comprehensive, both high level and detailed. So much available right at the click of a button, it is amazing! I am so… Read more…

When might you need to restore from backup?

Wed, 20 Oct 2021

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 if someone dropped a table. How are you going to get that back? Does you… Read more…

Backup and Recovery – flooding and hurricanes, are you covered?

Mon, 18 Oct 2021

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 the lower 48 United States. So I have not experienced hurricanes, I have only hear… Read more…

How Do I Get Started with SQL Server?

Fri, 15 Oct 2021

The question comes up occasionally about how people can get started with Microsoft SQL Server? This is often people who are working and for some reason need to learn how to use SQL Server in their jobs. They ask me… Read more…

Recovering from a dropped or truncated table

Wed, 13 Oct 2021

All right, so how about someone dropped or truncated a table? What are you going to do? There’s the joke about a child named little Bobby Tables. He is the SQL injection guy who’s parents named him. Robert’); DROP TABLE…Read more…

Using OSQL.EXE to run a scheduled task on SQL Server Express Edition

Tue, 12 Oct 2021

One of the feature differences between SQL Server Express Edition and the other paid versions is the ability to schedule jobs or tasks using the SQL Server Agent. Even if you are running SQL Server Express Edition, there is… Read more…