Tag Archives: #tsql2sday

T-SQL Tuesday #102 Wrap-Up

T-SQL Tuesday Logo

By Riley Major, 2018-05-15.

Last week I asked the Microsoft data professional community to give back… and you did. We generated 29 blog articles with inspiring stories of past contributions, advice to those beginning their journey, and plans to do more. A recurring theme was how helping others ultimately helps you– with both personal growth and professional recognition. My overarching goal was to get more people doing more things for the community. I hope the tales and goals shared this month provide the motivation for more action and continued growth of our community. Continue reading

Giving Back (T-SQL Tuesday #102 Invite)

T-SQL Tuesday Logo

By Riley Major, 2018-05-01.

A few months ago Ewald Cress asked you to share stories about people who have made a difference in your professional life. Dozens of you wrote about who impressed you, inspired you, taught you, helped you, and guided you. It’s a testament to the Microsoft data community that so many were recognized by so many– that we have those willing to give of their time and those who are publicly appreciative of it.

Now I will give you an opportunity to give back. Continue reading

T-SQL Tools

T-SQL Tuesday Logo

By Riley Major, 2018-04-10

For this month’s T-SQL Tuesday, Jens Vestergaard asks us to write about our essential SQL Server tools.

I must admit that Microsoft SQL Server Management Studio (SSMS) is where I spend most of my development time. I haven’t tried the cool kids’ new SQL Operations Studio. And I haven’t spent much time with SQL Server Data Tools. But Microsoft has come a long way from Enterprise Manager and Query Analyzer and honestly from a feature perspective, SSMS is fine.

Continue reading

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

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

Deploying the Old Fashioned Way

T-SQL Tuesday Logo

By Riley Major, 2017-05-09.

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

Mmm… fudge.

T-SQL Tuesday Logo

Kennie Pontoppidan hosts this month’s T-SQL Tuesday and asks us to write about “the daily (database-related) WTF”. I will admit that occasionally I submit to Schadenfreude. And when I get stuck cleaning up someone else’s mess, my hindsight is 20/20. I can point out all the problems they were too “ignorant” or too “lazy” to fix. And then I remember that “they” was “me”. Continue reading

“That sounds way too complex!” – Challenge Accepted!

Yesterday Adam Machanic called for new #tsql2sday hosts. I applaud his continued efforts organizing this monthly blog party. It inspires new bloggers, gently guilts those who have lapsed, and provides a topic and schedule for the uncertain. But it routinely surprised me that there was no canonical list of past events with a link to the current topic. Continue reading