Nr: 215
SQLSaturday #215 - Jacksonville 2013
SessionID: 10139
SQL Internals, Recovery Models, Backups! OH MY!
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA (Auditorium 2)
Speaker: Bradley Ball
Title: SQL Internals, Recovery Models, Backups! OH MY!
Abstract:
The more you know about SQL Server the more you understand how it works. SQL Server is a product we use every day, and most of us know the big concepts. At the 10,000 foot view we know what Databases, Tables, and Columns are. But what makes up those Databases, Tables, and Columns. What are Records, Pages, Extents, and Allocation Units? What are Full, Simple, and Bulk-Logged Recovery? What are the differences between Full, Transaction Log, Differential, or Filegroup backups? This is an introduction to these concepts. In this session you will learn about the internal Structure, Recovery Modes, and Backups and be better prepared to for Future Learning and Managing SQL!
SessionID: 11412
Global Address Data: Storage and Verification
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Charles Gaddy
Title: Global Address Data: Storage and Verification
Abstract:
SessionID: 11924
Building an ETL Framework with SSIS 2012
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI
Speaker: Christopher Price
Title: Building an ETL Framework with SSIS 2012
Abstract:
A lot has been said about ETL Frameworks and it's an important topic considering these frameworks are the cornerstone of any data warehouse implementation. This session will discuss building a robust enterprise ETL Framework while leveraging the architectural enhancements available in SQL Server 2012. Topics include auditing, logging, designing for fault tolerance and recoverability, handling orchestration, parallelism and finally scheduling.
SessionID: 12805
NoSQL - Couchbase and Map/Reduce
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Personal Dev Azure
Speaker: David Talbot
Title: NoSQL - Couchbase and Map/Reduce
Abstract:
NoSQL databases are setting the big data world on fire! Get introduced Couchbase and learn how to utilize Map/Reduce to navigate your data from the perspective of someone coming from a Microsoft SQL Server background.
SessionID: 13498
MDXplosion! Intro To MDX
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI
Speaker: Dustin Ryan
Title: MDXplosion! Intro To MDX
Abstract:
SessionID: 13699
Backup Strategies are for Losers!
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA (Auditorium 2)
Speaker: Ed Watson
Title: Backup Strategies are for Losers!
Abstract:
creating your recovery point and recovery time objectives, selecting the proper backup type and recovery model, and then we will be putting it all together into a winning strategy!
SessionID: 15702
Extend Your Knowledge with Extended Events!
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Janis Griffin
Title: Extend Your Knowledge with Extended Events!
Abstract:
SessionID: 15887
GeoSpatial Analytics Using Microsoft BI
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI (Auditorium 1)
Speaker: Jason Thomas
Title: GeoSpatial Analytics Using Microsoft BI
Abstract:
SessionID: 16024
Principles of BISM Tabular Modeling
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI (Auditorium 1)
Speaker: Javier Guillen
Title: Principles of BISM Tabular Modeling
Abstract:
Although BISM Tabular is a powerful analytical engine that can efficiently link data across multiple sources, it is common to get stuck when attempting to connect tables and generate calculations to leverage all sources in a single model. Many issues regularly encountered by BI developers (and data analysts when using PowerPivot) can be attributed to violations of one or more of the relationship rules of the Tabular engine. It is necessary to understand those rules in order to handle increasingly complex semantic modeling requirements.
On this session, attendees will gain an understanding of the fundamental principles which must be followed to develop effective models in BISM Tabular as well as PowerPivot.
SessionID: 16313
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA (Auditorium 2)
Speaker: Jeffrey Garbus
Abstract:
Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
SessionID: 16381
Database Projects - An Introduction
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Jonathon Moorman
Title: Database Projects - An Introduction
Abstract:
SessionID: 16958
Predictive Analytics at your fingertips
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI
Speaker: Jose L. Rivera
Title: Predictive Analytics at your fingertips
Abstract:
The Business Intelligence adoption over the last few years has grown dramatically to the point where organizations require business insights, not only from what has already happened (typical data warehousing), but from real-time performance and how will the future be, based on the business and market trends. In this session we will explore and demonstrate the main decision-making capabilities in SQL Server 2012 using Analysis Services, Data Mining and the power behind PowerPivot and PowerView hosted within Excel.
SessionID: 17194
Moving Big Data - SSIS, Pig, and Sqoop
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI (Auditorium 1)
Speaker: John Welch
Title: Moving Big Data - SSIS, Pig, and Sqoop
Abstract:
SessionID: 17356
ETL Automation Using SSIS
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI
Speaker: Jorge Novo
Title: ETL Automation Using SSIS
Abstract:
SessionID: 17402
What is a BI DBA?
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA (Auditorium 2)
Speaker: Jorge Segarra
Title: What is a BI DBA?
Abstract:
Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment from a DBA perspective then check this session out!
SessionID: 18651
Creating a Power View Reporting Solution
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI (Auditorium 1)
Speaker: Devin Knight
Title: Creating a Power View Reporting Solution
Abstract:
Power View lets you create eye-popping visualizations and provides intuitive ad-hoc reporting that a variety of business users can use to make critical decisions. But before you can begin building these incredible reports, you must have your data properly prepared. This session will give you a beginning-to-end view of what is needed to create Power View reports, from organizing a PowerPivot model source to preparing the actual Power View report.
SessionID: 19970
Complex DAX Functions
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI
Speaker: Mike Davis
Title: Complex DAX Functions
Abstract:
SessionID: 20031
SQL 2012 DMV's Extended Events
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI
Speaker: Gareth Swanepoel
Title: SQL 2012 DMV's Extended Events
Abstract:
As a lone DBA in the scary world of the SQL Server 2012 Fire Swamp, you may be wary of the multiple threats of Lightning sand, Flame spurts Rodents of unusual size. In this session, come and learn how to map your way through these threats using new and improved DMV's and Extended Events.
SessionID: 20666
Putting Quality Back Into Your Data
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI
Speaker: Michael Antonovich
Title: Putting Quality Back Into Your Data
Abstract:
SessionID: 20726
DMX - Data Mining Extensions
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI
Speaker: Mike Milligan
Title: DMX - Data Mining Extensions
Abstract:
Data Mining Extensions (DMX) is a language that you can use to create and work with data mining models in Microsoft SQL Server Analysis Services. You can use DMX to create the structure of new data mining models, to train these models, and to browse, manage, and predict against them. We will work through clustering and forecast examples and populate a relational table using SSIS.
SessionID: 22338
Tips Tricks for dynamic SSRS Reports
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Personal Dev Azure
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: 22954
Waiter, There's a Fly In My Data
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI
Speaker: Rafael Salas
Title: Waiter, There's a Fly In My Data
Abstract:
Dealing with bad data is a painful and expensive experience. In this session we will jump into SQL Server 2012 for a hands-on demonstration of cleansing and correcting data with SQL Server Data Quality Services (DQS) and Integrations Services (SSIS). We will dive into DQS knowledge-driven approach, reusability, cleansing and matching, and explore the collaboration opportunities between data stewards and IT professionals. You will demonstrate how to create a knowledge base, define domains and rules to clean data, enrich data by using third-party data providers, and use the new SSIS DQS cleansing component.
SessionID: 23146
Maintaining Indexes in SQL Server
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Robert Biddle
Title: Maintaining Indexes in SQL Server
Abstract:
So... you've created a bunch of indexes to improve the performance of your application, but then you start to notice performance degradation overtime. Digging further, you find that your indexes are not being maintained. In this session we'll look at some different systems that can be used for index maintenance. Additionally we'll explore some of the basic DMV's that provide us information about indexes.
SessionID: 24068
SQL Server Security
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA (Auditorium 2)
Speaker: Scott Gleason
Title: SQL Server Security
Abstract:
In this Session I will be covering what a normal dba/developer needs to be aware of with SQL Server’s: Logins, Roles, and Schemas. (2008 and whats new in 2012!) We’ll cover major NO/NOs, common mistakes, and point the way to best practices to tighten the security in your SQL server. We'll have about 20% slides and 80% hands on demos. :-)
SessionID: 24405
Intro to SSIS 2012 Deployment Models
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI
Speaker: Shawn Harrison
Title: Intro to SSIS 2012 Deployment Models
Abstract:
With the release of SQL Server 2012, Microsoft has killed the ever popular debate of 'Where should we deploy our packages?'. The new deployment model, with the use of environments, adds many new benefits and possibilities for different deployment scenarios. Learn the basics of the new deployment model and how to setup environments in this demo intensive session.
SessionID: 24929
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI
Speaker: Melissa Coates
Abstract:
SessionID: 24992
SQL Server VS SQL Azure
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Personal Dev Azure
Speaker: SQL Harry
Title: SQL Server VS SQL Azure
Abstract:
SQL Azure is Microsoft's relational database offering in the cloud. While it's similar to SQL Server 2008R2/2012 there are enough differences that it's important to understand what you can and cannot do with SQL Azure. This presentation gets you comfortable with SQL Azure and understand how it can best be used. Topics:
• Differences from other SQL Server 2012 editions
• Signing up for SQL Azure
• Connecting to SQL Azure
• Configuring the firewall
• Getting the right connection string from the Azure UI
• Creating a database, users and tables
• Backups and Restores
• Checking Usage and Billing information
• Approaches to scaling with
• SQL Azure Data Sync Features
• Moving schema and data up and down from the cl
SessionID: 25301
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Personal Dev Azure
Speaker: Steve Schneider
Abstract:
SessionID: 25678
ABCs of CDC with SSIS 2012
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI
Speaker: Steve Wake
Title: ABCs of CDC with SSIS 2012
Abstract:
SQL Server Integration Services (SSIS) 2012 added full support for Change Data Capture (CDC) on databases. In this session we will cover the basics of CDC in SQL Server 2012 and then how to build SSIS 2012 packages that make using CDC to load your Data Warehouses easier than they were before. No previous knowledge of CDC is required for this session, but some knowledge of any version of SSIS will make it easier to understand.
SessionID: 26023
Adventures in Job Hunting
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Personal Dev Azure
Speaker: Tom Brenneman
Title: Adventures in Job Hunting
Abstract:
This session will cover in how to properly research companies, interview, properly resign and how to brand yourself.
SessionID: 26828
A Walk Around the SQL Server 2012 Audit Feature
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Timothy McAliley
Title: A Walk Around the SQL Server 2012 Audit Feature
Abstract:
In this session, we will start by covering an overview of server and database auditing capabilities of SQL Server 2012. The session will largely focus on the specifics of using the SQL Server Audit feature, and we will step through a demonstration on configuring, maintaining and troubleshooting SQL Server Audit for server and database events.
SessionID: 9126
Iron Chef - Traditional vs Self Service BI
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: BI (Auditorium 1)
Speaker: Adam Jorgensen
Title: Iron Chef - Traditional vs Self Service BI
Abstract:
Come watch two titans of tech showcase their "talents" while they compete in building BI solutions using two different methods. One will use Self-Service BI techniques while the other uses traditional methods of building BI solutions. This continuing saga proves to be epic as usual!
SessionID: 9127
Roping the Elephant - Hadoop and BI Live!
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Personal Dev Azure
Speaker: Adam Jorgensen
Title: Roping the Elephant - Hadoop and BI Live!
Abstract:
Have you been wondering how you can sit down at work and use Hadoop to make your BI better? Have you thought about what Big Data could mean to your firm? Come watch Adam setup, populate, consume and integrate data from a Big Data Platform into a SQL BI solution Live!
SessionID: 9878
Database Requirements
Event Date: 27-04-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Arvin Meyer
Title: Database Requirements
Abstract: