Tag Archives: administration

Checking Tempdb with dbatools

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

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

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?

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

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

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

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

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

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?

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 ,