Nashville SQL Server User Group

Announcements

Meeting Information

Monthly Meetings

Our regular monthly meetings occur on the last Friday of each month from 11:30 AM - 1:00 PM. Lunch is served during the first half hour and the scheduled session begins at noon. We meet at The Microsoft Heartland Office which is located at

The Microsoft Heartland Office
8 City Blvd, Suite 403
Nashville, TN 37209
Phone: (615) 778-2500
Fax: (615) 778-2510      

Next Meeting: Fri, May 19 2017

May Meeting: Robert Verell - Right Size Your Data Files

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Nash-SQL/events/240033798/

Topic: Right-Size Your Data Files



Best practices for SQL Server indicate that when configuring tempdb, we should create multiple files for better performance. So why is it this is often ignored for user databases, where our data is actually stored? In this session we'll look into why having multiple files for databases and filegroups is important, even on solid state drives. Then we'll look into some scripts and tools that will assist us in transforming our databases to be right-sized for performance considerations.
Speaker: Robert Verell
Robert Verell is a SQL Server professional working in the Nashville area and has worked in healthcare, insurance, and banking. He found his passion for databases by learning SQL Server Integration Services and writing stored procedures, and eventually became a database administrator. Robert is a chapter lead for the Nashville SQL Server User's Group, a volunteer for SQL Saturday, and was a finalist in the 2016 PASS Summit Speaker Idol competition.
Sponsor: Rezult Technology provides staffing solutions for companies seeking top talent. We partner with the most sought-after IT professionals to help them achieve their career goals. Our team's dedication and commitment to providing value has forged partnerships that drive technology.
Connect with NashSQL:
Twitter: http://twitter.com/NASHSQL
Email: nash@sqlpass.org
Website: http://nashville.pass.org/
All registrations after Noon Thursday 5/18 may not have lunch available. Food orders are created at Noon the day before the meeting.

When

iCal
UTC : Fri, May 19 2017 17:00 - 18:00
Event Time : Fri, May 19 2017 12:00 - 13:00 Central Daylight Time
Your Local Time: Fri, May 19 2017 17:00 - 18:00

Where

8 City Blvd
Nashville, Tennessee

Direction: None

Featured Presentation

Right Size Your Data Files

Speaker: Robert Verell, Senior Database Administrator RDX

Summary: Best practices for SQL Server indicate that when configuring tempdb, we should create multiple files for better performance. So why is it this is often ignored for user databases, where our data is actually stored? In this session we'll look into why having multiple files for databases and filegroups is important, even on solid state drives. Then we'll look into some scripts and tools that will assist us in transforming our databases to be right-sized for performance considerations.

About Robert: Robert Verell is a SQL Server professional working in the Nashville area and has worked in healthcare, insurance, and banking. He found his passion for databases by learning SQL Server Integration Services and writing stored procedures, and eventually became a database administrator. Robert is a chapter lead for the Nashville SQL Server User's Group, a volunteer for SQL Saturday, and was a finalist in the 2016 PASS Summit Speaker Idol competition.

Attachments

Offers

 

Exclusive Offers for User Group Members

Oreilly Book Discounts

 Thanks to Oreilly for providing us books to give away and providing a discount code for our users. Buy ebooks at 50% off and print books at 40% off: When you purchase a book or ebook on oreilly.com use the UG Program discount code: DSUG

 

Great Microsoft Learning Offers

Microsoft Learning has released a collection of valuable offers for the PASS user group community. Get the Microsoft Learning products that you want for less. Take advantage today of these special offers for home and office users, IT professionals, and developers by visiting: www.microsoft.com/learning/offers

 

Carry all your tech books with you anytime with one-click reference on Microsoft technologies

Microsoft Press has developed a virtual library for IT Professionals, developers and information workers who want to learn about Microsoft products and related technologies. And we want to share it with the Microsoft user group members. To learn more about the E-Reference Library, please click here (http://www.microsoft.com/learning/books/ereference/default.mspx).

 

 

 

sql_micro_sm.gif 

SIOS 

 

 

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids