Login | Register    Search
 

Space Coast
SQL Users Group

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

  

                         

    
Welcome

We meet on the second Thursday of the month at Sonny's BBQ in Viera.  Members begin gathering at 5:30pm and the meetings begin at 6:30pm.  

We are very pleased to have Valintry as our Sponsor for the Quarter.

 

    
Recommended

 

    
Sponsors

PASSChapterLogo100.jpg

sql_micro_sm.gif

 Intertech .NET and Java Training | User Group Sponsorship

    
Follow Us

Follow us on the popular social media sites...
   

    
Speakers
August 7th, 2014
Our next meeting is on Thursday, August 7th, 2014 at Sonny's BBQ in Viera, at 6:30pm
 
 We are Excited to have Richie Rump as our Guest Speaker
 
 
We Don't Need Roads: A Developer's Look into SQL Server Indexes
 
When:       August 7th, 6:30 - 8:30 PM

Where:     Sonny's BBQ in Viera, 150 Sheriff Drive, Melbourne, FL 32940

Free SQL Server Training!
Complimentary food and beverages will be served, plus we've got swag to give away!
 
Summary:  Have you ever ran a SQL or LINQ query against SQL Server and it was so slow that you wondered if the database was from 1955? You could use a Delorean or you can create indexes in your database. This session will introduce you to SQL Server indexes. Indexes are a powerful tool to improve the performance of our queries. We'll discuss how indexes are structured and why they speed up queries, how INSERT, UPDATE, and DELETE queries are affected by indexes and how to identify if an index is necessary. Then, we'll take a look at an Entity Framework application and see how EF reacts to our fresh new indexes. If you want to make bad query performance a thing of the past this session is for you.

About Richie:  Richie Rump is a software developer, data architect and project manager. Richie is a principal consultant with Jorriss LLC where he helps companies solve their data challenges using SQL Server and .Net. He holds the Project Management Professional (PMP) and Certified Scrum Master (CSM) certifications as well as certifications in various Microsoft development technologies. Richie is also the founder of the dotNet Miami, a community focused on enterprise development with .NET and SQL Server. His previous experience includes working with Burger King, Florida Power and Light, Ryder and Walt Disney World. Richie is a graduate of the University of Miami where he received a Business degree in Computer Information Systems. He can be found on Twitter at @Jorriss or at http://jorriss.com.

Valintry is our Sponsor for the 1st, 2nd and 3rd Quarter of 2014.

 

  We hope to see you there!

 

 

 

    
Techaffiliate Program

Techaffiliate Program - SCSUG Needs Points

DOUBLE DOUBLE Points for December for every item downloaded.

We get 20 points when members download Windows Azure FREE 90-Day Trial using our link; http://www.microsoft.com/click/services/Redirect2.ashx?CR_CC=200130419

We get 20 points when members register for Windows Phone Gen App using our link; http://www.microsoft.com/click/services/Redirect2.ashx?CR_CC=200130420 

We get 10 points For each member who downloads one of these apps using our link;
Windows 8
 
Visual Studio 2012 Express
 
Windows Server 2012
 
Hyper-V Server 2012
 
System Center 2012 Suite
 
Microsoft Virtual Academy
 
 
 

 

    
SCSUG BLog

Please Welcome Kathleen Branch and the new chapter leader for SCSUG

Read More »

Geeks and Fires, not a good mix!

Read More »

Quick tips to regain space on your SQL Server

Read More »

Microsoft has released performance reports available for SQL Server 2008 and higher

Read More »

Frequently DBA's are tasked with restoring databases from servers across the WAN for troubleshooting and other various reasons.  SSIS can be very useful in automating these tasks.

The following demonstrates using SSIS to automate restoring a large database to different location.
 

 

Read More »

Max Trinidad did an fantastic job presenting Extend you TSQL skills with PowerShell

Read More »

My sincere thanks to Red Gate, a premier supporter of our SQL community and their many Microsoft users. They offered a holiday competition for ideas to create the best holiday party and our input won providing the Space Coast SQL Users Group an excellent holiday party evening. We were able to provide dinner, gifts, and a free round of drinks for our members and their spouses and significant others. The party was hosted in the back room of the Broken Barrel, an excellent sports bar/family restaurant in Palm Bay, Florida.  The food was delicious and consisted of Asian potato salad, sweet potato fries, smoked wings and assorted smoked meat sliders.   Broken Barrel’s service was excellent; they even helped with suggestions on food types and combinations. The best part was the gifts weren’t technical books or left over swag like the previous years. I will never forget giving a member s wife a book on Administering Windows Server 2008.  Thankfully everyone in our group loves humor. This year I found a little store in Jensen beach that had a ton of unique gifts. We gave tickets to spouses and significant others and had each person choose a wrapped gift from the table.  I picked out several Florida Santa figurines, threw in a mounted prehistoric shark’s tooth, nice chocolates and a bottle of fine wine.   Then everyone received a ticket for our door prize, a decorated Santa on the beach. The event was an outstanding success, we cannot thank Red Gate enough for their kindness.  Everyone have a wonderful holiday and a safe New Year, I know I will.
 

Read More »

 Thank you Florida Institute of Technology and Dr. Philip Bernhard for sponsoring our group for a new meeting place!

Read More »

 

 
This was my third year attending PASS, I had the privilege of being apart of my friends first time experience at PASS Summit. It was with great pleasure I was able to introduce my friend to all the people that have helped shape my career over the past 3 years. Everyone was friendly and all the presentations she attended were spot on! Thank you all!   There is a lot of knowledge with in our community and these events really facilitate and encourage collaboration amongst the technical people. Networking and Professional Development has given an increased focus at PASS and I really believe this is critical for career growth. Are you a Linchpin was a great session. I find it very encouraging when those you admire for their technical expertise sit on a panel to and share personal experiences that have help shape their career . This humanizes the technical industry.

Read More »

A couple weeks ago a user complained that on one of our development databases, one of the views he was linking to via Access was missing some of the columns.  There were no permissions issues and the columns all showed up properly if they looked at the view via SSMS; but when they went into Access and linked to the view… the columns weren’t there.  After scratching our heads for a bit, we realized that the user didn’t have access to the User defined Types that the columns in the underlying table were designated as.  SQL doesn’t actually care about this, you can view data in the table or view whether you have the references permission or not… but Access is a bit more picky and will ignore the column if the user doesn’t have the proper permissions.  Normally we grant references on these types to Public in all the databases so that we don’t have this issue, but on this particular development server we forgot.  This is another issue that can be very puzzling when it happens out of the blue and is very hard to Google...

Read More »

    
Announcements
    
We've Gone Mobile
Mobile App - Saturday, November 12, 2011

 

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.

 

    
Upcoming Events

Event StartTitle

    
Links