Announcing our Newest SQL Server Course We are so excited to release our newest SQL Server Course ”Getting Started with Microsoft SQL Server” We are launching this course with a 50% OFF discount code! Coupon Code: 50OFF-INTRO DBCC ShrinkDatabase …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …