sqlsathistory

Nr: 185

Back to Main list

SQLSaturday #185 - Trinidad 2013

Start Time (24h)	Speaker	Track	Title
00:00:00	Paras Doshi	Track 1	Why Big Data Matters?
00:00:00	Niko Neugebauer	Track 1	Inheriting a database for Developers, version 2
00:00:00	Rob Volk	Track 1	Revenge: The SQL!
00:00:00	Rob Volk	Track 1	Tame Your Unruly Data...With Constraints!
00:00:00	Aaron Nelson	Track 1	PowerShell for Data Professionals

SessionID: 11823

Why Big Data Matters?

Back to calendar

Event Date: 25-01-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Paras Doshi

Title: Why Big Data Matters?

Abstract:

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!

SessionID: 15396

Inheriting a database for Developers, version 2

Back to calendar

Event Date: 25-01-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Niko Neugebauer

Title: Inheriting a database for Developers, version 2

Abstract:

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.

SessionID: 23303

Revenge: The SQL!

Back to calendar

Event Date: 25-01-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Rob Volk

Title: Revenge: The SQL!

Abstract:

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!

SessionID: 23305

Tame Your Unruly Data...With Constraints!

Back to calendar

Event Date: 25-01-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Rob Volk

Title: Tame Your Unruly Data...With Constraints!

Abstract:

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!

SessionID: 8856

PowerShell for Data Professionals

Back to calendar

Event Date: 25-01-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Aaron Nelson

Title: PowerShell for Data Professionals

Abstract:

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.

This site is open source. Improve this page.