Monthly Archives: June 2016

Basic XML Node Query–#SQLNewBlogger

  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

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

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

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

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

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

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

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

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

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 ,