Monthly Archives: June 2016

Basic XML Node Query–#SQLNewBlogger

Posted on June 30, 2016 by

  Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a question recently about querying an XML document. Certainly avoid this in the database if you … Continue reading →

Posted in Blog | Tagged , , ,

Monitoring and Alerting

Posted on June 30, 2016 by

Monitoring your systems is important. It’s not just me that thinks so, as plenty of experienced DBAs and developers know the value of monitoring. Heck, most people have learned to build some sort of metric collection into their software. Azure … Continue reading →

Posted in Editorial | Tagged ,

The Desktop Rebuild–Part 3

Posted on June 29, 2016 by

This is the last part of this series, at least for now. If you haven’t seen Part 1 and Part 2, feel free to check them out. After I got through Part 2, I was working again. In fact, I … Continue reading →

Posted in Blog | Tagged , | 2 Comments

Come to IT/Dev Connections–July Sale

Posted on June 29, 2016 by

You can register for IT/Dev Connections in October and save this weekend with the July Sale. Use code: JULYSALE. I’ll be speaking, though I’m not sure which sessions will be chosen. This year the conference is going to be on … Continue reading →

Posted in Blog | Tagged ,

Email or Username

Posted on June 29, 2016 by

Quite a few of us will work with application databases where we need to identify a particular user for working with the various parts of the application. I’m not talking about the authentication and verification of identity, but just having … Continue reading →

Posted in Editorial | Tagged | 2 Comments

Better Explorer on High dpi Displays

Posted on June 29, 2016 by

I’ve got a high dpi display on my laptop. The recommended resolution is 2560×1704. That’s small. I have had all kinds of issues with SSMS, VS, and various other applications, including a few from Redgate. The other day I was … Continue reading →

Posted in Blog | Tagged , | 4 Comments

Better ReadyRoll Script Naming

Posted on June 28, 2016 by

One of the things that I like about ReadyRoll is that the product will automatically build new scripts that are named in a sequential order. This usually results in a few scripts that look like this: As you can see, … Continue reading →

Posted in Blog | Tagged , , ,

Democratic Data Science

Posted on June 28, 2016 by

I know quite a few people that are jumping on the data science bandwagon, brushing up on statistics, learning R, and hoping to land one of those lucrative data scientist positions. I wish you good luck, and some of you … Continue reading →

Posted in Editorial | Tagged

The Desktop Rebuild–Part 2

Posted on June 27, 2016 by

You can read part 1, but that’s more about the (initial) hardware changes. This one looks at getting moving on the new desktop. Note, that since I changed the MB/CPU/Boot disk, I decided to reinstall Windows as well on a … Continue reading →

Posted in Blog | Tagged , | 1 Comment

DevOps and Security

Posted on June 27, 2016 by

DevOps is a buzzword these days, and like many of the hyped concepts written about, it has a lot of meanings. There is this idea releasing software more often, using automation, having various groups talk to each other, and more, … Continue reading →

Posted in Editorial | Tagged ,