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
This sale only happens 1-2 times a year – get it while it’s hot! SQL Server Mentoring is a training / consulting option for those who just need a little help or direction. This is a cost-effective approach for those who need just a little help. Some call it coaching, others call it micro consulting, but its all basically the …
So you have a new team member that has just joined your team, and they have no experience with SQL Server, but they need to learn how to get connected and use SQL Server. There are a few options on what you can do: Sit with them and walk through all the details around installing a local server and using …
Getting that New Team Member Started with SQL Server Read more »
We are releasing new courses and new discounts all the time. To make it easy for you, we will be posting all coupons and current sales every other Thursday. Check back in and maybe you’ll save yourself some money. 20% Off SQL Server Mentoring Services Coupon Code: MENTOR1021 Valid from 10/10/2021-10/31/2021
This is something that has really come in the news over the last couple years. A lot of civil unrest. Living in the Pacific Northwest, we heard a lot about what was going on in Seattle, and as Seattle decays businesses are impacted. There was a lot of things happening on Capitol Hill in Seattle last summer or the summer …