Tag 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

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

Security Cleanup … Identifying Invalid Logins and Orphaned Users

Imagine that we own a large apartment building. And naturally, over time different tenants will come and go. But, what if we never bothered to change the keys to the apartments and we never attempted to get the keys back … Continue reading

Posted in 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

Database Snapshots

Last week, I took a Caribbean cruise as a much needed family vacation.  It was very enjoyable!  We took a lot of pictures or we could say snapshots, which help us to remember those “good” times.  Then, I came back … Continue reading

Posted in DBA | Tagged , | Leave a comment

SQL Server Installations … Is there an “Easy” Button?

In previous posts, I have discussed the benefits of giving attention to how you install your SQL Server (https://sqlbadboy.wordpress.com/2012/11/06/preparation-and-setup-leads-to-good-results/) and the need to automate things when you are doing them again and again (https://sqlbadboy.wordpress.com/2013/02/25/can-you-do-it-again-and-again-ok-lets-automate-it/). So, if we put the principles … Continue reading

Posted in DBA | Tagged , , | Leave a comment