Monthly Archives: July 2017

Auto DevOps

Posted on July 31, 2017 by

As much as I like DevOps, this scares me. There are a lot of employees (20%) at BMW that are software engineers. They want to increase that to a larger percentage, which I assume means that we’ll have more and more … Continue reading →

Posted in Editorial | Tagged ,

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

A Summit Just North of The Big Easy

Posted on July 28, 2017 by

I’m off today, traveling down to The Big Easy, New Orleans for a beignet. Well, not just a beignet, but also because I’ll be speaking at SQL Saturday #628 in Baton Rouge tomorrow. It’s easier, and more fun, to fly into New Orleans, so I’ll … Continue reading →

Posted in Editorial | Tagged ,

Using Test-DbaOptimizeForAdHoc

Posted on July 28, 2017 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 , ,

Who’s Smarter? Humans or AI Systems?

Posted on July 27, 2017 by

I used to watch science fiction movies and imagine we’d have these incredible machines that could interact with humans in amazing ways. I always believed more in the helpful and useful AI in Star Wars than the dangerous systems of movies like The … Continue reading →

Posted in Editorial | Tagged ,

Azure Labs–Minor Cluster Issues for SQL Server Setup

Posted on July 27, 2017 by

During the process of building an Azure lab, I ran into a place where my cluster was not completely validated. I think this happened when a node failed and was re-provisioned, but in any case, when I ran SQL Server … Continue reading →

Posted in Blog | Tagged , ,

DevOps–Fixing Poorly Named Constraints

Posted on July 26, 2017 by

I was building some code the other day and kept getting problems in my deployment for a change. The deployment was having issues, and this came down to this statement. ALTER TABLE EventLogger DROP CONSTRAINT [PK__EventLog__5E548648B043C0BC] The problem was that … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

SSoL: Where are my data and log files?

Posted on July 25, 2017 by

I don’t think most of us need to know Linux, but if you end up managing a system, it’s good to have a little idea of how to get around. This is a short series of posts as I remember … Continue reading →

Posted in Blog | Tagged , ,

Advancing Security

Posted on July 25, 2017 by

One of the topics that is very important to many technology professionals is security. Security also might be one of the least understood aspects of our jobs. It’s an area that requires regular learning, monitoring, reactions, and vigilance. A healthy dose … Continue reading →

Posted in Editorial | Tagged

The Financial DBA

Posted on July 24, 2017 by

I’ve got an Azure subscription. At least, I think I have just one. I know I have a few Microsoft accounts, across 4 (or more) different email addresses, that I use for various VSTS development purposes, but only one should … Continue reading →

Posted in Editorial | Tagged , , , ,