Nr: 371
SQLSaturday #371 - Tampa 2015
SessionID: 10051
Manage Both On-Prem and Azure Databases with PowerShell
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: Azure / Prof Dev
Speaker: Allen White
Title: Manage Both On-Prem and Azure Databases with PowerShell
Abstract:
In today's world you're more likely to have databases both on premises and in the cloud. Managing databases in different environments can make your life more complicated, but with the new PowerShell cmdlets introduced with SQL Server 2014 it actually becomes easier. In this session we'll introduce you to the new cmdlets and show you how to manage your on-prem and Azure databases consistently.
SessionID: 10052
Maintain SQL Server Performance Baseline w/PowerShell
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BI 2
Speaker: Allen White
Title: Maintain SQL Server Performance Baseline w/PowerShell
Abstract:
Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
SessionID: 11125
Friendlier Data Profiling with the SSIS Data Profiler Task
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS
Speaker: Julie Smith
Title: Friendlier Data Profiling with the SSIS Data Profiler Task
Abstract:
SessionID: 11897
Introduction to Azure Machine Learning Experiments
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BI 1
Speaker: Christopher Price
Title: Introduction to Azure Machine Learning Experiments
Abstract:
With a renewed emphasis on data mining and machine learning, the Azure Machine Learning service offers customers a solid and approachable platform for developing intelligent, analytical systems. In this session, we will explore how the Azure Machine Learning service can be leveraged in the context of a typical data mining project methodology. From experiment design and model development to integration of the experiment into a line of business application, we will walk through a full lifecycle demonstration while exploring the most common and useful features.
SessionID: 11898
Master Data Service in Practice: An Integrated Approach
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: Misc
Speaker: Christopher Price
Title: Master Data Service in Practice: An Integrated Approach
Abstract:
SessionID: 13074
DevOps for the DBA - Bridging the Gap Between Infrastructure, Administration, and Development
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: Misc
Speaker: Denis McDowell
Title: DevOps for the DBA - Bridging the Gap Between Infrastructure, Administration, and Development
Abstract:
SessionID: 13258
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS
Speaker: Dan King
Abstract:
The class would be an entry level course to tuning SSIS packages and little tips and tricks to help you along the way.
SessionID: 13292
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA 1
Speaker: Dmitri Korotkevitch
Abstract:
Large multi-terabyte databases are fun to work with; however, they are expensive to host and hard to support.
In this session, Dmitri will show you the set of techniques that help to reduce the size of the databases, lower hardware requirements and improve performance of the systems.
SessionID: 13989
Advance SSIS development using .NET framework --Real work Situations--
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS
Speaker: Jorge Novo
Title: Advance SSIS development using .NET framework --Real work Situations--
Abstract:
SessionID: 13990
Reusable ssis development using Parent - Child methodology
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS
Speaker: Jorge Novo
Title: Reusable ssis development using Parent - Child methodology
Abstract:
On this session we are going to cover the creation of independent packages and how to create a package controller using
package configuration features to create a parent - child work flow. what would be cover:
Creation of ssis package controllers,
How to used package configuration features
Passing parameters from a parent package to a child package
SessionID: 14032
SQL 2014 In Memory OLTP and Natively Compiled Stored Procedures
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA 2
Speaker: Eric Wisdahl
Title: SQL 2014 In Memory OLTP and Natively Compiled Stored Procedures
Abstract:
SessionID: 14200
APPLY Yourself
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA 1
Speaker: Kevin Feasel
Title: APPLY Yourself
Abstract:
SessionID: 14317
“A New Data Architecture: Business Intelligence (BI) and Big Data Management Systems (BDMS)”
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BI 1
Speaker: Frank Quintana
Title: “A New Data Architecture: Business Intelligence (BI) and Big Data Management Systems (BDMS)”
Abstract:
The arrival of the Big Data movement (Hadoop and NoSQL) is changing the Enterprise Data Architecture. This presentation is a continuation of my previous presentation "An Introduction of Business Intelligence and Big Data"
In this presentation, I will describe advantages and disadvantages of OLTP, OLAP and Big Data, and the rise of BDMS (BIG DATA MANAGEMENT SYSTEMS). I will show how the Modern Database Architecture landscape is changing.
SessionID: 14434
Business Rules, Data Governance, and Workflow with MDS and Maestro
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BI 2
Speaker: Gene Webb
Title: Business Rules, Data Governance, and Workflow with MDS and Maestro
Abstract:
SessionID: 15739
Introduction to Wait Types and Response Time Analysis
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA 1
Speaker: Janis Griffin
Title: Introduction to Wait Types and Response Time Analysis
Abstract:
SessionID: 15740
Query Tuning - Get it Right the First Time
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA 1
Speaker: Janis Griffin
Title: Query Tuning - Get it Right the First Time
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
SessionID: 16285
Sliding Window Table Partition Intro
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA 2
Speaker: Jeff Reinhard
Title: Sliding Window Table Partition Intro
Abstract:
A walk-through of creating a sliding window table partition on an AdventureWorks table.
SessionID: 16345
How to be a GREAT DBA
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: Misc
Speaker: Jeffrey Garbus
Title: How to be a GREAT DBA
Abstract:
This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication.
Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.
SessionID: 16348
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA 1
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: 16577
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BI 1
Speaker: Jen Underwood
Abstract:
SessionID: 16670
Analysis Services: Multidimensional vs Tabular
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: Misc
Speaker: Jessica Moss
Title: Analysis Services: Multidimensional vs Tabular
Abstract:
The difference between Analysis Services Multidimensional versus Analysis Service Tabular can be difficult to understand for both new and seasoned Microsoft business intelligence developers. However, this understanding helps you to pick the model type that will provide the best possible solution for your end users. This session will describe each model type, list the pros and cons of each model type, and show developer and end user functionality for both model types. After this session, you will be able to successfully pick the right Analysis Services model type for you.
SessionID: 16789
Exploring Azure for Storage Options
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: Azure / Prof Dev
Speaker: Joe Healy
Title: Exploring Azure for Storage Options
Abstract:
Cloud is full of buzz nowadays, even for data storage. But is it right for you? When might you might want to use Azure for your data storage? During this session we'll explore the various Azure data storage options include SQL via IaaS, SQL DB, Azure Storage, DocumentDB, and using third party solutions like Mongo and MySQL in Microsoft Azure. You'll leave having a good idea of what each Azure storage option is good for, along with some of the tips and tricks of working with each. We'll also explore how to provision up storage instances and use them in your applications.
SessionID: 18085
Transactional Replication: Architecture, Setup, and Monitoring
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA 2
Speaker: Kendal Van Dyke
Title: Transactional Replication: Architecture, Setup, and Monitoring
Abstract:
At some point in every DBA's career they'll be probably be asked to work with transactional replication. While it may seem scary at first, it's not that complicated once you understand how all the parts and pieces work together. In this session we'll cover the fundamentals of how transactional replication works, walk through setting up a working replication topology, and learn how to keep an eye on things to make sure everything is working properly.
Session Goals:
• Understand core concepts of transactional replication including: replication topologies, publishers, distributors, agents, agent profiles.
• Learn how to configure a working replication topology
• Learn how to how to monitor transactional replication performance
SessionID: 18086
Transactional Replication: Tuning and Troubleshooting
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BI 2
Speaker: Kendal Van Dyke
Title: Transactional Replication: Tuning and Troubleshooting
Abstract:
At some point in every DBA's career they'll be probably be asked to work with transactional replication but most DBAs don't look under the covers once they're done walking through the setup wizards. In this session we'll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies.
Session Goals:
• Learn how to baseline performance metrics by gleaning information from the distribution database
• Show how to tune replication agent performance with agent profiles
• Demonstrate advanced troubleshooting techniques to apply when problems occur
SessionID: 18571
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA 1
Speaker: Konstantin Melamud
Abstract:
This topic will cover best practices when optimizing index performance in your DBMS. This presentation is targeted for mid to senior level DBA’s. You will learn the optimal strategy for selecting both clustered and non-clustered indexes in your database. Along the way, we will discuss how column and index statistics can affect the performance in your queries. Finally, we will take a look at the benefits and pitfalls of using filtered, full-text search and composite indexes, their best practices, and exceptions to the rules.
SessionID: 19924
Powershell Working with Windows Azure SQL Database Server
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: Azure / Prof Dev
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: 20036
A practical guide to Windows Azure SQL Database for the DBA
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: Azure / Prof Dev
Speaker: Gareth Swanepoel
Title: A practical guide to Windows Azure SQL Database for the DBA
Abstract:
What is "Windows Azure SQL Database" all about ? What does this mean for me as a DBA ? What is the process for setting up a Windows Azure database ? How would I go about migrating one of my databases to "The Cloud" ? How do I possibly leverage this new technology in my production environment ?
If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe, you have been tasked with finding out about "The Cloud". Join me in exploring the cloud where I will show you how SQL Server works in the Windows Azure SQL Database world. We will run through the simple process of configuring a Windows Azure SQL database. We will investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Windows Azure.
SessionID: 20037
SQL Server 2014 for the DBA
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS
Speaker: Gareth Swanepoel
Title: SQL Server 2014 for the DBA
Abstract:
SQL Server 2014 is the newest version of SQL Server available from Microsoft. This session is designed to introduce SQL Server DBA’s to some of the new and exciting features available in that version. Topics covered in this session include AlwaysOn enhancements, Clustered ColumnStore indexes, Memory-optimised tables (In-Memory OLTP, code-named Hekaton) and Extended Events enhancements.
The target of this session is SQL Server DBA’s, developers, architects or IT professionals who are excited about the new SQL Server 2014 features and are looking to learn more about them. This class assumes that you have average to good T-SQL skills already and a good understanding of SQL Server fundamentals.
SessionID: 20420
SQL Server 2014 In-Memory Programming
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS
Speaker: miguel Cebollero
Title: SQL Server 2014 In-Memory Programming
Abstract:
SQL Server 2014 introduces a game changer technology; in-memory objects. This session is a hands-on demo based presentation that will introduce you to what the technology is and how to use it. You will come out of this session with the knowledge and scripts that you can take back to your shop and instantly be productive. You will gain an understanding of the architecture, how to get started, indexes, natively compiled stored procedures and the limitations.
SessionID: 20494
Introducing Cube World To Users From Flat Table Land
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BI 2
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: 21617
Sentiment Analysis with Big Data
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BI 1
Speaker: Paco Gonzalez
Title: Sentiment Analysis with Big Data
Abstract:
People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning
SessionID: 22069
Extend the Reach of Power BI with Easy Data Integration
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BI 1
Speaker: Peter Evans
Title: Extend the Reach of Power BI with Easy Data Integration
Abstract:
SessionID: 22119
Getting Started with Analysis Services Tabular mode
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BI 2
Speaker: Phillip Labry
Title: Getting Started with Analysis Services Tabular mode
Abstract:
SessionID: 23152
.NET for Data Professionals
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: Misc
Speaker: Robert Biddle
Title: .NET for Data Professionals
Abstract:
No .NET experience is needed for this session. Basic understanding of programming concepts such as if/then logic and loops is suggested.
SessionID: 23442
Real World SQL Server Administration with just a bit of sysadmin
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA 2
Speaker: Ronald Dameron
Title: Real World SQL Server Administration with just a bit of sysadmin
Abstract:
It is becoming increasingly difficult to allow SQL Server database administrators to retain sysadmin permission 24x7x365 on production servers due to IT Security, Audit, and Compliance concerns.
This session will review the fundamentals needed to define a configurable permission model that allows your company’s DBAs to do routine work without them having unfettered access to business data. Several demonstrations will prove that many DBA tasks can be done without sysadmin access. Attendees will also learn how to deploy a permission model that allows DBAs to do routine work, elevate DBA permissions quickly to respond to production emergencies and how to grant sysadmin permissions during disaster recovery scenarios. Scripts will be reviewed and demonstrated that secure the database server and that can undo the permission model in case of unforeseen circumstances.
SessionID: 24633
Virtualize Clusters and AlwaysOn Availability Groups
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA 2
Speaker: Shawn Meyers
Title: Virtualize Clusters and AlwaysOn Availability Groups
Abstract:
Traditional SQL server clusters present some challenges when running under VMware this session will cover why to virtualize your SQL server cluster, when you should not virtualize your SQL server cluster and when virtualization technologies can replace clustering methods. The session will then cover best configuration options for clusters and AlwaysOn Availability Groups (AAOG). This session assumes you understand clustering and AAOG and is focusing impact of running being in a virtual environment.
SessionID: 24810
Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BI 2
Speaker: Wes Springob
Title: Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience
Abstract:
As SSRS report developers, we take for granted the security that is built in to Reporting Services. This Session explores the possibilities available to us by querying AD.
SessionID: 27350
DAX 101
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BI 1
Speaker: Damu Venkatesan
Title: DAX 101
Abstract:
In this session, we will look at the new BI query language for PowerPivot and Tabular - DAX. This session will give you an introduction to Data Analysis eXpressions (DAX) and will provide you the necessary understanding to start using in your environment for data analysis. No prior experience with DAX is needed to attend this session.
SessionID: 9585
Turbocharge Your Career With a Learning Plan
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: Azure / Prof Dev
Speaker: Andy Warren
Title: Turbocharge Your Career With a Learning Plan
Abstract:
What will you learn next quarter and why? How will you learn it? How much time and money will it cost? What is the ROI on learning those skills? Those are the questions that you answer by building a learning plan and, if you do it well, you’ll find yourself steadily pulling away from your peers.
It starts with a learning list, a place to capture skills you think you need to learn. That’s where you score each topic by estimating the effort to learn it in time and money and the value it adds to your career now and later. It’s absolutely an analog process, but it gives you the framework for answering one question: what do I learn next and why?
Once you’ve picked a topic, how do you learn more about it? Do you read blogs, buy books, or attend a class? Or all of the above? How much time makes sense? Join this session and learn how to dig into the topic to answer the questions that lead to a learning plan. After that, it’s just a matter of executing the plan!
SessionID: 9587
Common SQL Server Security Mistakes (And The Fixes)
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA 2
Speaker: Andy Warren
Title: Common SQL Server Security Mistakes (And The Fixes)
Abstract:
SessionID: 9881
Access as a fron-end ro SQL-Server
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: Misc
Speaker: Arvin Meyer
Title: Access as a fron-end ro SQL-Server
Abstract:
Microsoft Access makes an unparalleled front-end for any version of SQL-Server. This session will explain the how and why.