Steve Stedman

Prize giveaway at the February webinar presentation

By SteveStedman Posted on February 8, 2021 Posted in SQL Monitoring No Comments

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 one 9-month subscription. A value of $300, $600, and $900 each! If you are not familiar with our SQL Daily Checkup product, here is how it works. You need to have Database Health Monitor (free) …

Prize giveaway at the February webinar presentation Read more »

CTEs Instead of Derived Tables

By SteveStedman Posted on February 7, 2021 Posted in CTE, TSQL No Comments

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 eight page print out with an 8pt font showing a single SQL statement. It was handed to me with a question about why it was not returning the right data. After looking the query over …

CTEs Instead of Derived Tables Read more »

SQL Daily Checkup service… What is it?

By SteveStedman Posted on February 7, 2021 Posted in SQL Daily Checkup, SQL Monitoring No Comments

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 recommend fixes before the issue becomes a bigger problem. The notification runs every hour and alerts us of issues that may require your attention. Over time even on the best configured SQL Servers, things change. …

SQL Daily Checkup service… What is it? Read more »

SQL Configuration Manager Missing

By SteveStedman Posted on February 4, 2021 Posted in DBA, SQL Server No Comments

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 from the start menu, not sure if someone deleted it from the menu, or if the icon was just not added. The SQL Configuration Manager is an important tool for configuring the sql instances installed …

SQL Configuration Manager Missing Read more »

Transactional Replication – Tracer Tokens

By SteveStedman Posted on February 3, 2021 Posted in Replication, TSQL No Comments

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 the replication data stream and see how long it takes to get to the subscribers. This is a process that can be very tedious if you have multiple publications to check, as you need to …

Transactional Replication – Tracer Tokens Read more »

Database Corruption Presentation – preparation

By SteveStedman Posted on February 2, 2021 Posted in Corruption No Comments

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 dozens of corrupt databases over the last 6 years we are going to share our experiences. Some of the good, the bad, and the ugly of corrupt databases. What things people did to make it …

Database Corruption Presentation – preparation Read more »

Server blocked access to XP_CMDSHELL

By SteveStedman Posted on February 1, 2021 Posted in TSQL No Comments

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 has not been turned on you will get this error when you try to use it. Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1 [Batch Start Line 17]SQL Server blocked access to procedure …

Server blocked access to XP_CMDSHELL Read more »

What is a Common Table Expression

By SteveStedman Posted on January 31, 2021 Posted in CTE Book No Comments

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 snowboarding after being a skier for many years it was very uncomfortable. Everything was difficult, riding the snowboard was strange and I ended up with my face in the snow more times than I can …

What is a Common Table Expression Read more »

Monthly Blog Post Wrap Up

By SteveStedman Posted on January 31, 2021 Posted in Steve No Comments

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 of XML with a list of the most recent posts. I though it would be handy to try using TSQL to see who has bee Read more… Ask a question about Database Corruption Wed, 27 …

Monthly Blog Post Wrap Up Read more »

Using TSQL to Read an RSS Feed

By SteveStedman Posted on January 29, 2021 Posted in TSQL 4 Comments

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. I though it would be handy to try using TSQL to see who has been blogging about what lately. I created two procedures, the first one called httpGET, and another one called LatestBlogPosts. The httpGET …

Using TSQL to Read an RSS Feed Read more »

Login