At our February webinar presentation on Database Corruption, Stedman Solutions will be giving away 3 daily checkup subscriptions one 3-month subscription, one 6-month subscription and… Read More »Prize giveaway at the February webinar presentation
The following is Chapter 3 from my Common Table Expressions book it its entirety. CTEs Instead of Derived Tables One time I was handed an… Read More »CTEs Instead of Derived Tables
SQL Daily Checkup from Stedman Solutions, LLC. We provide monitoring tools that alert us and you when there is an issue so that we can… Read More »SQL Daily Checkup service… What is it?
On a number of recent installs of SQL Server that I have worked on, I have noticed that the SQL Configuration Manager has been missing… Read More »SQL Configuration Manager Missing
When working with SQL Server transactional replication, one of the common checks to see if things look healthy is to insert a tracer token into… Read More »Transactional Replication – Tracer Tokens
On February 17, 2021 at 6:00pm Pacific time Derrick Bovenkamp and I will be presenting a webcast training on SQL Server Database Corruption. After repairing… Read More »Database Corruption Presentation – preparation
XP_CMDSHELL is one of those features that is turned off by default on SQL Server and needs to be turned on to function. If xp_cmdshell… Read More »Server blocked access to XP_CMDSHELL
The following is chapter 2 in its entirety from my Common Table Expressions book. What is a Common Table Expression? The first time I tried… Read More »What is a Common Table Expression
Using TSQL to Read an RSS Feed Fri, 29 Jan 2021Most blogs have a RSS feed of some kind. The RSS feed is usually comprised… Read More »Monthly Blog Post Wrap Up
Most blogs have a RSS feed of some kind. The RSS feed is usually comprised of XML with a list of the most recent posts.… Read More »Using TSQL to Read an RSS Feed