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

Encrypted Database Objects … How to Guide

Time and again, I have talked about security as being a high concern for DBA’s. So, that is why it is good to familiarize ourselves with the various types of security within SQL Server. In a previous post, I discussed … Continue reading

Posted in DBA, Security | Tagged | Leave a comment

Getting to Know Your Hardware

Should a DBA know what kind of hardware they are running on? And better yet, should they care? My answer to both questions would be a firm … YES! Here are two reasons why a DBA should know and care … Continue reading

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

SQL Server Takeover

Imagine this … you have just been given the responsibility to manage another SQL Server that you know nothing about … Ok, maybe we don’t really have to use our imagination in this scenario, since this happens all the time … Continue reading

Posted in DBA | Tagged , , | Leave a comment