If a pile of matchboxes can learn to play Tic-Tac-Toe, then certainly I should be able to code a solution. With my predilection for databases, T-SQL was my tool of choice. But first, I needed to model the game with some sort of data structure. Unfortunately, as I learned, it’s not as simple as mapping some X and O values to a grid.
You might have heard that SQL Server user-defined functions are the devil. That’s because someone got burned. They put a scalar function in a WHERE clause on a big table and fed it a column name. And bad things happened. 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.
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.