Transactional Replication – Tracer Tokens
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… Read More »Transactional Replication – Tracer Tokens
Database Corruption Presentation – preparation
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 »Database Corruption Presentation – preparation
Server blocked access to XP_CMDSHELL
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… Read More »Server blocked access to XP_CMDSHELL
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
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