Tag Archives: administration

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

Restore to a point in time–#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. One of the … Continue reading

Posted in Blog | Tagged , , , , | 1 Comment

Using DBCC Clonedatabase

I haven’t messed with the new DBCC CloneDatabase option in SQL Server 2014/12016 (depending on patches), but recently I saw this: On a quiet Friday afternoon, this seemed like a good time to experiment. We (Redgate Software) have a salesdemo … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Balloons and Data

This editorial was originally published on Aug 8. 2013. It is being re-run as Steve is out of the office. We see a lot of questions at SQLServerCentral repeated over the years as workers new to the platform encounter some … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Using Trace Flags

At SQLServerCentral, we recently published a list of all the trace flags from Konstantin Taranov. It’s a great list, and thanks to Konstantin for compiling it. While I haven’t often used trace flags, there are some that have really helped … Continue reading

Posted in Editorial | Tagged ,

Global v Session Trace Flags

I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss the implications of session v global trace flags, which is something I’d like to do here. In the article, I … Continue reading

Posted in Blog | Tagged , ,

Backups Aren’t Backups Until a Restore Is Made

One of the interesting things I saw in the recent GitLab outage and data loss was the fact that none of their backups were available. They use PostgreSQL and I’m not familiar with the ways in which the modern PostgreSQL … Continue reading

Posted in Editorial | Tagged ,