Login | Register    Search
Sponsors

PASSChapterLogo100.jpg

sql_micro_sm.gif

 Intertech .NET and Java Training | User Group Sponsorship

      
We've Gone Mobile

Now you can stay up on all the Space Coast SQL Users Group happenings... on your Windows Phone.

Chek out a demo of the mobile app here.

Download it for FREE here.

    
 

Space Coast
SQL Users Group

"A collaboration of Database Administrators, Developers and IT Professionals passionate about advancing and sharing their expertise in SQL"

  

                              

    
Group Blog

Most of us like things that make our lives easier.  When they’re free, it’s just that much sweeter.  I would have sworn I’d done a post or two on SSMS Tools Pack before, but apparently this one has slipped through the cracks.  No Longer!

SSMS Tools Pack is a free add-in for SSMS created by Mladen Prajdić.  This tool provides a whole slew of useful features that are missing from SSMS, but today I will focus on the one that has saved me several hours of time in the past week alone: The ability to Script Grid results.

Often when testing out bug fixes on development I won’t have the exact rows that are causing a problem on the prod server, or just won’t have good test data for a variety of reasons.  With SSMS TP I can run a quick query on prod and script out the rows I’d like to move over, right click in the results grid and just like that I’ve got my rows all ready to copy over and insert directly...

Read More »

This isn’t exactly the best thing since bread (or even sliced bread for that matter), but I figured I’d share this as I haven’t seen it written about in many places and I find it quite handy on a regular basis.  If you hold down the ALT key in SSMS when you’re selecting text you can draw a box around any text that you want to highlight.

InitialBox

This is quite handy in a lot of places.   I use it most often for code formatting, as I like things like blocks of variable declarations or table columns to line up all the way down.  For example:

Format1    ...

Read More »

    
Group Blog
You must be logged in and have permission to create or edit a blog.
    
Group Blog
    
Group Blog
    
View_Blog

Most of us like things that make our lives easier.  When they’re free, it’s just that much sweeter.  I would have sworn I’d done a post or two on SSMS Tools Pack before, but apparently this one has slipped through the cracks.  No Longer!

SSMS Tools Pack is a free add-in for SSMS created by Mladen Prajdić.  This tool provides a whole slew of useful features that are missing from SSMS, but today I will focus on the one that has saved me several hours of time in the past week alone: The ability to Script Grid results.

Often when testing out bug fixes on development I won’t have the exact rows that are causing a problem on the prod server, or just won’t have good test data for a variety of reasons.  With SSMS TP I can run a quick query on prod and script out the rows I’d like to move over, right click in the results grid and just like that I’ve got my rows all ready to copy over and insert directly...

Read More »

This isn’t exactly the best thing since bread (or even sliced bread for that matter), but I figured I’d share this as I haven’t seen it written about in many places and I find it quite handy on a regular basis.  If you hold down the ALT key in SSMS when you’re selecting text you can draw a box around any text that you want to highlight.

InitialBox

This is quite handy in a lot of places.   I use it most often for code formatting, as I like things like blocks of variable declarations or table columns to line up all the way down.  For example:

Format1    ...

Read More »

    
Blog_List
    
New_Blog
    
Search_Blog
    
Blog_Archive