Nr: 288
SQLSaturday #288 - South Florida 2014
SessionID: 11543
Check Engine Lights
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Performance (1048)
Speaker: Chris Skorlinski
Title: Check Engine Lights
Abstract:
SessionID: 11544
Your Best Interview Ever
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Professional Dev (1054)
Speaker: Chris Skorlinski
Title: Your Best Interview Ever
Abstract:
Presented by Chris Skorlinski with a collection of tips from 20 years of interviewing new hire candidates at Microsoft. He'll cover techniques for building your résumé and key strategies during interviews, whether via phone, Skype, or in-person, to increase your chances for a new job and a new adventure.
SessionID: 13043
What are you Waiting For?
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Performance (1052)
Speaker: Dean Richards
Title: What are you Waiting For?
Abstract:
SessionID: 13044
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Performance (1048)
Speaker: Dean Richards
Abstract:
SessionID: 13411
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Big Data (3047)
Speaker: David Pless
Abstract:
We will cover methods of isolating Report Server performance and we will cover how to create your own SSMS Dashboard Report with KPIs on SSRS and SQL Server Performance.
This session is a must for both DBAs and report developers.
SessionID: 13631
HDInsight utilizando Hadoop + SQL con análisis en Excel
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SQL en Espanol (3048)
Speaker: Eduardo Castro
Title: HDInsight utilizando Hadoop + SQL con análisis en Excel
Abstract:
SessionID: 13957
Database Tuning Advisor - When to use it - When not to trust it.
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Internals (1049)
Speaker: Ernest Ostrander
Title: Database Tuning Advisor - When to use it - When not to trust it.
Abstract:
SessionID: 14314
The DW and Big Data Architecture
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Big Data (3047)
Speaker: Frank Quintana
Title: The DW and Big Data Architecture
Abstract:
The problem with the old way of organizing and analyzing data in RDBMS is that it is painfully slow, incomplete and costly. We are obligated to be selective and work with data in small chunks. In the best case scenario we have been partitioning our data and archiving it with the hope to eventually use it. The fact is that when data is being archived, usually, it is never being used again. We didn’t even bother with collecting all the data due to economics and technical limitations.
The same that in the dawn of the relational revolution, the RDBMS created a new way of handling data that allowed doing it in better ways. The new breed of Big Data Management Systems BDMS, such as Cloudera and Hortonworks, are opening new possibilities to handle the renegaded and invisible data of the enterprise making possible to think about a new world, the “internet of everything”
In my presentation I will explain advantages and disadvantages of OLTP, OLAP and Big Data and the Big Data impact in the D
SessionID: 14336
Detección de cambios para el desarrollo de Warehouses
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SQL en Espanol (3048)
Speaker: Freddy Angarita
Title: Detección de cambios para el desarrollo de Warehouses
Abstract:
Observaremos las diferentes técnicas disponibles para realizar detección de cambios para el desarrollo de Warehouses, punto crítico dentro del proceso de desarrollo de ETL en un proyectos de BI a gran escala
SessionID: 14337
Desarrollo de modelos de minería de datos
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SQL en Espanol (3048)
Speaker: Freddy Angarita
Title: Desarrollo de modelos de minería de datos
Abstract:
Desarrollo de un modelo para el mundo real de un modelo de minería de datos, técnicas estadísticas y consideraciones para el modelado
SessionID: 14461
Building an MDM Center of Excellence with MDS and Maestro
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - What's New? (1047)
Speaker: Gene Webb
Title: Building an MDM Center of Excellence with MDS and Maestro
Abstract:
Learn how to build an MDM Center of Excellence with Best Practices using extensive demo. The session will including building a complete sample customer domain including data quality, merge, match and deduplication, and business workflow.
SessionID: 14856
Introduction to SSIS with BIML
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: BI (3045)
Speaker: Guillermo Caicedo Santiago
Title: Introduction to SSIS with BIML
Abstract:
Do you ever find yourself repeating the same steps over and over while developing ETL packages? BIML is an XML markup language that automates your BI patterns and reduces the manual repetition that consumes most of your development time. In this session we will learn the basics of BIMLScript and show you the benefits of creating and automating an SSIS framework.
SessionID: 15024
Azure Table vs. Azure SQL Database
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SQL Azure (3046)
Speaker: Herve Roggero
Title: Azure Table vs. Azure SQL Database
Abstract:
SessionID: 15159
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Development (3044)
Speaker: Shehab El-Najjar
Abstract:
SessionID: 15160
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Performance (1052)
Speaker: Shehab El-Najjar
Abstract:
SessionID: 15796
Maintenance and Backups: Intro to Ola Hallengren
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Auditing Maint. (1053)
Speaker: Jason Carter
Title: Maintenance and Backups: Intro to Ola Hallengren
Abstract:
This session will provide an overview of the critically acclaimed SQL Server Maintenance Solution written and maintained by Ola Hallengren. If you're using Maintenance plans, you're started in the right direction, but Ola's solution is the Gold Standard for Maintenance scripts. We will review the options and show you how these scripts can leave you more at ease with your backup, database and index maintenance duties.
SessionID: 15797
5 TSQL Commands I've Been Missing
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Development (3044)
Speaker: Jason Carter
Title: 5 TSQL Commands I've Been Missing
Abstract:
Being a full-stack .NET developer, I have written my fair share of T-SQL, but not until I became an accidental DBA did I find a new world of T-SQL options available to me. In this session, I will go over a five T-SQL commands available since SQL Server 2005 and up that I have been completely missing. We will evaluate the usefulness of CTE, OUTPUT, MERGE, APPLY, and RANKING FUNCTIONS and how each of these can replace common cases you see everyday.
SessionID: 16104
Change Data Capture a developer's unknown best friend
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Development (3044)
Speaker: Jose Chinchilla
Title: Change Data Capture a developer's unknown best friend
Abstract:
SessionID: 16771
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Performance (1048)
Speaker: Jason Hall
Abstract:
I intend to share the whys and hows of these issues with anyone who would like to attend during a SQL Saturday session.
SessionID: 16808
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Performance (1048)
Speaker: Jim Murphy
Abstract:
SessionID: 16810
AlwaysOn - Finally, A usable 'mirror'!
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Internals (1049)
Speaker: Jim Murphy
Title: AlwaysOn - Finally, A usable 'mirror'!
Abstract:
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well this feature works.
SessionID: 16994
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Development (3044)
Speaker: James McAuliffe
Abstract:
SessionID: 17117
Business Intelligence Features in SQL Server 2014
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: BI (3045)
Speaker: Joe Homnick
Title: Business Intelligence Features in SQL Server 2014
Abstract:
Joe dives into the new business intelligence features of SQL Server 2014. There are new features in Rapid data exploration in Excel and Managed self-service BI which includes Governance and compliance, insight, and oversight for IT with self-service content creation that is balanced with IT management and ease of administration through SharePoint. He will investigate credible, consistent data with BI Semantic Model along with features for Enterprise information management (EIM) encompassing Data Quality Services, Master Data Services; SQL Server Integration Services. Finally, he delves into Big Data analytics and data warehousing with support for Massive data warehousing and amazing performance with xVelocity in-memory technology.
SessionID: 17426
We Don't Need Roads:A Look Into SQL Server Indexes
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Development (3044)
Speaker: Richie Rump
Title: We Don't Need Roads:A Look Into SQL Server Indexes
Abstract:
SessionID: 17465
Tablas Particionadas: De la A a la Z
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SQL en Espanol (3048)
Speaker: Jose L. Rivera
Title: Tablas Particionadas: De la A a la Z
Abstract:
SessionID: 17529
Show me whatcha workin' with: Big Data Edition
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Big Data (3047)
Speaker: Josh Luedeman
Title: Show me whatcha workin' with: Big Data Edition
Abstract:
SessionID: 18075
Inspector Insert And The Case Of The Mistaken IDENTITY
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Auditing Maint. (1053)
Speaker: Kendal Van Dyke
Title: Inspector Insert And The Case Of The Mistaken IDENTITY
Abstract:
Think you know everything about working with identity values? Think again - they're not as straightforward as they seem! Follow along as Inspector Insert discovers the many ways to end up with a case of mistaken identity and learn how to make sure you're working with the right identity values every time. Attendees will: - Understand how identity columns work - Understand all the ways to return identity values and what factors influence their accuracy. - Learn how to always be sure they're working with the right identity values in TSQL.
SessionID: 18076
How To Build A SQL Server Virtual Lab On Your Own Machine
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - What's New? (1047)
Speaker: Kendal Van Dyke
Title: How To Build A SQL Server Virtual Lab On Your Own Machine
Abstract:
As the number of SQL Server versions and features grow over time so does the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn't enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up an AlwaysOn Availability Group? Or maybe you want to try out the latest features in SQL 2014...virtualization offers a convenient way to do any and all of these. In this session we'll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual lab on your own machine.
SessionID: 18220
Team Leadership Fundamentals
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Professional Dev (1054)
Speaker: Kevin Kline
Title: Team Leadership Fundamentals
Abstract:
- What are the fundamental ways that a new leader can build credibility and trust with their team?
- What are the unique ways in which IT people are motivated?
- How can a leader effectively communicate with their IT team using a variety of communication channels?
- How steps can a leader take to ensure that their IT team is achieving optimum effectiveness?
SessionID: 18221
SQL Server Internals and Architecture
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Auditorium (1124)
Speaker: Kevin Kline
Title: SQL Server Internals and Architecture
Abstract:
What are the various areas of memory inside of SQL Server?
How are queries handled behind the scenes?
What does SQL Server do with procedural code, like functions, procedures, and triggers?
What happens during checkpoints? Lazywrites?
How are IOs handled with regards to transaction logs and database?
What happens when transaction logs and databases grow or shrinks?
SessionID: 19057
Geospatial Data Types in SQL Server 2012
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - What's New? (1047)
Speaker: Leonard Lobel
Title: Geospatial Data Types in SQL Server 2012
Abstract:
The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, Lenni shows you how to integrate location-awareness into your own applications with the geometry and geography data types. We’ll explore the planar and geodetic spatial models, spatial markup languages such as WKT and GML, and then put these concepts to use as we build several useful demos, (e.g., Bing Maps integration). Demos show how to use the geospatial methods to easily calculate area, length, and distance, and project new shapes based on intersection and overlap. Attend this session and embrace spatial programming today!
SessionID: 19061
Native File Streaming with SQL Server 2012
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - What's New? (1047)
Speaker: Leonard Lobel
Title: Native File Streaming with SQL Server 2012
Abstract:
In this dynamic session, Lenni will teach you the ins-and-outs of unstructured data storage and native file streaming with FILESTREAM (introduced in SQL Server 2008) and FileTable (new in SQL Server 2012). Learn how to program FILESTREAM using T-SQL and, for maximum performance, using the OpenSqlFileStream API in C#. We’ll also cover the hierarchyid data type, which casts a hierarchical structure over every FileTable, and wrap up with the full-text search improvements and new Statistical Semantic Search in SQL Server 2012 that you can leverage to get the most out of unstructured documents contained in your databases.
SessionID: 19912
Powershell Working with Windows Azure SQL Database Server
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SQL Azure (3046)
Speaker: Maximo Trinidad
Title: Powershell Working with Windows Azure SQL Database Server
Abstract:
In this presentation I will be covering how to subscribe to Azure, setup PowerShell to connect your subscription, use scripting to create a SQL Database Server and then use SMO with PowerShell push data to your SQL Azure tables. All this using PowerShell scripting plus showing some editor, scripting techniques, and tips to avoid issues when working and setting Azure with PowerShell. (Live demo with Windows Azure)
SessionID: 19955
Change Tracking: A Near Bullet-Proof ETL Synchronization Control
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: BI (3045)
Speaker: Mike Byrd
Title: Change Tracking: A Near Bullet-Proof ETL Synchronization Control
Abstract:
Change Tracking came out with SQL Server 2008, but SS2012 almost eclipsed it with Change Data Capture. Change Tracking is now the red-headed step child, but in most cases may be a better solution for data ETL movement from a SQL Server OLTP database to a data warehouse database. This session will provide a review of change tracking syntax and implementation with detailed demos. It will then dive into an actual ETL subset implementation from the AdventureWorks database to a data warehouse solution (modified AdventureWorksDW) with detailed code discussion and demos. Most of presentation is demos.
SessionID: 19956
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Performance (1052)
Speaker: Mike Byrd
Abstract:
Objective of session is to show with examples when and what and how and if to implement table compression. Session will review table compression as implemented for SQL Server and then dive into many examples including benchmarking. Come to the session to see the results -- they were surprising to me!
SessionID: 19957
SQL Server Foreign Keys – De-mystifying the Rest of the Story
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Internals (1049)
Speaker: Mike Byrd
Title: SQL Server Foreign Keys – De-mystifying the Rest of the Story
Abstract:
Foreign Keys have a bad rap – they cause performance issues, they inhibit some inserts, deletes and updates, etc. This may be true, but let’s further explore why we even have them and how they can benefit and maybe even improve performance. This session will concentrate on many demos including the attributes associated with foreign keys. The attendee will walk away from this session with a better understanding of Foreign Key utility and their maintenance.
SessionID: 20488
Introducing Cube World To Users From Flat Table Land
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Big Data (3047)
Speaker: Michael Antonovich
Title: Introducing Cube World To Users From Flat Table Land
Abstract:
This session explores the tabular approach to building cubes in SQL Server Analysis Services 2012 for those DBAs and developers who are more comfortable working with relational databases than cubes. Starting with a ‘normal’ relational database, the attendee will learn how to build a basic model by loading data from several data sources, establish relations between these data sources, define measures and dimensions, build hierarchies, create KPIs and deploy functional cubes that can be used to answer management’s questions about what is really going on with their data. For users already familiar with PowerPivot, this session provides a good transition into the world of SSAS as both use essentially the same techniques.
SessionID: 20489
Hello, My Name Is DAX
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: BI (3045)
Speaker: Michael Antonovich
Title: Hello, My Name Is DAX
Abstract:
For anyone doing serious work with PowerPivot, you know that you must sometimes create additional columns calculated from the data in your existing data sources. If your data source is SQL Server, you could do this in SQL directly by just connecting to a custom view. However, for most other data sources (and for those users without develo9pment access to SQL Server) the best alternative is building expressions in PowerPivot to define new columns. DAX is also used to join tables on multiple columns and to create calculated measures. This session will explore DAX functions and expressions and how they differ from Excel expressions.
SessionID: 21099
Big Data: How To.. and Now What?
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Big Data (3047)
Speaker: Michael Reed
Title: Big Data: How To.. and Now What?
Abstract:
In this session we will discuss what big data is, the options for where to deploy a Hadoop cluster, how to get and manipulate data, and basic analytics in the Hadoop environment, along with moving data in and out of a SQL Server environment.
SessionID: 21100
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Performance (1048)
Speaker: Michael Reed
Abstract:
SessionID: 21630
Keep your sanity by using Policy Based Management to implement standards
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Auditing Maint. (1053)
Speaker: Pankaj Satyaketu
Title: Keep your sanity by using Policy Based Management to implement standards
Abstract:
SessionID: 21771
Excel in SQL Reporting
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SQL Azure (3046)
Speaker: Perry Patterson
Title: Excel in SQL Reporting
Abstract:
Did you watch Seinfeld and dream of being an IMPORTER / EXPORTER? Do your accountants, managers an other end users need their reports in excel? You don't need Vandelay Industries! Learn how to extract data directing into excel from SQL and other databases. Get out of the importing and exporting of data, and create useful SQL reports right from Excel that users can update and even modify themselves!
SessionID: 22363
Tips Tricks for dynamic SSRS Reports
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Performance (1052)
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: 22756
Building the modern architecture of hybrid data for Big Data with Microsoft and Apache Hadoop
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SQL en Espanol (3048)
Speaker: Jose Redondo
Title: Building the modern architecture of hybrid data for Big Data with Microsoft and Apache Hadoop
Abstract:
The age of knowledge: Building the modern architecture of hybrid data for Big Data with Microsoft and Apache Hadoop
Considering that knowledge is a value added for businesses today, in this exhibition show in a simple way as Microsoft and Hortonworks unite its efforts, in order to combine their data platforms ("Hortonworks Data Platform" and Microsoft: Windows, Office, SQL Server, Parallel Data Warehouse and Azure), to build with this, the modern architecture of data hybrid for Big Data. (Spanish session)
SessionID: 23892
TempDB Internals – part I
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Internals (1049)
Speaker: Sam Mesel
Title: TempDB Internals – part I
Abstract:
TempDB is a central resource for all systems and for SQL Server engine itself. A non-optimally designed system can make heavy use of TempDB, which will become the bottleneck of SQL Server
This session will discuss TempDB properties and characteristics, we will cover SQL Server startup process and its dependencies on TempDB, options and settings that can be configured, and trace flags that can be used.
The session will then put focus into User Objects, i.e., objects created explicitly by T-SQL code (temporary tables, table variables, temporary stored procedures, and so forth.. ).
Tools and code Techniques will be shown to monitor and minimize impact on TempDB.
This session is heavily based on demos
SessionID: 23893
TempDB Internals – part II
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Internals (1049)
Speaker: Sam Mesel
Title: TempDB Internals – part II
Abstract:
This session, a continuation of part I - dives into Internal Objects, i.e., objects created implicitly by SQL Server engine to address SQL processing (worktable for aggregates, hashes; cursors; sorting; aggregations; common-table-expressions; etc.).
Filled with demos this session will show these internal objects, and a myriad of tools including performance counters and DMVs to help you build your TempDB monitoring arsenal.
A discussion on TempDB data files and their placement will complete this session
SessionID: 24166
SQL Server 2014 Top 5 - Hybrid Features
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Auditorium (1124)
Speaker: Scott Klein
Title: SQL Server 2014 Top 5 - Hybrid Features
Abstract:
Microsoft SQL Server 2014 brings to market new capabilities to simplify cloud adoption and help you unlock new hybrid scenarios. This demo-filled session will highlight these top features and show how you can use these features to lower your TCO and help manage your mission-critical applications by leveraging the cloud by providing new disaster recovery and backup solutions.
SessionID: 24167
SQL Server 2014 in-memory OLTP Deep Dive
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Auditorium (1124)
Speaker: Scott Klein
Title: SQL Server 2014 in-memory OLTP Deep Dive
Abstract:
SQL Server's new In-Memory OLTP technology (codenamed 'Hekaton') promises to be one of the most exciting new features to be released when SQL Server 2014 ships. As a DBA you will have a number of questions surrounds it's internals, how it should be administered and how it will impact you high-availability design. In this session In this demo-filled session we will discuss Hekaton from a DBA perspective. We will look at Hekaton's architecture and internals, capacity planning considerations, administration considerations and how it impacts your high-availability design. He will also present some use cases and examples of where Hekaton can be used.
SessionID: 24168
SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SQL Azure (3046)
Speaker: Scott Klein
Title: SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive
Abstract:
SessionID: 24870
Choose your own adventure, be a SQL consultant
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Professional Dev (1054)
Speaker: David Cobb
Title: Choose your own adventure, be a SQL consultant
Abstract:
This non-technical talk will explore how you can create new options for your career as a DBA, SQL developer or any other I.T. profession. Drawing from the speaker's own story of experiences and observations in the field, we will discuss what makes a good consultant, how to get started working for yourself, and how to grow your technical skills, your business skills, and your own potential.
SessionID: 25868
Understanding Locking, blocking and deadlocks in SQL Server
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Auditing Maint. (1053)
Speaker: Sujai Karnam
Title: Understanding Locking, blocking and deadlocks in SQL Server
Abstract:
In this session, we will go through the SQL Server's multigranular locking mechanism that allows different types of resources to be locked during a transaction, its impact on concurrency and what leads to blocks and deadlocks.
SessionID: 26094
Exam Prep 70-462: Administering Microsoft SQL Server 2012 Databases
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Professional Dev (1054)
Speaker: Telmo Sampaio
Title: Exam Prep 70-462: Administering Microsoft SQL Server 2012 Databases
Abstract:
Attendees will be guided through the content they need to master to pass exam 70-462, be exposed to the new types of questions to expect in the exam, and learn tips and tricks from exam addict Telmo Sampaio.
SessionID: 26095
Exam Prep 70-461: Querying with SQL Server 2012
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Professional Dev (1054)
Speaker: Telmo Sampaio
Title: Exam Prep 70-461: Querying with SQL Server 2012
Abstract:
Attendees will be guided through the content they need to master to pass exam 70-461, be exposed to the new types of questions to expect in the exam, and learn tips and tricks from exam addict Telmo Sampaio.
SessionID: 27193
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Performance (1052)
Speaker: Kenneth Urena
Abstract:
- Noncluster Coverage
- Page Split
- Heaps
- Filtered Indexes
- Clustered Indexes
SessionID: 27465
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - What's New? (1047)
Speaker: Jason Virtue
Abstract:
SessionID: 27466
Power BI for the masses
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: BI (3045)
Speaker: Jason Virtue
Title: Power BI for the masses
Abstract:
SessionID: 34767
Supercharge Microsoft BI with Pyramid Analytics
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Auditorium (1124)
Speaker: Mark Scott
Title: Supercharge Microsoft BI with Pyramid Analytics
Abstract:
Mark will show you how you can Supercharge your Microsoft BI with Pyramid Analytics “BI Office”. See how BI Office gives you the “freedom to” Scale, Maximize, Visualize, and Mobilize your business users with the new Version 5. Attendees will see how easy it is to go from Analytics to Dashboards and reports in just 45 minutes. Additionally Mark will show you the mobile dashboard offering on the new iPad Air.
SessionID: 9561
Credit Card Security for the SQL DBA
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: DBA - Auditing Maint. (1053)
Speaker: Andy Warren
Title: Credit Card Security for the SQL DBA
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: 9599
Creating Access 2013 Web Apps in SQL Azure using SharePoint
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SQL Azure (3046)
Speaker: Andy Tabisz
Title: Creating Access 2013 Web Apps in SQL Azure using SharePoint
Abstract:
In this session you will…
• Learn to easily create an Access Web App in 60 seconds
• Understand automatic views
• See how Access Web Apps help knowledge experts (no coding required)
• View the online development environment
• See a production release of a real-world web app in action
• See different interfaces for within the company with clients/vendors
• Learn about integrating Office web apps
• Understand the use of hybrid applications
• Learn about app distribution, deployment and upgrades
• See the pros/cons of Access Web Apps in a corporate environment