Nr: 231
SQLSaturday #231 - Cocoa Beach 2013
SessionID: 10517
Real World Lessons from Starting a Software Company
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: BI
Speaker: Brian Knight
Title: Real World Lessons from Starting a Software Company
Abstract:
While starting Pragmatic Works and other companies, Brian (as with others) made a lot of naïve mistakes. In this session, he will share with you the pitfalls he found when starting a business and managing a team of developers and consultants. Learn how to create a culture in your organization or team that will help you retain employees and help your team stand out. Learn some of the mistakes that most leaders make when starting a company. Finally, learn how to turn your idea into reality and grab your first customers.
SessionID: 11905
MDS in Practice: An Integrated Approach
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: BI
Speaker: Christopher Price
Title: MDS in Practice: An Integrated Approach
Abstract:
SessionID: 12952
Dealing With Errors in SSIS 2012
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: SQL Suite
Speaker: David Dye
Title: Dealing With Errors in SSIS 2012
Abstract:
This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.
SessionID: 13377
Exploring The Microsoft Reporting Technologies
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: DBA
Speaker: David Ortiz
Title: Exploring The Microsoft Reporting Technologies
Abstract:
SessionID: 13408
Leveraging PAL for SQL Server Perfmon Analysis
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: DBA
Speaker: David Pless
Title: Leveraging PAL for SQL Server Perfmon Analysis
Abstract:
SessionID: 13700
Backup Strategies are for Losers!
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: SQL Suite
Speaker: Ed Watson
Title: Backup Strategies are for Losers!
Abstract:
Every company has a backup strategy. That backup strategy is worthless and will cause your business to fail miserably while losing valuable customer data and more importantly you will lose my order of chicken wings! In this session you will learn why backup strategies are for losers, what can I do to keep from being a loser, and how can I build a winning strategy!
SessionID: 17368
SQL Automation Using SSIS
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: SQL Suite
Speaker: Jorge Novo
Title: SQL Automation Using SSIS
Abstract:
In this session we are going to cover how to find patterns within your processes and how to used ssis to automate standard ETL processes within your organization from basic file loading to complex ETL extracts and Imports.
SessionID: 17435
The T-SQL Features in SQL Server 2012 You Can't Ignore
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Richie Rump
Title: The T-SQL Features in SQL Server 2012 You Can't Ignore
Abstract:
SessionID: 17525
SSRS: On Premises or Azure? What's the difference?
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: SQL Suite
Speaker: Josh Luedeman
Title: SSRS: On Premises or Azure? What's the difference?
Abstract:
With a lot of companies looking to the cloud for cost savings, it helps to know what the differences are between on premises and cloud installations of your IT services. In this session, we'll take a look at SQL Server Reporting Services and the feature differences between deploying in the cloud, and deploying on premises. We'll look at different options for where you can deploy your reports as well. Also, Shannon Lowder will help with the associated costs of each solution, as well as preparing you for some of the gotchas you'll face as you move to the cloud today.
SessionID: 17888
Model-Driven Database Design
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: BI
Speaker: Karen Lopez
Title: Model-Driven Database Design
Abstract:
Model-Driven Database Development: Myths, Magic and Methods. In this presentation, Karen discusses data model-driven database development from the point of view of the Data Architect, the DBA, and the Developer. She will cover topics such as "Who does what?", "Why are we doing this?", "Do I have to Use a GUI?" and "Just who do you think you are?". Demos, too. Finally, 10 tips for making model-driven database development successful in your organization's culture and environment.
SessionID: 18646
Excel 2013: BI for the Masses
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: BI
Speaker: Devin Knight
Title: Excel 2013: BI for the Masses
Abstract:
SessionID: 20373
DBA Task Automation: Unleash the PowerShell Hero in You!
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Michael Wells
Title: DBA Task Automation: Unleash the PowerShell Hero in You!
Abstract:
As DBAs, we constantly have to stretch our time and budget resources, and the best way to keep up with demands is through process automation. Workflow and PassThru parameters are just two of the features that will allow you to turn complex tasks into simple, repeatable, automated processes easier than you would have ever dreamed possible. And if you’ve had trouble with PowerShell in the past, the auto-completion and eager loading of modules will make your transition to PowerShell hero even simpler. Come see how mid-tone blue can help take your skills to the next level.
SessionID: 22331
Tips Tricks for dynamic SSRS Reports
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: SQL Suite
Speaker: Pam Shaw
Title: Tips Tricks for dynamic SSRS Reports
Abstract:
In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.
SessionID: 24925
Introduction to SQL Server Replication
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: SQL Suite
Speaker: Chad Churchwell
Title: Introduction to SQL Server Replication
Abstract:
With replication being a source for many data warehouse systems, this session will cover aspects regarding your data and business that should drive design decisions when architecting a replication topology. Discussed will be design decisions for snapshot, transactional, and merge replication. Also discussed will be agent profiles and optimizations for replication. What type of replication to use to solve business needs will also be covered.
SessionID: 26719
You Inherited a Database, Now What?
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Tim Radney
Title: You Inherited a Database, Now What?
Abstract:
SessionID: 9582
PCI For The SQLDBA
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Andy Warren
Title: PCI For The SQLDBA
Abstract:
Are you storing or planning to store credit card numbers? If so, you need to learn all you can about the requirements for PCI compliance. We'll cover how PCI works from the requirements to the final audit, and eveything in between that you'll need to know something about. We'll talk about encryption, key management, logging, alerting, administration access, granular permissions, tokenization, and as much more as we can fit into an hour. It's a complex topic, but that just makes it more interesting!
SessionID: 9899
A Balanced BI Approach (Self-Service Corporate)
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: BI
Speaker: Anthony Sammartino
Title: A Balanced BI Approach (Self-Service Corporate)
Abstract:
In this session I will cover how PowerPivot and BISM Tabular complement each other in the domains of self-service and corporate BI. Let's face it, The Finance department does not have the expertise to model a database for reporting, and IT doesn't have the expertise in advanced financial calculations that the executive team is interested in. To bridge the gap from a large requirements process with the risk of functionality lost in translation, I will show you how you can roll out a PowerPivot model for business units in your organization and when it makes sense to centralize it in a BISM Tabular model.