Monthly Archives: November 2012

Exploring SQL Server 2012: Code Snippets

One of the new features available in SQL Server 2012 is the Code Snippet Manager.  Previously this was available through third-party tools and add-ins.  The Code Snippets Manager is available through the Tools menu, along with some other nice built-in tools as well for this release.

Here you can see that there are many nice built-in code snippets included off the shelf.  The tool allows you to insert the XML formatted snippets (a la Visual Studio).   Click here for information on how to create your own snippets from the MSDN.  Personally I think the interface should have the functionality to just insert snippets of code like other add-in tools, however it is better than what we had previously off-the-shelf.

Figure 1 – Code Snippet Manager


This looks great but there is no insert button to put these snippets into my code, I tried.  So how do I enter the code into the query editor as I type?  Hold the control button (CTRL) and then press the K and then X to begin the insert, and yes I know this is an awkward key combination (what where they thinking).  See figure 2 and choose a category of snippets.

Figure 2 – Insert Snippet

After choosing a category then choose a snippet (see figure 3).

Figure 3 – Choose a Snippet

After choosing your snippet, it will be inserted into the query editor (see Figure 4).  At this point you can customize the snippet to fit your code and you are done!  Enjoy!

Figure 4 – The Finished Snippet





Updating SQL Server 2012 to SP1

With service pack 1 being released during SQL PASS Summit 2012, I did not get the chance to update my personal laptop.  This is great timing as I have just purchased developer on my laptop.  You can download the slipstream version or just the service pack separately.  Are you curious as to what is new in SP1, then check this link out?  It is also a good idea to read the release notes, which I always recommend but rarely do, unfortunately.  It is similar to reading the directions, men rarely do that.

Here is the visual upgrade guide, quite simple really, so much so that even I can do it.

The update completed easily and successfully.  Enjoy!

Hidden Gems for SQL 2008r2

Today I am going to bring you a great site, SQL Customer Advisory Team (SQLCAT) presents the Top Ten Hidden Gems in SQL Server 2008 R2.  If you haven’t perused the SQL CAT website, do yourself a favor and check it out.  Enjoy!

A SQL Bow Tie!

Check out my buddy’s new SQL bow ties!


Over at they have a bow tie dedicated to us SQL DBA’s! Now how cool is that! They call it the Fragmented Index a fitting name if I do say so myself. Check it out!

View original post

SQL Server 2012, Maybe?

On Wednesday of this week we spoke with Microsoft again about licensing for SQL Server 2012.  Apparently there was some confusion when we had the discussion back in March with management’s understanding of how it worked.  However, it still seems clear to me that reducing our Oracle footprint makes financially more sense.

In addition we are now being asked to prepare a proof of concept comparing the migration of ArcGIS SDE on Oracle currently to SQL Server or PostgreSQL.  I will be building a machine with each and running some tests.  Does anyone know any downsides to PostgreSQL compared to our beloved SQL Server that I can point out?  Any suggestions would be greatly appreciated.

Refocus This Blog

After writing predominantly about the PASS Summit for the last couple of months, it is hard to refocus.  Starting tomorrow, I will begin writing about SQL Server again, wow there is a novel concept.  My first Summit deserved a fair amount of attention, but now it is time to get back to business.  Enjoy!

Still Under the Weather

As I mentioned earlier today on twitter, I think I will get a flu shot next year before the Summit.  However, several friends stated that they did the same and still got sick after returning home.  Was it the air travel?  Trapped in a tube with hundreds of people or spending the week with 4,000 people from all over the world.  I am not a germophobe by any stretch and if getting sick is what it takes to meet hundreds of people from around the world then so be it.  But I wonder if I can minimize it somewhat next year.  Thoughts?

Random Summit Picture Gallery

Back to Reality

Now that Summit 2012 has come and gone, it is time to soldier on and return to reality.  With only eleven months until the next PASS Summit, apparently we will have to fill the void with actual work.  Since today is a holiday for me, I will be returning to work tomorrow and hopefully I will feel better as my servers miss me I am sure.  Until then I will enjoy my last few hours of SQL PASS adventure.  See you tomorrow.

Summit 2012: Lessons Learned

Now that I have been home a day, I thought it would be good to review some of the lessons I learned this week from attending my first SQL PASS Summit.

  1. This week is a marathon, pace yourself.  Enjoy all of the activities but get plenty of rest all week so you will be able to finish the week out.’
  2. Carrying a laptop and a bunch of crap in your backpack all week was not necessary.  Unless you are on call, use an ipad for notes or even your phone.  This added weight will wear you down quickly.
  3. Carrying a power strip was not as necessary as I thought it would be since I didn’t see very many power outlets and since I wasn’t using my laptop.  The only thing that needed charging was my phone.  The ipad holds a great charge all day long.
  4. Buy an extended battery case for your cell phone as I saw many people with them, what a great idea.
  5. Never pass up an opportunity to introduce yourself to someone who you want to meet, I did that a few times this week because they looked busy.  I did not get another chance to meet those people again.
  6. Walk, walk and keep walking.  I had no idea the amount of walking involved this week.  I usually walk about a mile three times a week, but next year I will need to be in much better shape to handle the rigors of walking everywhere all of the time.  I endured it this year but it was not easy.
  7. Be prepared to stand in hot rooms for long periods of time.  Being DBAs, we are usually sitting for most of the day.  Many of the activities here at Summit, were standing room only for hours at a time in rooms that apparently had the heat on even though it was only maybe 55 degrees outside making most of these rooms like saunas for me.
  8. Never pass up an opportunity to hang out and network with someone when it presents itself.
  9. Buy the session DVDs so that you can watch them after the conference.
  10. Most importantly, if you want to do #SQLKaraoke, put your song in early!  I put my name in every night and did not get called once.  What a bummer.

Don’t let this detour you from coming, these are just things I now know and will be better prepared for next year in order to attend the greatest event of the they year, see you then.

%d bloggers like this: