Battle of Leipzig 1813

On day 3 in Leipzig, the students had independent research so that enabled me to have a free day to do some photo walks around the city. The two faculty members on the trip, Matt Buckmaster and Andrea Sinn, accompanied me in the morning. I choose a monument erected in 1913 that commemorates Napoleon’s defeat at Leipzig in 1813. Völkerschlachtdenkmal (Monument to the Battle of the Nations) is a huge concrete structure with granite façade. The interesting part of the concrete foundation is no steel support was used. It is build entirely using compressed concrete pillars. ...

January 6, 2019 · 2 min · Doug Purnell

Across the pond

Guten Nachmittag, from Germany! I work at Elon University and they are known for their Study Abroad programs. These programs are designed to help students become global leaders in their field. As a staff member at Elon, one of the benefits is to apply and accompany one of 6 global education classes. I was lucky enough to have my name pulled from the hat and attend the Lives of the Great Composers. This is a 3 week trip to Germany, Austria, and Hungary. ...

January 4, 2019 · 2 min · Doug Purnell

Backup automation with MySQL

One of our vendor applications we host on-premises was moving from SQL Server to MySQL (don’t get me started). Our responsibility was to make sure the MySQL databases were being backed up on a daily basis. I didn’t know the first thing about supporting MySQL but was looking forward to learning a new RDBMS to see how things worked. My first stop was Plural Sight, Pinal Dave had a few MySQL courses I wanted to review to start understanding what it takes to support MySQL. I watched the following courses: ...

August 31, 2018 · 4 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

A little SQL Curry goes a long way

We hired a Director of Information Security a while back. One of the things that excited me the most about this new position was the ability to exchange ideas around security under SQL Server. Our initial discussion was over lunch at a local Indian restaurant, Taaza Bistro (w|t), and I found it very beneficial. We talked about our best practices and from that we agreed that there wasn’t any immediate need for us to alter our course (that was good news). ...

May 3, 2018 · 2 min · Doug Purnell

Accountability Partner

The #tsql2sday topic in December 2017 was around goal setting. I wrote about my trouble with keeping some of the goals I set. There were some really good posts if you want to look through the roundup for some inspiration. The issue I have with goals is I’m an obliger, always helping others before myself. The best outcome of the blog post was having Glenda Gable (b|t) reach out to me about being an accountability partner. ...

April 20, 2018 · 2 min · Doug Purnell

Weekly Routines

The key part to keeping my Getting Things Done (GTD) methodology up to date is the weekly review. Having all your projects and tasks under a single trusted system has its advantages, but you need to make sure and view everything so nothing slips through the cracks. The weekly review is a time where you give your projects a tune-up. This is a more in-depth exercise than the daily routine. At a high level, you review each project and make sure they each have a next action to keep them moving forward. ...

April 18, 2018 · 5 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