Author Archives: Riley Major

Machine Learning in SQL Server

T-SQL Tuesday Logo

By Riley Major, 2018-03-13

These days, most business logic is still built by subject matter experts. Humans explore their habits and instincts and try to come up with a process which business analysts turn into an algorithm which developers turn into code. That’s expensive, time consuming, and is all based on the presumption that computers need to be told what to do.

Continue reading

Midwest PHP 2018

By Riley Major, 2018-03-13

Radisson Blu and L.L. Bean at Mall of America

Midwest PHP — a Friday and Saturday $275 conference with three tracks of PHP-themed content — was hosted again at the Radisson Blu at the Mall of America on March 9th and 10th, 2018. In addition to 30 individual sessions, the conference opened and closed the event with keynotes highlighting community, inclusion, and accessibility.

Continue reading

Logical Location

T-SQL Tuesday Logo

For the 99th T-SQL Tuesday (that’s over 8 years of blog parties), Aaron Bertrand invites us to write about our #sqlibirum (credit to Drew Furgiuele and Melissa for the term)– our passions outside of SQL Server and technical community.

These days, aside from my family and technology, I’m putting most of my energy into learning more about the privileges I enjoy in society and how to dismantle the systems which provide them. Twitter has exposed me to ideas and realities which I’ve never had to face in the past, and it’s frustrating to learn about how stacked the deck is against so many people. That said, except as those issues intersect with technical communities, I’m not ready for this blog to become overtly political. So I’m going to take Aaron’s escape pod and talk about a T-SQL bad habit.
Continue reading

PASSMN SQL Saturday 2017 Survey Results

By Riley Major, 2017-11-08

Survey Responses

Back in March the PASSMN SQL Server user group published two surveys– one about the user group in general and one specific to SQLSaturday. We sent the survey invites out in emails to our user group members and to attendees of our SQLSaturday in 2016. We’ve received over 100 responses and as promised we’d like to share some insights. Continue reading

That Community

Riley Major – 2017-08-09

Buckets of bacon, piles of marshmallows, and fire (yes, real fire this year) await those in the queue snaking out the door into the hallway. Kids tired from days of water play wait to finally get mom or dad back. They dig into a giant bowl of Starbursts and bury their head in screens. “Can I have another one mom?” “I don’t care.” Continue reading

SQL Saturday 682 - Minnesota - October 7th, 2017

PASSMN SQL Saturday 2017 – Call for Speakers

PASSMN’s SQLSaturday #682 on October 7th, 2017 has been published!

There are a relatively short 5 weeks for speaker submissions, which will close on July 23rd. So don’t delay! We plan on announcing selected speakers August 4th. As a reminder, the event is on October 7th.

We are looking for some unique contributions from the speaker community. In addition to 60-minute standard sessions, we’re hoping to offer one or more panel discussions, lightning talks for new speakers, and guided conversation over lunch. We also hope to host pre-cons on Friday, October 6th. Continue reading

Deploying the Old Fashioned Way

T-SQL Tuesday Logo

For this month’s T-SQL Tuesday, James Anderson asks us to write about Shipping Database Changes.

These days all the rage is continuous deployment. Once development is “complete”, you push a button, (insert automated process here), and boom, the code is in production. I applaud shops which can reach this stage. It requires extreme devotion to automated testing and scripted processes. I haven’t worked with that sort of a system. However, many of the same principles apply to deploying the old fashioned way. Continue reading