Tag Archives: administration

New Database Options

Posted on November 16, 2018 by

I saw recently that Azure SQL Database is getting a few more Database Scoped Options for that platform. These are intended to give more control over the way in which the engine behaves, without requiring each database on a server to function … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Two Types of Performance Counters

Posted on June 11, 2018 by

I had an issue where an instance of SQL Server was only showing the XTP (In Memory) performance counters. None of the other SQL Server counters were available, so I followed the procedure I’d written about previously. Once that was … Continue reading →

Posted in Blog | Tagged ,

No @@ServerName on Linux

Posted on June 7, 2018 by

I setup a new instance of SQL Server on Linux some time ago. At the time, the Linux machine didn’t have any Samba running, and no real “name” on the network. As a result, after installing SQL Server I got … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Getting SQL Agent going for SQL Server on Linux–#SQLNewBlogger

Posted on May 31, 2018 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. It’s actually a simple procedure, but I thought I’d write a short note to help me remember. The procedure … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Checking CHECKDB

Posted on May 22, 2018 by

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

Update Oddness for SQL Server

Posted on May 22, 2018 by

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

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

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

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