I’m really late posting this, so the quality of the notes will suffer, but still: I did a very intro level presentation on how indexes work, stats, and queries. It’s fun to both demystify a topic while also making them realize it really is complicated stuff! I did the presentation using only a white board. […]
Read more "Notes From the February 2015 MagicPASS Meeting"Imagine you’re new to SQL Server, or new to a city, and you start looking around for networking and learning opportunities. With luck and/or experience you find your way to the local PASS Chapter web site. Once there, what do you find? Does it look professional? Is it current? Can you see what the last […]
Read more "The Appearance of PASS Chapter Websites"It’s been a few days since Microsoft and Minecraft and Training Kids was the editorial of the day and I’ve enjoyed the conversation it created. We all struggle with trying to find the balance between protecting our children and giving them time and space to grow, and it seems I’m not the only one that […]
Read more "SSC Editorial: Microsoft and Minecraft and Training Kids"Recently a local staffing company asked if I would be interested in presenting a SQL topic at a lunch they would host and market. It seemed like something interesting to explore. Local networking at its best and hopefully to a different crowd than would attend a local user group meeting. I picked security as the […]
Read more "Lunch Presentation Hosted By a Staffing Company"You might find some of this interesting: Here is the reading list published by the Army Chief of Staff. Note earlier years contain some different material, worth browsing. I’ve always liked org’s that had reading lists (though have to be wary of flavor of the year books). I marked a few from the list to […]
Read more "Stuff to Read"My friend Steve Jones sent me a link to the video Practical Refactoring. I’ve long been a fan of refactoring, though it’s been a lot of years since I read Refactoring by Martin Fowler. It’s a long lesson, about 2 hours, so I watched in chunks as I had time. Basically they take a sample […]
Read more "A Powerful Lesson on Refactoring"Reflected a bit more while driving last night on the PASS Q&A held yesterday and my in the moment notes I posted, bunch more stuff: I hope it won’t just be the officers each time. Made sense for this first effort (and maybe the next), but I think we’d like to see more of the […]
Read more "Follow Up Thoughts on the Board Q&A/Town Hall"Recently I had to answer a series of questions so that if needed I could reset my password by answering three of them correctly. Reasonably well done and a decent variety of questions. One section had a question along the lines of “the first name of your best friend from childhood”. Decent question, not many […]
Read more "Password Reset Questions and Friends With Three Letter Names"I missed the first part of the Town Hall as I had a meeting that ended at 1 pm, but I saw most of it and wanted to share some early thoughts: Excited to see this happen, good step in governance, transparency, and communication Wasn’t well advertised (but I get it was the first one, […]
Read more "Thoughts on the February 11, 2015 PASS Town Hall"A while back I was doing some routine housekeeping and ran a script Kendal Van Dyke wrote to identify duplicate statistics. Not uncommon for those to occur, queries get written that need a stat and the system creates one, later someone does some tuning and adds an index which then creates another stat. The space […]
Read more "Overlapping Stats and Unicorns"
SQLAndy 