On Saturday morning, I announced the Database Corruption Challenge, and I had to abbreviate it as the DBCC, why not, acronym overloading isn’t always a bad thing. There were 91 participants, 22 of which ended up with correct answers with no corruption and no data loss. I created a database, with 3 bytes of corruption in one of the leaf …
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 »
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 »
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 …
>>> 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 …
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 …
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 …
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
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
>>> 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 …