One of the many uses of tally tables is to blow up some rows. Normally, you make your database reduce rows by joining tables to others and applying criteria. But sometimes you want it to make more rows. Continue reading
By Riley Major, 2018-05-31.
When talking about bitwise math, I needed to show the inverse of a string of ones and zeros. Instead of doing it manually, I wanted to get a computer assist. Since I always have SQL Server Management Studio open, T-SQL is usually the fastest way for me to use some CPU cycles.
By Riley Major, 2018-05-18.
Known as Noughts and Crosses across the pond, Tic-Tac-Toe is considered a “solved game“– meaning we can predict the outcome of the game assuming perfect play. In fact, Wikipedia says “it is straightforward to write a computer program to play tic-tac-toe perfectly“. Well then as a programmer, I ought to be able to do it.
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
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
By Riley Major, 2018-04-26.
One of the many benefits of modern search engines is how they index our collective memory. Historically, if you remembered bits and pieces of information about something, to find out more, you’d have to ask around to learn more about the thing– like it’s actual name. A few examples stick out in my mind.
By Riley Major, 2018-04-10
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.
By Riley Major, 2018-04-04.
NDC has been “inspiring software developers since 2008”. Based in Norway, they host large conferences in Oslo, London, Sydney and for the first time this year, Minnesota. To introduce the Twin Cities to their conferences, they hosted a “micro” conference at the Saint Paul RiverCentre on Thursday evening, March 29, 2018.