Blogs

December 2009 - Posts

• Pushing Excel Through A Wormhole

  With the next release of SQL Server, data analysis is going to go through a major change with the PowerPivot add-in for Excel and SharePoint.  If you haven’t been keeping up with these changes to Business Intelligence, SSWUG.org has an opportunity Read More... Posted Thursday, December 31, 2009 7:30 AM by Jason | 0 Comments Filed under: Sharepoint, SQLServerSyndication, Conference, SQL Server 2008 R2, Business Intelligence

• MCM Reading List – A New Years Resolution

  I’ve blogged about certifications a number of times in the past.  One of the certifications that I really want to obtain in the future is the Microsoft Certified Master (MCM) for SQL Server 2008 .  This is a great certification that really dives Read More... Posted Tuesday, December 29, 2009 11:00 PM by Jason | 0 Comments Filed under: SQL 2008, Certification, SQLServerSyndication

• PASSMN for 2010

  Another year is passing and with the end of the year it seems like a good time to do a quick update on where PASSMN is sitting.  I had planned to mention this last week but that whole work thing got me all sidetracked. We had our final meeting Read More... Posted Monday, December 21, 2009 7:23 AM by Jason | 0 Comments Filed under: MNSSUG, SQLServerSyndication, PASS

• December PASSMN Meeting This Week

  In case you missed the last reminder or hadn’t heard.  We are having a PASSMN meeting in December this year.  Check out the event details below and take a chance to learn new things with some of your fellow SQL Server professionals. Don't Wait! Read More... Posted Sunday, December 06, 2009 5:00 PM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, MNSSUG, SQLServerSyndication, PASS

• Does Your Stored Procedure Grant Itself Permissions?

  It’s a very good question. One that might not seem to insidious. Nothing that should be able to bring down the system and cause failures. Or will it? I’ve been to a number of clients and done it myself before where I start to check out a stored procedure Read More... Posted Thursday, December 03, 2009 7:00 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, DBA

• Deadlocks on exchangeEvent and threadpool

  I got to work with deadlocks quite a bit recently.  There were quite a few interesting ones that came up that I had the chance to research.  Since I like easy, I’ll start with the one that I forgot to grab the deadlock details for. Well, maybe Read More... Posted Wednesday, December 02, 2009 7:00 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, Parallelism