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 …
Today Microsoft released CU #26 for SQL Server 2017. Wow 26 CU’s for a SQL Server product. What is really amazing is that it is over 4 years since SQL Server 2017 was released and 26 CU’s in we are still having some pretty significant bugs fixed. I guess with the size and complexity of SQL Server that is to …
Russian Nesting Dolls If you have ever seen the Matryoshka dolls known as the Russian nesting dolls or babushka dolls they are very interesting. They start with a large wooden doll that when opened contains a slightly smaller doll, then inside of that one an even smaller doll. These dolls often have five to eight dolls nested inside of each …