Monthly Archives: September 2018

Fitting Into RAM

Posted on September 21, 2018 by

RAM has always been a fairly limited resource in most of the computer systems I’ve worked with in my career. Often there is never enough RAM, and I’d always like more, often to speed up the systems. That has somewhat … Continue reading →

Posted in Editorial | Tagged , | 3 Comments

Moving Objects to a New Schema

Posted on September 20, 2018 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I haven’t had the need to move an object from one schema to another in years. Really since SQL … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

The Upgrade Storm

Posted on September 20, 2018 by

The Perfect Storm is a movie about the confluence of three weather events that combined to create a situation the resulted in the loss of all life on a fishing boat. It’s a good movie, and certainly one that might make … Continue reading →

Posted in Editorial | Tagged | Leave a comment

What is Projectsv13 in SQL Change Automation?

Posted on September 19, 2018 by

I got this question recently from someone that was evaluating the SQL Change Automation client in Visual Studio. After setting up a new PoC (Proof of Concept), they were confused about why there is a new entry in their list … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Rollbacks Are Normal

Posted on September 19, 2018 by

Do any of you think that a rollback of a version for your application is easy? Most people struggle, and when I talk DevOps and improving your process, the number one question is about rollbacks. In fact, recently I had … Continue reading →

Posted in Editorial | Tagged | Leave a comment

The Trigger Roundup–T-SQL Tuesday #106

Posted on September 18, 2018 by

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

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 | Leave a comment

A Summit Contest for registering by Sept 22

Posted on September 17, 2018 by

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 , | Leave a comment

Deleting a User that Owns a Schema

Posted on September 17, 2018 by

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

Dark Reads During a Migration

Posted on September 17, 2018 by

I caught a post from the Slack Engineering team titled: Re-architecting Slack’s Workspace Preferences: How to Move to an EAV Model to Support Scalability. In the post, an engineering intern describes the move from a blob table (actually a table storing … Continue reading →

Posted in Editorial | Tagged | Leave a comment