Blogs

January 2009 - Posts

• SSWUG Virtual Conference

  I was happy to find out last week that I’d been accepted to speak at the SSWUG Ultimate Virtual Conference . This conference is an online event that features some really great speakers and content from April 22-24. I’ll be presenting the following sessions: Read More... Posted Wednesday, January 28, 2009 9:19 AM by Jason | 1 Comments Filed under: SQLServerSyndication, Conference

• (OT) Doctor Who

  I’m a fan of Doctor Who, both the classic series and the new series.  I’ve been watching it for as long as I can remember and just recently got my three boys hooked on to it.  They are actually interested enough that there has already been debate Read More... Posted Tuesday, January 27, 2009 6:00 PM by Jason | 1 Comments Filed under: Off Topic

• The OVER() Clause

  Thought I'd share a cool trick I picked up a while back with the OVER() clause . Typically you’d use this clause with the PARTITION BY or ORDER BY arguments with the ranking functions released with SQL Server 2005. The OVER() clause though can also be Read More... Posted Tuesday, January 27, 2009 9:04 AM by Jason | 3 Comments Filed under: DM Views, SQL 2005, SQL 2008, SQLServerSyndication

• Search Cache For Execution Plans

  Sometimes when I am working with clients I need to take a look at execution plans for different stored procedures. Rather than digging around with SQL Profiler or executing the stored procedures with what I think might be the parameters I like to '”return Read More... Posted Monday, January 26, 2009 10:30 PM by Jason | 1 Comments Filed under: SQL 2005, SQL 2008, SQLServerSyndication

• One Exam and Two Certifications

  I may sound like a broken record here, but I passed another exam today.  This morning I the exam 70-433: Microsoft SQL Server 2008, Database Development.  This exam completed my requirements for both TS: Microsoft SQL Server 2008, Database Development Read More... Posted Monday, January 26, 2009 12:04 PM by Jason | 1 Comments

• Passed Exam 70-452

  I took and passed the Microsoft exam 70-452: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008.  This completes my requirements for the certification Microsoft Certified IT Professional (MCITP) Certifications for Microsoft Read More... Posted Tuesday, January 20, 2009 1:54 PM by Jason | 1 Comments

• Raw Data

  Every now and then I need to put together demonstrations.  I don’t usually like to “invent” data and like to look for sources of raw data on the internet.  A friend forwarded me a link to www.google.org/flutrends .  The site has a download Read More... Posted Sunday, January 18, 2009 9:52 PM by Jason | 1 Comments

• Using Twitter

  I am putting this together mainly to introduce Twitter as part of social computing to some of co-workers.  Only a couple of us at my consulting firm utilize Twitter and I am hoping that this blog will inspire a few more people to give it a try and Read More... Posted Thursday, January 15, 2009 11:11 PM by Jason | 0 Comments

• Reminder January PASS MN Next Tuesday

  A friendly reminder to those in Minnesota... next Tuesday is this year’s first meeting.  The topics for the meeting are SQL Server 2008 Manageability Overview & ORM Database Design .  We have Buck Woody and Gordon Everest speaking. Read More... Posted Wednesday, January 14, 2009 9:58 PM by Jason | 0 Comments Filed under: MNSSUG

• Passed Exam 70-445

  I finally got around to taking the 70-445 exam, Microsoft SQL Server 2005 Business Intelligence–Implementation and Maintenance, and got a passing score.  I was joking beforehand that my SQL Server Analysis Services and Data Mining knowledge might Read More... Posted Wednesday, January 14, 2009 9:24 AM by Jason | 0 Comments Filed under: Certification

• Find Duplicate Foreign Keys

  A few weeks back I was working on a process that would utilize foreign keys to crawl from table to table to export data from a production database to an archive database.  More on some of what went into that process probably at some point in the Read More... Posted Tuesday, January 13, 2009 1:08 PM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008

• Scripting Object Level Permissions

  A while ago while making changes to a client database, I needed to determine all of the object level permissions that were in the database I was working on. The system stored procedure sp_helprotect turned out to be pretty useful in obtaining this information. Read More... Posted Friday, January 09, 2009 12:57 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, SQL 2000

• OPTIMIZE FOR UNKNOWN

  A good performance tuning trick in SQL Server 2008 from the SQL Programmability team and a response reminding everyone that it isn't a silver bullet from Joe Sack . While cool, this item doesn't count towards my blogging goal for the year. Too bad, still Read More... Posted Wednesday, January 07, 2009 8:30 AM by Jason | 0 Comments Filed under: SQL 2008, Performance Tuning

• January PASSMN Meeting (01/20/08)

  SQL Server 2008 Manageability Overview & ORM Database Design January 20, 2009 3:00 PM - 5:15 PM SQL Server 2008 Manageability Overview Speaker: Buck Woody, Microsoft Microsoft has released the most powerful version of SQL Server to date – and with Read More... Posted Tuesday, January 06, 2009 11:29 AM by Jason | 0 Comments Filed under: MNSSUG

• A New Year

  I've been really quiet on here as of late. So busy trying to relax that I've blown blown off posting and reading most blogs. It's been hard work but I think I have wasted enough time on my X-Box that it's time to get back to brass tacks. It's a new year Read More... Posted Monday, January 05, 2009 7:28 PM by Jason | 0 Comments