Tag Archives: administration

Checking Tempdb with dbatools

Posted on April 20, 2018 by

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading →

Posted in Blog | Tagged , , , | Leave a comment

The Right Connection

Posted on April 19, 2018 by

Travis-CI had some staffers connect to the wrong database and truncate production tables. Needless to say this caused an outage and disrupted their business. Hopefully they didn’t lose too many customers, but they certainly did not help their reputation. I’m sure there are … Continue reading →

Posted in Editorial | Tagged | 4 Comments

Remove-DbaBackup with dbatools

Posted on April 13, 2018 by

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading →

Posted in Blog | Tagged , , , | Leave a comment

Is the DBA Title Dying?

Posted on April 4, 2018 by

Not is the DBA joib dying, though we could argue about that as well. Instead, I’m asking if the title of Database Administrator is going away. Are there going to be people that really want to send out resumes and apply … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

dbatools is Growing Up

Posted on March 29, 2018 by

The dbatools.io project is growing up rapidly. I went to check something the other day and I was amazed at the command list. This used to fit on one page. Now it’s not close. Here’s the first page: In fact, it … Continue reading →

Posted in Editorial | Tagged , , | Leave a comment

Ad Hoc Logs

Posted on March 23, 2018 by

A long time ago I started working in a team of people as a general systems administrator. I worked in a team of six people managing a large, 1000+ node network with a number of servers. In my first exposure to … Continue reading →

Posted in Editorial | Tagged | Leave a comment

More SQL Server Updates

Posted on March 22, 2018 by

This was a busy week for updates. I finished adding new builds to the build lists for 2017, 2016, and 2014, the first time I’ve done all three platforms on the same day. To be fair, two updates were on the 19th and … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Template Configuration

Posted on February 16, 2018 by

One of my goals this year is to really spend some time learning more about Extended Events (XE). I’m somewhat embarassed that almost a decade after their introduction in SQL Server 2008, I have a fairly rudimentary grasp of the … Continue reading →

Posted in Editorial | Tagged , , | Leave a comment

Lowering the Noise

Posted on January 30, 2018 by

Over my career, I’ve had the chance to work in a variety of environments of all sizes. I’ve managed systems that powered all sorts of applications, with a variety of requirements. In many cases, I’ve had certain databases that needed … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Are You Always Up?

Posted on January 26, 2018 by

I’ve had the opportunity to work for and with quite a few companies in my career. In some sense working as a database developer or database administratrator is very similar at many places. The “job’s the job,” as I’ve said … Continue reading →

Posted in Editorial | Tagged ,