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
Announcing Feb Webcast – Introduction to Database Corruption
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 »Announcing Feb Webcast – Introduction to Database Corruption
Have you tried the Quick Scan Report?
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… Read More »Have you tried the Quick Scan Report?