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 PSE outage webservice url and pull the count of customer that are without power. I then insert it into a …
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 Northwest. Here is what Cliff Mass had to say: … the formation of an unprecedented storm is nearly a sure …
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 even it if saves you just an hour or two of your time, it is probably worth it. The class …
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 your current backup strategy have you covered? What if you have a hard drive failure? Do you have backups that are …
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 heard stories. But I have seen flooding, there’s a lot of lowland areas where flooding can occur. But this is one …
Backup and Recovery – flooding and hurricanes, are you covered? Read more »
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, how do I get started with SQL Server? For me, I got started with SQL Server when I took a …
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 Students; — And what that name does, is it SQL injection that basically closes out the current SQL statement, then …
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 a need to run scheduled jobs. Things like: Backups Index and Statistics Maintenance Shrink DB (Just Kidding, don’t do that) A …
Using OSQL.EXE to run a scheduled task on SQL Server Express Edition Read more »
Here listed is the current percentages of SQL server versions running our Daily Check-up with Database Health Monitor. Compare this month’s percentages to Last Month’s Percentages
