Tag Archives: administration

Who’s Licensed?

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

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

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 , , , | Leave a comment

Database Mirroring Needs FQDNs

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 , , , | Leave a comment

Handling Data Corruption

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 , | Leave a comment

Adding Performance Counters back for SQL Server

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 , , | Leave a comment

The Need for DRE

“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 , , | Leave a comment

Renaming MDF/LDF Files–SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I would guess many people would run into this situation at some point. A developer or DBA creates a … Continue reading

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

Why Does My Log Grow–SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a great topic, and really, every DBA or admin should blog this and be sure they understand … Continue reading

Posted in Blog | Tagged , , | Leave a comment

SQL Server is Getting Smarter

There’s been a lot of press and media about Microsoft on the AI and machine learning work they’re heavily investing in. From Cognitive Services to Cortana to Bots, Microsoft is really investing in developers and applications that will perform detailed … Continue reading

Posted in Editorial | Tagged , | Leave a comment