By Posted on Posted in Corruption No Comments Tagged with ,

After introducing the Database Corruption Challenge (DBCC) – Week 1 Challenge yesterday, I received several requests for a SQL Server 2008 version of the challenge. Here is is, and for future Database Corruption Challenges, I will include a SQL Server 2008 version of the challenge.  The 2008 backup file should restore just fine on SQL 2008, SQL Server 2008R2, SQL …

SQL Server 2008 Downloads for the Database Corruption Challenge (DBCC) Week 1 Read more »

By Posted on Posted in Corruption, SQL 2014 14 Comments Tagged with , , , , , , ,

Welcome to the DataBase Corruption Challenge, this is an about weekly blog challenge where I will post a corrupt SQL Server database with some details on what happened to it. If at this point you are already a bit irked by my use of capitalization in the DataBase Corruption Challenge, and the acronym of DBCC that I have used to …

Introducing the DataBase Corruption Challenge (DBCC) – Week 1 Challenge Read more »

By Posted on Posted in Stedman Solutions No Comments Tagged with , , , , , , ,

As of today, March 31st 2015, I am off on a new adventure in my life. As of today I am 100% focused on my new business. Here are the details. FOR IMMEDIATE RELEASE: Stedman Solutions, LLC. To Offer SQL Server Consulting Services. Bellingham, WA, USA – March 31, 2015 – Today Steve Stedman, Founder/Owner of Stedman Solutions, LLC is …

Introducing Stedman Solutions, LLC. Read more »

By Posted on Posted in 70-461 Training, JOIN Types, TSQL No Comments Tagged with

>>> Try our JOIN Types Course Today! Today’s training will be on JOINs.  Here is the outline for the training. —Basic SELECT —INNER JOIN —LEFT OUTER JOIN —RIGHT OUTER JOIN —LEFT OUTER JOIN with exclusion —RIGHT OUTER JOIN with exclusion —SEMI JOIN —ANTI SEMI JOIN —CROSS JOIN —FULL OUTER JOIN —FULL OUTER JOIN with exclusion —CROSS APPLY —OUTER APPLY —Multiple …

TSQL Training: JOINs Read more »

By Posted on Posted in 70-461 Training, TSQL 2012 No Comments Tagged with , , , , , ,

Here is a quick video training on how to use the T-SQL EOMONTH function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. The EOMONTH function returns the last day of a given month, or a future or past month by using the second parameter of offset. EOMONTH was introduced in SQL Server …

Using The TSQL EOMONTH Function Read more »

By Posted on Posted in TSQL 7 Comments Tagged with , , , ,

NOTE:: There is an updated version of the poster available now.   Version 4 is now available.   So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. >>> Try my JOIN types course! I created this poster a …

TSQL JOIN Types Poster (Version 3) Read more »

By Posted on Posted in 70-461 Training, TSQL No Comments Tagged with , ,

Here is a quick video training on how to use the T-SQL DATEADD function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. And here is the sample code to go with the DATEADD video tutorial: See Also Additional Training on my YouTube Channel Free SQL Query Training 70-461 exam preparation

By Posted on Posted in 70-461 Training, TSQL No Comments Tagged with , ,

Here is a quick video training on how to use the T-SQL DATEDIFF function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. And here is the sample code to go with the DATEDIFF video tutorial: See Also Additional Training on my YouTube Channel Free SQL Query Training 70-461 exam preparation

By Posted on Posted in JOIN Types 7 Comments Tagged with , , , , , ,

>>> Try our online JOIN Types Course Today! As I have been working on the SQL Server JOIN Types poster, I have received several questions around the difference between a CROSS JOIN, and a FULL OUTER JOIN. After looking at the Venn diagrams for the two, they are both shown as the same, however they are not the same by …

FULL OUTER JOIN vs CROSS JOIN Read more »

By Posted on Posted in 70-461 Training, TSQL No Comments Tagged with , ,

Here is a quick video training on how to use the T-SQL DATEPART function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. And here is the sample code to go with the video tutorial: See Also Additional Training on my YouTube Channel Free SQL Query Training 70-461 exam preparation