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
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
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
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
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
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
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 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?
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… Read More »Checking job history log size with TSQL
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… Read More »2020 Blog Post Summary