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 …
Today Microsoft release the following SQL Server update. SQL Server 2019 CU 13 (KB 5005679) 10/05/2021 At Stedman Solutions, LLC we do help with SQL maintenance and administration. If you need any help with your SQL Server cumulative updates, service packs or version upgrades, get in touch with us. Here are the latest updates for each version of SQL Server. …
SQL Server 2019 CU #13 Just Released By Microsoft Today Read more »
Looking at the memory limits and other limits on the SQL Server versions over time, we have seen things increase, but one limit that is still very low is the memory limit for SQL Express. Specifically the maximum memory for buffer pool per instance of SQL Server Database Engine for SQL 2019. The limit there is 1410 MB. At first …
Will your backup and recovery strategy cover you? So what about ransomware? A lot of people are getting hit with ransomware lately. I’ve seen more people lose their systems with ransomware than I have with almost any other type of failure! Generally, with system failures, when you need to restore from backup, even if you have a lame backup plan, …