Consolidating Life

Over the last year, I’ve been in consolidation mode at work with our SQL Server instances. The primary reason for the consolidation was driven by SQL Server 2008/2008R2 going out of support, but it was also a great exercise in reviewing all our SQL Server instances and asking the question “Does this instance need to live on its own?”. I was surprised by the number of instances that we could combine and databases that have lived on after an application was decommissioned. ...

March 25, 2019 · 2 min · Doug Purnell

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

Elon Study Abroad

What a trip! I was able to attend an Elon Study Abroad trip across the pond to learn about some of the great composers. This was a three week trip with stops in Germany, Austria, and Hungary. We studied Bach, Mozart, Beethoven, Wagner, and Bartok. We attended a few operas, a chamber music concert, and listened to a 90 piece orchestra (outstanding). I attend as a staff member, one of the many perks working for Elon University and higher education. ...

January 30, 2019 · 5 min · Doug Purnell

Somber Day

Today we took a day trip to Dachau Concentration Camp. This was the 1st and model camp for all of the other concentration camps. The camp had prisoners from 1933 up till 1945. It is hard to explain how powerful it is to walk on the grounds of Dachau. Pictures don’t do it justice, but I believe I did a good job being respectful while capturing the horrors of Dachau. You can see the rest of the photos under my photo site.

January 8, 2019 · 1 min · Doug Purnell

Inner City Munich

Our first full day in Munich was spent at the Deutsches Museum and a walking tour of the inner city of Munich. The Deutsches Museum is the world’s largest science and technology museum. Our guide walked us through the highlights since we only had an hour and a half to walk through. Much like the Smithsonian Museum in Washington D.C., you would need at least 3 full days to take in all the exhibits. It was cool to see an Enigma machine from WWII and the first Z3 programmable calculator. ...

January 8, 2019 · 1 min · Doug Purnell

Kill the Rabit Opera

We left Leipzig in the morning for a bus ride to Munich. On the way, we stopped in Bayreuth, home of the Bayreuth Festspielhaus and the Richard Wagner Museum. Bayreuth has the charm of a small German Town. Most of the Christmas decorations were still up, as with Leipzig, so it was nice to see the town decorated. Richard Wagner was born in Leipzig Germany but had his own opera house built in Bayreuth. This opera house has perfect acoustics and is still studied today on how that was accomplished. We were not allowed to take photos inside the opera house and within the museum, but I did have some time to walk about town and take photos outside of Wagner’s museum. ...

January 8, 2019 · 1 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