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"
I don’t do a lot of work with full text. It’s interesting tech and I wish I used it more. Recently we needed to do a timing run for the full population of a table with about 80 million rows. The dm_fts_index_population views shows the status while it’s populating, but not the estimated completion time […]Read more "Guessing The Completion Time of Full Text Population"
Last year I received a Fitbit Flex as a holiday gift. It’s simple enough to use, the battery life is ok, and it’s reasonably accurate in counting steps – which is what it’s supposed to do. What I found from using is that the counting function wasn’t hugely useful to me. I try to do […]Read more "Fitbit Flex and The Pebble Watch"
The schedule for Orlando Code Camp(being held on March 28, 2015) was just posted. 70 speakers, 78 sessions, and expecting a lot of attendees. I’m excited that I’ll be presenting a talk on SQL Security targeted at developers, and the rest of the track looks good, though I’ll admit I wish we could have two […]Read more "Database/SQL Track at Orlando Code Camp"
One of the conversations I had at SQLSaturday Austin was about Chapters, governance, and edge cases. To really condense and generalize, most Chapters are fairly small in terms of attendances, assets, and revenue. I’d bet it’s a handful or two at most that have bothered to incorporate and without having access to solid numbers, I’ll […]Read more "Thinking on PASS Chapter Elections"