Monthly Archives: February 2012

Sunday Funday

Sunday is a great day for SQL funday, so every Sunday I will post some fun, SQL related links for your enjoyment….

Today’s installment is from one of the funniest technical presentations that I have ever seen.  If you get a chance to see it at a SQL Saturday or Code Camp near you, by all means attend.  It is by Rob Volk (blog | twitter) and it is called Revenge: The SQL! 

Enjoy this #SQLAwesomeness!

Saturday SQL Schoolhouse

SQL Schoolhouse!

Today’s installment of the Saturday SQL Schoolhouse is brought to you by our fine friends over at SQLCat, the Microsoft SQL Server Customer Advisory Team.   I thought their post on Storage Top Ten Best practices would be a great learning opportunity.  Enjoy!

SQL Server Customer Advisory Team – SQL Server Best Practices.

My Attempt To Install SSMS on Citrix….Pass (Part Two)

Yesterday I told you about my failed attempt to install SSMS for SQL Server 2008 R2 as a Citrix application and the failure that ensued.  My apologies for making you wait a day for the solution, but I was rushed with another production issue yesterday and decided to break this into two posts for dramatic effect.

Drumroll please!

 I found the following solution on several websites including Microsoft:

You need to change the following registry key locations:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0\RED\1033
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0\VSR\1033

Change the values of SP and SPIndex to 1 and SPName to SP1.  The original values in my case were 0 and RTM, respectively.  This is a strange issue because Visual Studio 2008 was never installed on this machine.

I hope this helps! Enjoy!

My Attempt To Install SSMS on Citrix….Fail

I had a goal in mind:  install SSMS on Citrix so that if I had to look at one of my SQL servers, I would not need to remote desktop into my desktop or the server itself, in case I needed to look at multiple servers.  I wanted just to set up SSMS on the Citrix server as an application so that I could quickly assess problems and avoid redecorating my three monitors when the icons get squished down into one RDP session.

 I downloaded the 2008 R2 SSMS installer from Microsoft instead of using my media.  After running the installer, I get the following error:

SSMS Install Error

 When I run Windows Update, there are no updates available for Visual Studio. 
 
Has anyone seen this before?  My Citrix administrator does not know how to proceed.  I have never seen this before.  Any ideas?
 
I will blog the solution tomorrow!  Enjoy!

February #Meme15

After reading a couple of the #Meme15 blog posts in the SQL community, brought to you by Jason Strate (blog | twitter), I thought I would join in on the fun.courtesy of Matt Velic

This month’s topic:  Why and how you use LinkedIn?

Oh LinkedIn how I love thee, let me count the ways!   Sorry, I still have Valentine’s Day stuck in my head thanks to those 75% off candy sales today.  Focus.  I have a LinkedIn profile with my resume posted.  In addition, I have connected with present and former colleagues and some of my SQL Server friends.  I have also requested and received recommendations from some of those colleagues to try to give my profile a completeness to it. 

It hasn’t always been that way.  Before I attended Mark Tabladillo‘s “Social Marketing 2011 for Microsoft Professionals” presentation at SQL Saturday #86, I did not have my full resume on my profile as I was leery for some unknown reason.  I have my resume on Monster, but something didn’t feel right, maybe it was the social aspect to the site.  After Mark told us that nearly 2/3 of all hiring was done through LinkedIn last year, I was blown away.  I went home and updated my profile that night.

In addition to the profile, I post my professional blog postings to my LinkedIn profile so that if I am ever in need of another position, there will be a rich amount of professional information available to potential employers.  At this point, I do not know whether this is a successful endeavor, but I hope to one day update this blog entry one way or the other.

#Meme On!  Enjoy!

 

Create Snapshot?

I’ve been working with VMWare snapshots, SQL Server snapshots and occasionally restore points in Windows.  With all of these options in our work life, I think we really need to be able to snapshot in real life.  Who wouldn’t enjoy reverting to a snapshot in real life?

You could say things to your boss, after you create a snapshot of course, and based on his reaction revert to snapshot or delete the snapshot.  Or, maybe you want to see how that pans out before you delete the old snapshot as it may take you to a place where you need to revert.

Now that I have mentioned it here on this blog, I am sure someone in Hollywood is working on the screenplay reminiscent of Adam Sandler‘s Click.  I’m fine with that as long as they do not get Louie Anderson to play me.  I would be ok with Leonardo DiCaprio and 10% of the backend, not his backend mind you.

Enjoy!

Cleaning Up SQL Database Mail Logging Records

This morning in my production cluster I noticed MSDB had grown to almost 10gb.  After some help from my friends at #SQLHelp, I ran one of the built-in reports, which are great…thank you Microsoft, ‘Disk Usage by Top Tables’ to tell me which table(s) had grown since I last checked this system database.  I think I found a winner: sysmail_mailitems had an outrageously high amount of records.  Why aren’t these being cleaned up in a job similar to sp_delete_backuphistory or sp_purge_jobhistory?

In order to clean these items up, use the following code:

USE MSDB

EXEC sysmail_delete_log_sp @logged_before=’2012-01-13 12:00:00′

You could script this out to run nightly or weekly and remove the last 30 days.  Enjoy!

sysmail_mailitems

Sunday Funday

Sunday is a great day for SQL funday, so every Sunday I will post some fun, SQL related links for your enjoyment….

Today’s installment is Solving Soduku with SQL!  This is a clever and fun T-SQL script, so check it out!

Enjoy this #SQLAwesomeness!

Saturday SQL Schoolhouse

SQL Schoolhouse!

In our second installment of the Saturday SQL Schoolhouse for February, I wanted to share a comprehensive website that teaches you SQL Server with numerous screenshots and detailed instructions.   It is called Fianga.com, check it out.

Enjoy!

Configuration Data Best Practice

After my recent Health and Risk Assessment visit from my Microsoft Premier Field Engineer, I learned some new and exciting  SQL Server best practices and I thought that I would share them with you in this blog space.  Our topic-o-choice today is all about backing up your configuration data.  I must admit that I have not given this topic a second thought in the past and luckily it has never bitten me before.  Microsoft defines configuration data as your sp_configure, SSIS packages and your replication topologies.  These items are not usually backed up in your nightly backups and may not be contained in your system databases.

Microsoft recommends scripting your SQL Server configuration data to a file using SELECT * FROM sys.configurations anytime you make changes to your server.  I would then include this in your disaster recovery walk-away bag or remote location destinations.  Personally, I would recommend documenting these settings if at all possible in a Word document explaining why you have chosen the settings and if they relate to your department’s best practices so that when you get hit by a bus, your replacement DBA will understand the intricacies of your choices and not chalk them up to the ‘this guy was an idiot who knew not the ways of the force.’

In addition, if you are using replication then you should script out all of the components for your disaster recovery.  It is also a good idea to back up your master and MSDB databases for the publisher, distributor and all of your subscribers.  I personally have never done that, but Microsoft recommends it…so do IT!  Enjoy!

%d bloggers like this: