Category Archives: DBA

Migrations – PowerShell Can Help

Migrations are simply a part of a database administrator’s life.  And as we start a new year, we probably will have a few migrations to do in the upcoming year.  So, rather than shy away from them or have that … Continue reading

Posted in DBA, PowerShell | Tagged , , | 1 Comment

SQL Server 2016 … Is it a Game Changer?

With every new release of SQL Server, Microsoft claims that it is a game changer. However, in some ways I think it might be true regarding SQL Server 2016. Here are some of the things Microsoft is saying to promote … Continue reading

Posted in Business Intelligence, DBA | Tagged , , , | Leave a comment

SQL Intersection 2016 (Orlando FL)

For my training this year, I went to SQL Intersection (https://devintersection.com/) in Orlando, Florida from April 18-22, 2016. This was a new experience for me since I normally attend the SQL PASS conference in Seattle, Washington (http://www.sqlpass.org/summit/2016/Welcome.aspx). And there were … Continue reading

Posted in DBA, Professional Networking, Training | Tagged , | Leave a comment

SQL Saturday in Chicago (2016)

This past Saturday I attended SQL Saturday in Chicago (http://www.sqlsaturday.com/484/). It was a nice event and there were plenty of opportunities to network, get product demonstrations, and get some FREE SQL Server training. Sessions I attended: What’s New in SQL … Continue reading

Posted in Business Intelligence, DBA, PowerShell, Professional Networking, Training | Tagged , | Leave a comment

Look for Server “Ouches” – By Collecting Server Logs

At some point, most parents have asked their child to “show me where it hurts”. Perhaps a parent asks this question because their child has just yelled “ouch” or maybe the child seems to not be himself (i.e. lethargic). And … Continue reading

Posted in DBA | Tagged | 1 Comment

Monitoring AlwaysOn

Just recently, I violated one of my guiding work principles as a DBA … Be Proactive, Not Reactive … What this principle means to me, is that I want to try to anticipate problems arising and fix them, rather than … Continue reading

Posted in DBA | Tagged , , | Leave a comment

Investigating Job Schedules

One of the very first blog posts I made was on knowing what happened last night (https://sqlbadboy.wordpress.com/2012/10/12/what-happened-last-night/). In that post, I mentioned various ways that we could find out the statuses of jobs that had run. And this is an … Continue reading

Posted in DBA, TSQL | Tagged , | Leave a comment