Are you familiar with recovery time objective and recovery point objectives? These are really important factors when you’re planning your SQL Server backup strategy. First, we’ll take a look at the recovery point objective. Recovery Point is really looking at when the system fails what is the worst case for a point in time that you can restore up to. …
Recovery Point Objective and Recovery Time Objective Read more »
Everyone has their story of how they got started with SQL Server, and they range quite a bit. You might be that developer that was sitting too close to the SQL Server and someone named you the DBA. For others it may have been part of starting at a new job. For some you may have learned it in school, …
We are pleased to announce our our new SQL Server Course >>>”Getting Started with Microsoft SQL Server” <<< We are launching this course with a 50% OFF discount code! Coupon Code: INTRO50 *For a limited time only* Yes, Kiana won the battle (link to video below) over which course we are going to launch first. We originally had a debate …
TL;DR summary: Don’t do it. Stop reading here if you want, but just don’t do it. This post refers to shrinking your database files (mdf, or ndf files), not shrinking the log file. The log file is a completely different conversation, however, shrink database does shrink the log file. Not shrinking your database is one of the more counter intuitive …
DBCC ShrinkDatabase – I want to shrink my database. Read more »
A common question that we get is “we are doing X to the database this Saturday evening at 10:00pm, will you be available if something goes wrong and we need your help?” Customer Perspective: Typically, the customers perspective is, will you be available at no cost to stand by, then if things go really bad, we will be happy to …
Steve Stedman So years ago, when my kids were growing up, and they were watching the Discovery Channel, or Animal Planet, or whatever it was where the Crocodile Hunter was there. And I remember Steve Irwin, the Crocodile Hunter used to say Danger, Danger, Danger, and he’d go in and like deal with some crocodile or something like that. And …
Back by popular demand – 50% off our recently released SQL JOIN Types course. >>> Use Coupon Code: 50OFFJOINS <<< What is the difference, and how can you use joins correctly? Sometimes an inner join is the right join type to use, other times the left outer join, right outer join, full outer join, cross join or self join. In …
Hi, this is Steve Stedman and I just wanted to give a quick update on some of the stuff that’s happening at Stedman solutions. First off, we just released our SQL query join types, training videos, these are available on our training link on the website. And for a short amount of time, we’re offering a 65% off coupon, so …
Just over 3 years since Microsoft released SQL Server 2016 SP2, today Microsoft released SP3. There was a total of 17 Cumulative Updates in that time period for SQL Server SP2. SQL Server 2016 SP3 (KB 5003279) 2021-09-16 Here are the latest updates for each version of SQL Server. SQL Server 2019 RTM CU 12Download links:CU 12 (KB 5004524) SQL …
Steve Stedman 0:15 So Derrick, one of the things we run into is customers who are a little bit resistant to running CheckDB as frequently as maybe we think they should normally. And I guess, I’m just curious, what are your thoughts on how frequent? Or how important it is to run CheckDB frequently? Derrick Bovenkamp 0:51 Yeah, that’s, that’s …