On March 23rd I will be presenting at SQL Saturday in Spokane WA. There is still time to register for this event, so you can still sign up today. My presentation will be on user defined Functions. TSQL User Defined Functions – Taboo or not? Duration: 60 minutesTrack: Enterprise Database Administration & DeploymentLevel: IntermediateFor years user defined functions (UDFs) have been the nemesis …

SQL Saturday – Spokane WA Read more »

We will be visiting SQL Saturday in Victoria Canada on March 16th. After the last SQL Saturday that I tried to attend was snowed out in Redmond a few weeks ago, I am ready for Victoria. I will be presenting on Database Corruption, one of my favorite presentations. Here are the session details: Basics of Database Corruption Repair Duration: 60 minutesTrack: AdminLevel: IntermediateYour …

SQL Saturday Victoria Canada Read more »

Recently Derrick and I had a chance to help with a corruption repair in Thailand, just to clarify, the client was in Thailand, not us. This was our second corruption of the year this year. Here is what the client had to say when we were done helping. We were in a bind, our clients are a manufacturing facility with …

Fixed Corruption in Thailand Read more »

On February 20th at Noon the Bellingham SQL Server Users Group, a PASS Chapter will be having its monthly networking lunch at Buffalo Wild Wings at the Bellis Fair Mall. Here is the address:  6 Bellis Fair Pkwy, Bellingham, WA 98226 I will get there about 10 minutes to Noon to get a table for the group. If you have …

Bellingham SQL Server Users Group – Lunch Feb 20 Read more »

On February 9, 2019, I have the privileged of presenting at SQL Saturday in Redmond Washington, at the Microsoft campus. SQL Saturday is a free SQL Server event, so if you want to spend a day at Microsoft learning about SQL Server then this is for you. TSQL User Defined Functions – Taboo or not? Track: Enterprise Database Administration & …

SQL Saturday – Redmond 2019 Read more »

When you do a database restore, including log backups, it is very important to get the log chain in the right order, or it won’t work.  To restore a full backup, then log backups, the chain of logs could be hard to sort out if you have dozens or hundreds of log backups to restore.  Your sure don’t want to …

Log File Restore Script Read more »

The team at Stedman Solutions, LLC (Steve, Bill, Derrick, and George) offer a variety of services, but one that I particularly enjoy is the performance tuning work. This usually involves initial contact with a new client who is having performance problems. From there it leads to a quick 30 to 45 minute call to discuss the problem, then a proposed …

Do you need SQL Server Performance Tuning Help? Read more »

I just received my email with the PASS Summit 2018 session evaluations, for my presentation on SQL Server Join types.     I loved the feedback, thanks everyone who completed the session evaluations.   Something about the Venn diagrams, which have been very controversial in the past. Great presentation of material. Clear explanations. Venn diagrams very helpful. I love the …

PASS Summit 2018 – My Session Evaluation Read more »