Monthly Archives: August 2017

Bulk Inserting Build Data–#SQLNewBlogger

Posted on August 31, 2017 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the common tasks that many DBAs need to do is insert data into a database. Often this … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

Getting the Hyperlink from Excel

Posted on August 30, 2017 by

I had a spreadsheet of data that contained hyperlinks. In this case, it was a series of Microsoft Knowledge Base Articles with a hyperlink associated with them. I would assume there’s an easy function in Excel to extract these, but … Continue reading →

Posted in Blog | Tagged , | 2 Comments

Database Development Made Easy

Posted on August 30, 2017 by

I ran across this post on developing database with SSDT. It has a lot of steps, and reading through it, I find this to make some sense, but I’m not sure I think this is easy. I can see why developers … Continue reading →

Posted in Editorial | Tagged , | 4 Comments

The Game Night Poll

Posted on August 29, 2017 by

This year we’ve handed off Game Night to the PASS organization and it’s an official event. Volunteers from the community will help setup, manage, and tear down the event. Kevin Hill is taking the lead, but if you’re willing to … Continue reading →

Posted in Blog | Tagged , | 1 Comment

Who’s Responsible?

Posted on August 29, 2017 by

In college and for a short time afterwards, I worked at restaurants in various capacities. I’ve held most of the jobs available and enjoyed my experiences. I had good and bad bosses and sometimes had to endure questionable practices from … Continue reading →

Posted in Editorial | Tagged

The Redgate Hub

Posted on August 29, 2017 by

It’s live, but we are having a livestream event to launch this officially to the world. On September 6, 2017, I’ll be in Cambridge at the Redgate office to host a live event. Register today and join us for one … Continue reading →

Posted in Blog | Tagged ,

Graphing Performance

Posted on August 28, 2017 by

We have a lot of different database platforms to choose from when building software. Most of us reading this are SQL Server users, and likely relationally biased. However, key-value stores, document databases, graph databases, and more are out there. If … Continue reading →

Posted in Editorial | Tagged ,

The World of MySQL

Posted on August 28, 2017 by

I had two different people ping me on the same day with MySQL questions. One was a former co-worker, asking for some query help, and one was from the Boy Scouts of America, also asking for some query help for … Continue reading →

Posted in Blog | Tagged , | 3 Comments

Responsible Log Growth with dbatools

Posted on August 25, 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 , ,

The Career Bucket List

Posted on August 25, 2017 by

The Bucket List is a fun movie to watch, where two old men get a second chance at life and engage in some activities they’ve always wanted to enjoy. The idea of a bucket list isn’t new, and there are plenty of … Continue reading →

Posted in Editorial | Tagged