Running Out of Foreign Keys is live today. Nothing too interesting about this one, a straight forward question where you know the answer or you don’t (though maybe with a few tempting answers for those that don’t quite know). Not as much fun to write these kinds of questions and this one of course is […]
Read more "Running Out of Foreign Keys-Question of the Day"
I’ll be presenting SQL Performance for Developers to the members of ONETUG on July 10, 2014. I’m going to hit all the basics of performance with a goal of showing the developer audience why things work they way they do. For example, I’ll explain why SELECT * is problematic and why database design matters – […]
Read more "Presenting at ONETUG on July 10, 2014"
Two days felt like a long time, so we found a cloud server with 16 cores we could use. We guessed on the threads and were able to run it at an average of 90% utilization (and it seems to use all the cores). The initial projection was 14 hours so it seemed better, but […]
Read more "Password Cracking–Part 2"
One of things I wish PASS provided was at least one template for an event flyer, something that is basically plug in the event information and looks professional. I wouldn’t want to see it’s use mandated, but having at least one available would be nice. Since we don’t have that (yet!), we’re on on our […]
Read more "Building The SQLSaturday Orlando Marketing Plan–Part 8"
It might or might not surprise you that I learned to code in Basic. I suppose my first real attempt at building a solution was using complex macros and batch files, but I was trying to learn more and a friend gave me a copy of Turbo Basic. I struggled to figure it out and […]
Read more "BASIC"
A quick plug today for Statistics Parser by Richie Rump, a free web site that takes the output from “set statistics io” and formats them (client side) into a tabular format. Interesting and useful to someone who doesn’t have permission to run Profiler (or know how to use it). More interesting because turning on statistics […]
Read more "Statistics Parser"
I’ve run into the not uncommon situation where there is a SQL login and no one seems to have the password. We can change it and suffer the pain, create a new account, or try to crack it. I’ve opted to at least try cracking, using the article How to recover a SQL Server login […]
Read more "Password Cracking–Part 1"
Today is Peace Officers Memorial Day and that’s why the flag is at half staff (Had to search, I didn’t remember). Small comfort probably to those that have lost someone in the line of duty. Also a reminder to the rest of us that though we may have bad days at the office, it’s never […]
Read more "Peace Officers Memorial Day and Half Staff"
Drop Me? No, I Don’t Think So is my latest question of the day and has to do with dropping a login (or trying to at least). Two points if you get it right! As I write this early in the day 38% are getting it correct, so it’s a medium hardness. Re-reading it –it’s […]
Read more "Drop Me? No, I Don't Think So–Question of the Day"
Just spent some time re-reading my notes far and my ideas from before – glad I wrote them down, lots and lots to think on and easy to forget something (though I will probably miss some things anyway). Updated thoughts: What list is the list? We have an oPASS list, a MagicPass list, and the […]
Read more "Building the SQLSaturday Orlando Marketing Plan-Part 7"