Tag Archives: administration

Checking CHECKDB

One of the recommendations for SQLServer is that you run a DBCC CHECKDB regularly on your system. Those individuals that have worked with SQL Server for some time and worked on learning more about the system know to schedule this … Continue reading

Posted in Editorial | Tagged | Leave a comment

Update Oddness for SQL Server

I’ve been meaning to patch some of my development instances. With a little spare time while doing other work, I started the process the other day. My first step was to patch SQL Server 2016 with SP2. This went as … Continue reading

Posted in Blog | Tagged , , | 2 Comments

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 , ,