Tag Archives: administration

Using xp_delete_file

Posted on October 9, 2017 by

First, this is an undocumented proc, and there’s nothing in BOL on this. Second, it’s a holdover from previous versions, so you’d be better served by using Powershell or some other type of scripting mechanism. This procedure is not supposed … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Enabling Database Containment for an Instance – #SQLNewBlogger

Posted on October 4, 2017 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it. I wanted to … Continue reading →

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

Remove an Active Lease on a Blob in Azure

Posted on September 12, 2017 by

I was creating and dropping VMs in Azure, and found myself charged money for disks that I thought I’d deleted. I found later that deleting a VM doesn’t necessarily remove the disk blob. Here was one way that I removed … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

Who’s Licensed?

Posted on August 3, 2017 by

My employer licenses software to users. Many of you might have SQL Compare, SQL Prompt, or one of our other handy products. If you do, you might have noticed that we have a Redgate login for you that shows your licenses and lets … Continue reading →

Posted in Editorial | Tagged | Leave a comment

Checking Your Database Properties–#SQLNewBlogger

Posted on August 3, 2017 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was reading Grant’s Database Fundamental Series on Database Properties, and it got me thinking. I think this is … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

Backup Log to Nul– #SQLNewBlogger

Posted on July 31, 2017 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it. There are times … Continue reading →

Posted in Blog | Tagged , , , | 4 Comments

Database Mirroring Needs FQDNs

Posted on July 3, 2017 by

A quick basic post, and one that I’ve forgotten. Since blogging is a good way to remind myself of things, here goes. I was testing Database Mirroring (DBM) recently for an upgrade situation. I’ve set up it up in the … Continue reading →

Posted in Uncategorized | Tagged , , ,

Handling Data Corruption

Posted on June 29, 2017 by

I wrote about dealing with data loss recently, ansking what your plans are for a situation. Some of you might rely on digital systems, some rely on humans, and some just accept some data loss. All of those are valid … Continue reading →

Posted in Editorial | Tagged ,

Adding Performance Counters back for SQL Server

Posted on June 26, 2017 by

I had a strange situation the other day, where a number of things went wrong with my instance. First, I lost permissions to detached databases. The SID was listed in the file permissions, but apparently unlinked to an account. Next, … Continue reading →

Posted in Blog | Tagged , ,

The Need for DRE

Posted on June 17, 2017 by

“Today’s database professionals must be engineers, not administrators” That’s a quote from an interview at O’Reilly on Database Reliability Engineering. I don’t want to quibble about whether those of us working in technology are engineers in name or not, but … Continue reading →

Posted in Editorial | Tagged , ,