Our regular monthly meeting is tonight featuring David Pless from Microsoft. Here are some notes about his presentation: This discussion will continue to cover how to troubleshoot performance issues on SQL Server 2005 and SQL Server 2008. In this discussion I cover performance impact analysis using DMVs, SET options in SQL Server, and Profiler and […]
Read more "oPASS Meeting Tonight, July 13, 2010"Here’s another one that I’ve run into when linking to a SQL Server table that has a bit column. Maybe there’s a cleaner fix, in the past I’ve just changed the table to a tinyint with a check constraint. Bits are useful things, should just work.
Read more "Access Annoyance – Bit Columns"As a child did you have a place that was your ‘thing’, something that just the mention of it would throw you into an enthusiastic frenzy of ‘lets go lets go’? A place where the name got mangled a little, part child naming, part inside joke? I grew up in a semi-rural area, not much […]
Read more "Old McDonalds and The Cow Store"We’re pleased to announce that Louis Davidson will be our pre-con speaker this year at SQLSaturday #49 in Orlando. Louis will be presenting a one day seminar on database design, a worthy topic and one about which Louis is both knowledgeable and passionate, looking forward to attending it myself! The competition was definitely fierce, all […]
Read more "SQLSaturday #49 Pre-Con Announced"We had our monthly Board of Directors call on July 8th and as is fairly common, the call went smooth. Unusually though, I had two items on the agenda, the budget for the ‘spring event’ and the SQL Server Standard. The budget went through a number of revisions, starting with a super minimalist version in […]
Read more "PASS Update #36"Excited to get the email yesterday that two of my sessions were accepted, Introduction to SQL Server Statistics and Building a Comprehensive Professional Development Plan. I’ve done both presentations before, but definitely still some practice to do prior to November. Looking forward to seeing the full and final schedule. Also saw my friend Don Gabor […]
Read more "PASS Summit 2010 Sessions Accepted"During a recent call I was talking with someone about achieving a career goal (coaching in itself, though unplanned) and I suggested that someone we both knew would be an excellent coach towards achieving that goal. Finding a coach that has the expertise is usually hard, in this case I could easily name someone. Which […]
Read more "Why Would They Coach Me?"This is one of the lessons you don’t want to hear when you’re 18, or the newest member of a team stuck with all the miserable tasks, but it is, for me, one of the more simple truths in life. I’ve watched a lot of people spend time trying to avoid paying their dues, and […]
Read more "Life Lesson: Pay Your Dues"Another story with a lesson today, this one about learning to work smarter and not just harder. Easy to say, harder to do! It’s one of the cases when having a great tutor/role model/coach can help you get there a lot faster than if you have to learn it all on your own (even if […]
Read more "SSC Editorial – Learning From Experts"Here’s another quirk that has been there forever. Open up the linked table UI and select a handful of tables, like so: Note the save password box is checked. Click ok, and then you get this fun dialog after you enter your password, once for each table/view you selected. Seriously, we couldn’t get an intern […]
Read more "MS Access Annoyance: Yes, Save the Password, Again"
SQLAndy 