September Blog Post Wrap-up

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 – I want to shrink my database.

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… Read more…

After Hours Standby

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… Read more…

Danger Danger Danger – REPAIR_ALLOW_DATA_LOSS

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 use… Read more…

TSQL JOIN Types Sale Continues

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… Read more…

Latest Stedman Solutions business update:

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… Read more…

SP3 for SQL Server 2016 Just Released

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… Read more…

CheckDB Chat with Steve and Derrick

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… Read more…

Cumulative Update #26 for SQL Server 2017

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… Read more…

Nested CTEs

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, the… Read more…

SQL Server SEQUENCE

In 2012 SQL Server introduced the SEQUENCE object. Looking at the syntax it is very similar to how Oracle has implemented SEQUENCEs for many years. I believe that the SEQUENCE was introduced to aid in the transition of Oracle developer… Read more…

September SQL Daily Monitoring – SQL Server Versions

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

The post September SQL Daily Monitoring – SQL Server Versions appeared first on… Read more…

Should I Use A Unique Identifier As A Primary Key?

Take the following sample code. Four similar tables with an INT IDENTITY, BIGINT IDENTITY, and two with UNIQUEIDENTIFIERS, one using newid() and the other with newsequentialid(). Once the tables are created and we insert 100,000 rows into each, the… Read more…

Recursive CTE to Calculate Dates for the Last 30 Days

​Have you ever needed to generate a list of dates for the last 30 days. There are lots of different ways to do this with TSQL, but one way is with a CTE, where you can then left join against it with another query to generate a list of all dates in….. Read more…​