Tag Archives: sql server

Global v Session Trace Flags

Posted on March 16, 2017 by way0utwest

I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss the implications of session v global trace flags, which is something I’d like to do here. In the article, I … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Global v Session Trace Flags

Create a DACPAC to Move Databases–#SQLNewBlogger

Posted on March 8, 2017 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In my last post, I talked about what a DACPAC was. Now let’s create one. This turns out to … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

The Migration Checklist

Posted on March 8, 2017 by way0utwest

One of the things I always recommend is that when you upgrade a SQL Server instance, you perform a side by side migration to a new host instead of an in-place upgrade. My main concern is risk. While the upgrade … Continue reading →

Posted in Editorial | Tagged , | 4 Comments

Containing the Work

Posted on March 6, 2017 by way0utwest

Containment is becoming more prevalent in the computer world. We have containers coming to Windows Server 2016 (or earlier versions with WinDocks), a concept that’s been embraced in the Linux world for some time. If you haven’t looked at containers, … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Containing the Work