Welcome to the SF Valley SQL Server User Group aka SQL Malibu!



Join us every 3rd Wednesday of every month between 6:30 pm and 9:00PM, where we network and discuss SQL Server topics. We will have swag giveaways at the end of the each presentation too. Our monthly meeting are FREE (admission and parking), casual and EVERYONE is welcome. We are WALK-IN friendly. Hope to see you very soon!!!

Register with SQL PASS and associate your profile with SQL Malibu.
Subscribe to SQL Malibu Email Marketing Campaigns or use QR Code below
QRCode

Next Meeting: Thu, Nov 19 2015

Table Partitioning in SQL Server by Brandon Leach

Language: English
Event Type: Online
Online Meeting URL: https://zoom.us/j/485174277
RSVPURL: http://sqlmalibu1511.eventbrite.com

Brandon Leach | DBA for SurveyMonkey, SQL Server Professional, Co-Organizer for the New England SQL User's Group, and Speaker

Do you find you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered yes to any of these questions, partitioning may be for you!
Partitioning allows us to break a table or index down into smaller more manageable chunks.  It can enable us to perform maintenance on just part of a table or index. We can even move data in and out of tables with quick and easy metadata only operations.
In this 75 minute session we’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and full blown table partitioning. We’ll look at how partitioning effects things under the hood to solidify our understanding of how it works. At the end of this session you’ll have a firm understanding of partitioning and be armed with the knowledge needed to make decisions on how and when to implement.

About Brandon:

Brandon is a senior DBA and veteran of IT in the healthcare industry. Originally starting out his career as a web developer, he quickly fell in love with SQL Server database development and administration. Currently he is a senior DBA for SurveyMonkey. He works closely with the development, infrastructure, and management in and out of IT to make sure the needs of the business and its future goals are met

When

iCal
UTC : Fri, Nov 20 2015 02:00 - 03:30
Event Time : Thu, Nov 19 2015 18:00 - 19:30 (UTC-08:00) Pacific Time (US & Canada)
Your Local Time: Fri, Nov 20 2015 02:00 - 03:30

Where

6600 Topanga Canyon Blvd
Canoga Park, California

Direction: None

Attachments

SQL Joke of the month

Teacher: Oracle?
“Present sir”
Teacher: DB2?
“Present sir”
Teacher: SQL Server?
“Present sir”
Teacher: MySQL?
[Silence]
Teacher: MySQL?
[Silence]
Teacher: Where the hell is MySQL
[In rushes MySQL, unshaven, hair a mess]
Teacher: Where have you been MySQL
“Sorry sir I thought it was February 31st

(source: https://sqlwithmanoj.com/2011/01/10/sql-jokes/)



Tech Art of the month

art_of_the_month