SQLSaturday #185 - Trinidad 2013 1/25/2013 12:00:00 AM (GMT-04:00) Caracas, La Paz SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat185 Leon Agostini Conference Hall at the Chamber of Industry and Commerce Columbus Circle, Westmoorings Port Of Spain , Trinidad and Tobago http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 2994 Fujitsu Caribbean (Trinidad) Limited Gold Sponsor http://www.fujitsu.com/caribbean/ http://www.caribbeanjobs.com/Logos/Fujitsu-Caribbean-89.gif 60 170 2995 Teleios Systems Limited Gold Sponsor http://www.teleios-systems.com/ http://developingcaribbean.org/wp-content/uploads/2012/01/Teleios-logo-COLOR1-e1326417826259.jpg 60 170 2997 Coded Blue Ltd. Gold Sponsor http://www.codedblue.com http://www.codedblue.com/SiteAssets/CBX%20-%20Coded%20Blue%20Logo%20Option%20II%20with%20Tagline%20(XtraSmall).png 60 170 2998 Resonance Trinidad Gold Sponsor http://resonancetrinidad.com/ http://www.sqlsaturday.com/files/1ec6e936-9994-44b4-9a3b-c23b8143a4dd.gif 60 170 2872 PASS Headquarters PASS Sponsor https://www.sqlpass.org http://www.orlando.sqlpass.org/Portals/265/PASS%20Images/PASSLogoBW.jpg 60 170 2837 Pluralsight Swag Sponsor http://pluralsight.com/training http://www.sqlsaturday.com/files/031e0036-f117-4449-9b8f-72028be4c2ef.png 40 100 2996 Red Gate Swag Sponsor http://redg.at/WqNofZ http://www.sqlsaturday.com/files/5cfab4e6-8e18-49ad-a29e-c806d4b2c599.jpg 40 100 2991 @SQLBeat Personal Sponsor http://www.simple-talk.com/blogs/author/195835-sqlbeat/ http://www.sqlsaturday.com/files/1bd39ff4-0af3-49fa-8ce7-977d7d0adc6e.PNG 40 100 2999 Nigel Peter Sammy Blog Sponsor http://www.nigelpsammy.com http://m3.licdn.com/mpr/pub/image-RJaV42fI38w6FiKW_5349NudCO0u7icSRa3pMpHAC_jksQ0dRJapKvGICXmPsltHuHs6/nigel-sammy.jpg 40 100 11804 SQLSatruday 185 Track 1 Room 1 1/25/2013 10:00:00 AM 1/25/2013 10:15:00 AM 11805 SQLSaturday 185 Track 1 Room 1 1/25/2013 12:15:00 PM 1/25/2013 1:15:00 PM 11806 SQLSaturday 185 Track 1 Room 1 1/25/2013 8:30:00 AM 1/25/2013 9:00:00 AM 11807 SQLSaturday 185 Track 1 Room 1 1/25/2013 3:15:00 PM 1/25/2013 3:30:00 PM 11812 Aaron Nelson Track 1 Room 1 You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool. 1/25/2013 11:15:00 AM 1/25/2013 12:15:00 PM 12171 Paras Doshi Track 1 Room 1 If you’re wondering about what is Big Data and why does it matter to you and your organization, then come to this talk and get introduced to Big Data and learn about Tools that you could start using right away! 1/25/2013 10:15:00 AM 1/25/2013 11:15:00 AM 12182 Rob Volk Track 1 Room 1 Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them...even though they deserved it! Learn how to create tables with no names, columns with duplicate names, and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you'll ache for the chance! 1/25/2013 1:15:00 PM 1/25/2013 2:15:00 PM 12184 Rob Volk Track 1 Room 1 Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page! 1/25/2013 9:00:00 AM 1/25/2013 10:00:00 AM 12486 Niko Neugebauer Track 1 Room 1 There are very few applications which are being developed from zero, the most are apps are simply inherited from previous development teams. This session serves to show some easy implementable practices to follow after inheriting a database. Those practices allow to check some if the database design was done in regards to the actual data, or if while implementing some of the constraints and checks some tables were left behind. :) The practices shown in this session will allow to check the database design and identify some of the possible performance degradations. 1/25/2013 2:15:00 PM 1/25/2013 3:15:00 PM