Blogs

June 2008 - Posts

• Database Mail Failed Items Log

  Recently, I was asked why e-mails would mysteriously not be sent from one of the servers that I help maintain. One of the greatest things about working with SQL Server is most everything that happens in the server is data and all I had to figure out is Read More... Posted Thursday, June 26, 2008 1:40 PM by Jason | 0 Comments Filed under: SQL 2005 Attachment(s): Database Mail Failed Items.zip

• SQL Server 2008 Integration Services Presentation

  I mentioned in a previous post that I'd delivered a few presentations on SQL Server 2008. Nothing really more interesting to say about that today except that the SSIS presentation that I did is attached to this posting. If there are any questions on any Read More... Posted Wednesday, June 25, 2008 3:33 PM by Jason | 0 Comments Filed under: SQL 2008 Attachment(s): Complete ETL.zip

• SQL Server 2008 Reporting Services Presentation

  In the last couple months I've delivered a few presentations on SQL Server 2008 and some of the news features surrounding SSRS and SSIS. I had a couple requests for copies of the materials so this is just a post to get those out there. I plan to put out Read More... Posted Tuesday, June 24, 2008 2:33 PM by Jason | 0 Comments Filed under: SQL 2008 Attachment(s): The Power of Reporting.zip

• Database Edition msdb Sample Database Projects

  I've been working with Database Professional a little bit more these days. One of the databases that I've been working on for a while provides a number of diagnostic features that utilizes some msdb stored procedures. Fortunately, going forward I can Read More... Posted Friday, June 20, 2008 3:27 PM by Jason | 0 Comments Filed under: SQL 2005

• CLR_AUTO_EVENT Wait Stat

  I've was reviewing wait stats the other day and kept finding this wait stat peaking out the other wait stats by a few hundred milliseconds. Oh my! Should I care or not... well long story short is that if all of the CLR assemblies are created in safe mode Read More... Posted Thursday, June 19, 2008 10:49 AM by Jason | 0 Comments Filed under: SQL 2005

• Transfer Logins Between SQL Server 2005 Instances

  I've never been a fan of the SQL Server 2005 Integration Services task for transferring logins between servers. It seems that I always misconfigure it or something gets missed. And when I just want to move a single login its more effort to setup the task Read More... Posted Wednesday, June 11, 2008 1:54 PM by Jason | 0 Comments Filed under: SQL 2005

• SQL Server 2008 Release Candidate 0

  A release candidate has finally arrived... SQL Server 2008 Release Candidate 0 . I'm still downloading it, but hopefully it will make all of my dreams come true and deliver pizza. I've been told that it should at least have the rich text format textbox Read More... Posted Monday, June 09, 2008 10:09 PM by Jason | 2 Comments

• 24 Hours of SQL Server 2008

  If you haven't been keeping up with the changes for SQL Server 2008, there is a great series that is worth checking out. The 24 Hours of SQL Server 2008 webcasts. I've been watching these as they come out and I definitely have to disagree with a lot of Read More... Posted Friday, June 06, 2008 11:05 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008

• Inactive Blogging...

  I guess I've kind of sucked at blogging for the last six months. Times flies when you're being busy. Hopefully I'll catch up and complete all of the the blogs I've started. Hopefully I can finish a few of those up in the next month. Also, I hope to post Read More... Posted Thursday, June 05, 2008 10:37 AM by Jason | 0 Comments Filed under: SQL 2008