Guidance on Query Optimization
I received this question from someone visiting the blog, and realized that rather than just replying to them, it might be good to put the… Read More »Guidance on Query Optimization
February 2021
OUTPUT Clause with an insert statement
So often I run into examples where someone is inserting a row and trying to get one of the values from that row that was… Read More »OUTPUT Clause with an insert statement
Prize giveaway at the February webinar presentation
At our February webinar presentation on Database Corruption, Stedman Solutions will be giving away 3 daily checkup subscriptions one 3-month subscription, one 6-month subscription and… Read More »Prize giveaway at the February webinar presentation
CTEs Instead of Derived Tables
The following is Chapter 3 from my Common Table Expressions book it its entirety. CTEs Instead of Derived Tables One time I was handed an… Read More »CTEs Instead of Derived Tables
SQL Daily Checkup service… What is it?
SQL Daily Checkup from Stedman Solutions, LLC. We provide monitoring tools that alert us and you when there is an issue so that we can… Read More »SQL Daily Checkup service… What is it?
SQL Configuration Manager Missing
On a number of recent installs of SQL Server that I have worked on, I have noticed that the SQL Configuration Manager has been missing… Read More »SQL Configuration Manager Missing
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
- « Previous
- 1
- 2