Monthly Archives: September 2018

Fitting Into RAM

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

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

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?

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

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

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

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

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

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

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