Blogs

Browse by Tags

• Best Practice
• Certification
• Conference
• DB Pro
• DBA
• DBADiagnostics
• DM Views
• MNSSUG
• Parallelism
• PASS
• PASS Summit
• Performance Tuning
• Sharepoint
• SQL 2000
• SQL 2005
• SQL RS
• SQL Server 2008 R2
• SQL Tips
• SSAS
• SSIS
• Tools and Tips
• Tpis & Tricks
• Whitepaper

• Grouping and Rounding Dates

  Ever need to group dates and round them to intervals?  I had this exact need for a report on wait stats I was working on for an upcoming post.  I wanted the flexibility to be able to group a list of dates by either minute, hour, date, etc.  Read More... Posted Wednesday, March 10, 2010 8:00 AM by Jason | 1 Comments Filed under: SQL 2005, SQL 2008, SQL 2000, SQLServerSyndication, SQL Tips

• March PASSMN Meeting (03/16/2010)

  It’s that time of the month again. Time to network and learn about SQL Server with your peers. Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN 55437 Date: March 16, 2010 Time: 2:30 - 5:00 Please click here for meeting details and to RSVP Read More... Posted Tuesday, March 09, 2010 8:00 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, MNSSUG, SQLServerSyndication, PASS

• Please, no TRIM()?

  A couple weeks back I was asked, “How come Microsoft has yet to put TRIM() in SQL?” I don’t really know why there isn’t a TRIM() function in SQL Server. There is an LTRIM for function removing leading spaces. And an RTRIM function for removing trailing Read More... Posted Friday, February 12, 2010 8:30 AM by Jason | 2 Comments Filed under: SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, SQL Tips

• SQL Saturday 32 – ABCs of CTEs Deck

  I’d like to thank Pam Shaw (twitter as @pamshaw ) and Jorge Nunez (twitter as @sqlchicken ) for letting me come down to Tampa this past weekend to present at SQL Saturday #32.  Jeez, that picture doesn’t make me look very happy.   For someone Read More... Posted Monday, January 25, 2010 8:00 PM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, SQLServerSyndication, Conference

• PASSMN January Meeting (01/2010)

  Figured since I helped write the meeting announcement and newsletter for PASSMN this month that I'd just copy most of the details. Since last month we've moved from our old host to a new host, so the RSVP/registration process has changed a bit. Hopefully, Read More... Posted Tuesday, January 12, 2010 7:17 AM by Jason | 0 Comments Filed under: SQL 2008, MNSSUG, PASS Summit, SQLServerSyndication, Conference, PASS, SQL Server 2008 R2

• Speaking at Tampa SQL Saturday

  I've been selected to speak at the Tampa SQL Saturday coming up at the end of January. I'm a bit pumped to be going down there since I woke up this morning to below zero weather for yet another day. Not that I'm complaining, but my feet could definitely Read More... Posted Monday, January 11, 2010 7:01 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, SQLServerSyndication, Conference

• Wait Stat Categories

  A few weeks ago I posted a job that I use to track wait stats in the DBA database that I bring to a number of clients.  I had promised to follow-up with a couple or three reports that could be used to monitor the values that were being aggregated Read More... Posted Monday, January 04, 2010 7:00 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, DBADiagnostics, DBA

• 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

• 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

• December PASSMN Meeting

  Hopefully everyone caught the news that the November PASSMN meeting was cancelled.  We had some scheduling conflicts and things didn’t come together as expected.  But to make up for that, we’ve managed to snag a speaker and room for the beginning Read More... Posted Wednesday, November 18, 2009 1:52 PM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, MNSSUG, SQLServerSyndication, PASS

• If You Don’t Know Where You’ve Been…

  If you don’t know where you’ve been, how can you expect to know where you are going.  Seems like such a simple little line and I’m sure many of us can look at history, politicians, and maybe that restaurant review that you didn’t heed when it comes Read More... Posted Wednesday, November 18, 2009 9:00 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, DBADiagnostics

• Tap, Tap, Tap – SSWUG Conference Starts Today

  The SSWUG Ultimate Virtual Conference starts this morning.  Are you planning to take advantage of this opportunity?  The Rock Star speakers are waiting in the channels, anticipating you every move.  But, have you registered? It’s not too Read More... Posted Wednesday, October 21, 2009 6:00 AM by Jason | 0 Comments Filed under: SQL RS, SQL 2005, SSIS, SQL 2008, SQLServerSyndication, Conference

• Are You Registered?

  It starts next week,the SSWUG Ultimate Virtual Conference on October 21-24 .  This is an excellent opportunity to get the benefits of heading to a conference full of Rock Star speakers while being able to view the content from the comforts of home Read More... Posted Wednesday, October 14, 2009 9:00 AM by Jason | 1 Comments Filed under: SQL RS, SQL 2005, SSIS, SQL 2008, SQLServerSyndication, Conference