Monthly Archives: August 2017

Bulk Inserting Build Data–#SQLNewBlogger

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

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

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

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?

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 | Leave a comment

The Redgate Hub

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 , | Leave a comment

Graphing Performance

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 , | Leave a comment

The World of MySQL

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

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 , , | Leave a comment

The Career Bucket List

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 | Leave a comment