What is a Common Table Expression
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
January 2021
Monthly Blog Post Wrap Up
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
Using TSQL to Read an RSS Feed
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
Ask a question about Database Corruption
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… Read More »Ask a question about Database Corruption
Performance: Faster way to concatenate longer string
After my post yesterday on the performance implications of concatenating long strings with the + operator and the CONCAT function, today I am following up… Read More »Performance: Faster way to concatenate longer string
Performance: String Concatenation in SQL Server
String Concatenation SQL Server is one of these things that might be sound until you try to concate longer strings. That is where it gets… Read More »Performance: String Concatenation in SQL Server
Another Happy Customer
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… Read More »Another Happy Customer
Common Table Expressions – Chapter 1
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… Read More »Common Table Expressions – Chapter 1
January 2021 Security Patch for SQL Server
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… Read More »January 2021 Security Patch for SQL Server
SQL Server Mentoring
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… Read More »SQL Server Mentoring