Monthly Archives: September 2018

The Trigger Roundup–T-SQL Tuesday #106

Posted on September 18, 2018 by way0utwest

This month was my turn to host T-SQL Tuesday. I chose Trigger Headaches or Happiness as the topic, and I am glad that there have been quite a few responses. I started the review almost immediately,and here are a few … Continue reading →

Posted in Uncategorized | Tagged , | 1 Comment

Monitoring Costs

Posted on September 18, 2018 by way0utwest

I’m a believer in instrumentation and metrics being regularly gathered from your systems. Across the years I’ve built and bought monitoring software to use in various jobs, sometimes in layers where one piece of software uses data from another to … Continue reading →

Posted in Editorial | Tagged | Comments Off on Monitoring Costs

A Summit Contest for registering by Sept 22

Posted on September 17, 2018 by way0utwest

If you haven’t registered for the 2018 PASS Summit and plan to go, you might press to get registration done this week. Next week prices increase, but this week you can save. There is a promotion from PASS that will … Continue reading →

Posted in Blog | Tagged , | Comments Off on A Summit Contest for registering by Sept 22

Deleting a User that Owns a Schema

Posted on September 17, 2018 by way0utwest

This was an interesting question I saw posted recently. Through SQL Server 2000, trying to delete a user that owned objects was a pain. We had to actually rebuild all the objects, which was problematic. With SQL Server 2005 and … Continue reading →

Posted in Blog | Tagged , | 1 Comment