Monthly Blog Post Wrap Up

Monthly Blog Post Wrap Up
Download PDF

Using TSQL to Read an RSS Feed

Fri, 29 Jan 2021

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

Ask a question about Database Corruption

Wed, 27 Jan 2021

Now is your chance to ask a question about corruption in SQL Server databases. We will do our best job of answering those questions on our February webcast on database corruption. Do you have a question about the output fro Read more…

Performance: Faster way to concatenate longer string

Tue, 26 Jan 2021

After my post yesterday on the performance implications of concatenating long strings with the + operator and the CONCAT function, today I am following up with a way to speed up concatenation if you need to build really long strings Read more…

Performance: String Concatenation in SQL Server

Mon, 25 Jan 2021

String concatenation in SQL Server can be pretty quick but under certain circumstances it can really slow down. Something to be aware of if you are working with larger varchar(max) values that need to be appended to using concatenation i Read more…

Another Happy Customer

Mon, 25 Jan 2021

Due to the confidentiality we have with our clients we rarely get to share some of the great work we do outside of a “We have done that before” or “We saw that before a month ago with another custome Read more…

Common Table Expressions – Chapter 1

Mon, 25 Jan 2021

The following has been republished from my Common Table Expressions book. Chapter 1. Memory Tables There was a 1996 Michael Keaton movie called Multiplicity where he duplicates himself to get more work done. It first started out that he jus Read more…

January 2021 Security Patch for SQL Server

Sat, 23 Jan 2021

Microsoft has recently released a security patch for all supported version of Microsoft SQL Server. These updates are fixing where an elevation of Privilege vulnerability that could be exploited when an Extended Event session is running. From the Microsoft securit Read more…

SQL Server Mentoring

Fri, 22 Jan 2021

With the variety of clients that we work with at Stedman Solutions, one of our service products that has come from listening to our customers is the SQL Server Mentoring package. This is a really good fit for some customer Read more…

Announcing Feb Webcast – Introduction to Database Corruption

Tue, 19 Jan 2021

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

Have you tried the Quick Scan Report?

Tue, 19 Jan 2021

Have you tried out Database Health Monitor and the Quick Scan report? The Quick Scan report does a quick check (sometimes not so quick depending on the system). It checks for server best practice recommendations, and security and performance recommendation Read more…

Checking job history log size with TSQL

Sun, 17 Jan 2021

One of the important settings on SQL Server is the job history log size and the maximum rows per job. Without these set accurately you may not be able to track down job failure issues. These are easy to locat Read more…

2020 Blog Post Summary

Fri, 01 Jan 2021

Babelfish for Aurora PostgreSQLDecember 1, 2020Amazon goes after Microsoft’s SQL Server with Babelfish for Aurora PostgreSQL. What is interesting is that a direct port of SQL Server to PostgreSQL or Aurora PostgreSQL can be challenging due to incompatibilities …Babelfish fo Read more…

 

More from Stedman Solutions:

SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!

Leave a Reply

Your email address will not be published. Required fields are marked *

*