SQL Server 2008/2008R2 Migration

End of Life... As many of you know, mainstream support for SQL Server 2008 and 2008R2 ended back on July 9th of 2014. Extended support is active now and that is set to expire on July 9th of 2019. After July 9th, no security fixes will be made available. It is extremely important for you to move all your database off of and 2008/2008R2 instances to a supported instance of SQL Server. We started our process back in 2017 to understand some of the application changes required for the database move. We have a mix of custom and vendor applications. The main goal of the migration was to update our documentation around the database & application relationships and bring all our custom databases up to SQL16 standards. ...

March 18, 2019 · 3 min · Doug Purnell

T-SQL Tuesday #112 Cookie Monster

Shane O’Neill (b|t) is hosting this month’s edition of #TSQL2sDay. Shane’s charged to us is to think back when we had a difficult time with project/task and used our internal mojo (cookie jar) for energy to keep going. We have custom applications written to support the faculty, staff, and students. Most of these have a SQL Server database to store the information. As with most shops, we have used various versions of SQL Server over the years to support our business partners. The old adage, “if it ain’t broke, don’t fix it” holds true for some of our older SQL Server instances. For those instances, we didn’t make an attempt to migrate off of them until it was required. Well, that time has come. We realized last year that SQL Server 2008 and 2008 R2 were losing their extended support and that would mean no more security updates. We didn’t want to increase our security risk to our data so we started the process of planning the migration to SQL Server 2016. ...

March 12, 2019 · 3 min · Doug Purnell

T-SQL Tuesday #111 - Why do you do what you do?

This month’s #tsql2sday is being hosted by Any Leonard (b|t). He asks a simple question that gets at the heart of what motivates us, “Why do you do what you do?”. For me, it is about helping and sharing with others. From the database administration point of view, I love helping others with solving business problems with data. I have a knack for data and enjoy understanding what the business issue is so that I can see how data can solve it. By getting involved in various projects, I get a better understanding of how the business operates and allows me to be proactive and start suggesting solutions. ...

February 12, 2019 · 2 min · Doug Purnell

Healthy Living

I remember the days when my metabolism allowed me to eat anything in sight. I was staying busy playing outside without the draw of electronic devices. Jump ahead 30 years and life catches up with you. I’ve struggled over the past 30 years with the roller coaster ride of weight gain/loss. There are times when my head is straight and I can workout multiple times a week and eat healthy foods. Contrast that with loafing on the coach and downing a back of chips in one sitting; this is my struggle. ...

February 6, 2019 · 3 min · Doug Purnell

Choo Choo Leipzig

After a nice lunch at Burgermeister (thanks Matt!) located at Höfe am Brühl (a local shopping mall) with Matt and Andrea, I ventured out towards the train station (Leipzig Hauptbahnhof). This is a huge train station with 25 corridors with 21 tracks that end within the station. The station was opened in 1915 and serves as a major hub within Germany. The best part about the station was most of the Christmas decorations were still up. This made for some great shots with the lights erected around the station. I spend about 2 hours roaming around taking photos and ended up a local grocery store (similar to Aldi) to buy some snacks for the bus ride down to Munich the next day. ...

January 6, 2019 · 1 min · Doug Purnell

Staying Focused

One of my goals this year is to stay more focused on my active projects without losing focus of my yearly goals. During 2017, I found myself getting caught up in the day to day requirements of being a Database Administrator rather than planning my day/week/month around my goals. Come review time for 2017, I realized I had not paid enough attention to my goals throughout the year, just the daily operational tasks. This was the catalyst for purchasing Shawn Blanc’s (t|b) Focus Course. I heard about Shawn’s work through a few different podcasts and decided to give it a try. ...

July 24, 2018 · 3 min · Doug Purnell

T-SQL Tuesday #104 - Managing Databases Snapshots

This month’s #tsql2sday is being hosted by Bert Wagner (b|t). His topic is about code we have written that we would hate to live without. We have a pretty good handle on change control here and one of the steps we perform before any change is made to a database is to take a database snapshot. Database Snapshots used to be an Enterprise only feature, but with the release of 2016 SP1, it is now available under Standard, Web, and Express editions. If you have been using Standard Edition for a while, you may not have realized this feature is available to you. ...

July 10, 2018 · 3 min · Doug Purnell

T-SQL Tuesday #102 - Giving Back with GTD

This month’s #tsql2sday is being hosted by Riley Major (b|t). He ask us to “Pick some way you can help our community”. I realized my improvement with time management this year is how I can help the community. Adapting my time management processes around David Allen’s (b|t) Getting Things Done (GTD) has been very beneficial for me this year. I’ve been a GTD practitioner for a couple of years but lost focus in 2017. When Mala Mahadevan (b|t) ask us to write down our learning goals for 2018 I knew this was the opportunity to reevaluate my GTD process. I believe this is what I can do to help our community, help others with time management. We all are being asked to do more with what seems like less time in the day. How many of you have a hard time keeping track of projects at work and home? GTD is the answer. ...

May 9, 2018 · 2 min · Doug Purnell

T-SQL Tuesday #101 - Essential SQL Server Tools

This month’s #tsql2sday is being hosted by Jens Vestergaard (b|t). His topic is about the essential SQL Server tools in my stack. I’m looking forward to reading the summary post to find out what tools I’m missing out on. One of the foundation tools we put on all our instances is Ola Hallengrens’s maintenance scripts. It makes backups, indexes, and integrity checks very easy. This is hands down a much better tool to use over the built-in Maintenance Plans under SSMS. ...

April 10, 2018 · 2 min · Doug Purnell

The Ozar Effect

Back in February one of my blog posts was highlighted on Brent Ozar Unlimited’s Weekly Links. Wow, what a bump in traffic! I usually receive a hand full of views a week, but on February 26th it reached 1,212. The cool part was it was actually the #2 link on Brent Ozar Unlimited’s newsletter for the day. If you don’t currently subscribe, here is a link to start. ...

April 9, 2018 · 2 min · Doug Purnell