Nr: 318
SQLSaturday #318 - Orlando 2014
SessionID: 10053
Get Near Realtime ETL with Service Broker
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Cloud/Security
Speaker: Allen White
Title: Get Near Realtime ETL with Service Broker
Abstract:
SessionID: 10057
Manage Both On-Prem and Azure Databases with PowerShell
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Cloud/Security
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: 10062
Maintain SQL Server Performance Baseline with Powe
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Bonus Track
Speaker: Allen White
Title: Maintain SQL Server Performance Baseline with Powe
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: 10174
Indexing Internals for Developers
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: SSIS/Virtualization Track
Speaker: Bradley Ball
Title: Indexing Internals for Developers
Abstract:
What are the secrets to making your queries run faster? Why does SQL Server use an index for some queries and not for others? What makes a good index? How many indexes should I have? Have you ever asked these questions? When you want to understand an application you look at its core architecture. Underneath the covers SQL Server is just a C++ application. Together we will discuss how the application architecture of SQL Server works, and how to apply this logic to building the best indexes for your queries.
SessionID: 11095
ETL in a Nutshell with SSIS
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: SSIS/Virtualization Track
Speaker: Brett Tomson
Title: ETL in a Nutshell with SSIS
Abstract:
SessionID: 11167
Get Your Nights Weekends Back from SQL Server Planned Downtime
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin 2 Track
Speaker: Carl Berglund
Title: Get Your Nights Weekends Back from SQL Server Planned Downtime
Abstract:
Major disaster events resulting in unplanned downtime get all the press—but planned downtime constitutes almost 80% of the outages in any IT environment. This downtime is typically for tech refresh, migration projects, and OS/SQL Server patching. And when do you have to schedule the large downtime windows required to accomplish these upkeep tasks? Nights and weekends. Like you don't have better things to do then! In this session, learn how you can get in-place upgrades for OS and/or SQL Server as fast as SQL Server can stop restart, no data migrations for tech refresh, low-impact break/fix, and planned downtime windows of less than 2 minutes.
SessionID: 11860
Tired of the CRUD? Automate it!
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI/Big Data/Misc
Speaker: Jack Corbett
Title: Tired of the CRUD? Automate it!
Abstract:
After this session you will:
- Understand the basics of T4 templating
- Have a basic understanding of the Dac object model
- Be able to create a script that will create 100's or even 1000's of CRUD procedures in seconds.
SessionID: 12614
Easy SQL Server Benchmarking
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin 2 Track
Speaker: David Klee
Title: Easy SQL Server Benchmarking
Abstract:
SessionID: 12877
A DiBA guide to Database Standards
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin 2 Track
Speaker: Diana Betancourt
Title: A DiBA guide to Database Standards
Abstract:
If you work with SQL Server, either as a developer, Dev/DBA, or accidental DBA, we are all DiBA's! but in order to keep that status and not run into "fire drill" mode, you need to make sure you set the ground to keep on looking good. This session will focus on how to set your Database Server environment in a way that will switch you from reactive to proactive mode. And I will demo its implementation via Policy Based Management.
SessionID: 13297
How To Kill SQL Server in 60 Minutes
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin 2 Track
Speaker: Dmitri Korotkevitch
Title: How To Kill SQL Server in 60 Minutes
Abstract:
It is easy to design a system that uses SQL Server as a database backend. However, designing a system that efficiently works under heavy load is a much more complicated task. You can encounter the same set of database design and code mistakes in almost every system implemented by a team of application developers.
This Power Point-free session is targeted to developer DBAs and developers. It shows the commonly encountered obvious and not-so-obvious database design and T-SQL code mistakes and demonstrates how to bring a perfectly healthy SQL Server to its knees in just 60 minutes.
SessionID: 13483
How In-Memory Database Objects Affect Database Design
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: T-SQL/SQL 2014 Track
Speaker: Louis Davidson
Title: How In-Memory Database Objects Affect Database Design
Abstract:
SessionID: 13711
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Performance Track
Speaker: Ed Watson
Abstract:
SessionID: 13987
Dynamic File Loading Using SSIS Programming
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: SSIS/Virtualization Track
Speaker: Jorge Novo
Title: Dynamic File Loading Using SSIS Programming
Abstract:
Every organization has to deal with the constant loading of text,csv,excel,pipe, fixed width, and ragged right files in this session we are going to build metadata driving ETL framework that will dynamically create an standard SSIS template that will encompass the file format, enforce standards, and keep track of data lineage across an organization.
SessionID: 14034
SQL 2014 In Memory OLTP and Natively Compiled Stored Procedures
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: T-SQL/SQL 2014 Track
Speaker: Eric Wisdahl
Title: SQL 2014 In Memory OLTP and Natively Compiled Stored Procedures
Abstract:
SessionID: 14417
Learn How To Build A Golden Record for Any Subject Over Lunch!
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI Track
Speaker: Gene Webb
Title: Learn How To Build A Golden Record for Any Subject Over Lunch!
Abstract:
Attend the lunch demo and see how you can use Master Data Services and Maestro to:• Create a golden record for any subject area in a matter of minutes Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment?• Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything?• Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting• Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise
SessionID: 14419
Building an MDM Center of Excellence with MDS and Maestro
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI Track
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: 14501
Cloudy with a Chance of Data
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Cloud/Security
Speaker: Geoff Hiten
Title: Cloudy with a Chance of Data
Abstract:
Cloud, Cloud, Cloud. Microsoft is "all in". CxOs love the idea of renting compute resources. You know this is where our profession is headed, but when and how fast. When should you jump on board? The good news is cloud will not eliminate or even reduce the need for IT and Data professionals. The bad news is our world and our profession is changing. Adapt or be left behind. Come see what Microsoft Azure has to offer Data Professionals.
SessionID: 14836
T-SQL Best Practices
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: T-SQL/SQL 2014 Track
Speaker: Greg Larsen
Title: T-SQL Best Practices
Abstract:
This presentation covers a number of different SQL Server T-SQL coding best practices. There will be a discussion around each best practice so attendees will better understand the rationale behind each. Some of the best practices will have a demo to showing how different coding styles arrive at the same answer while using different amounts of SQL Server resources (CPU, and I/O). These demos will help attendees better understand how poor coding practices produce sub-optimal execution plans.
SessionID: 14857
SQL Server 2014 Hybrid Cloud Features
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Cloud/Security
Speaker: Guillermo Caicedo Santiago
Title: SQL Server 2014 Hybrid Cloud Features
Abstract:
These days, it seems like everything is moving to the cloud. Are you ready to begin your transition and take advantage of what the cloud offers you? Join us for an overview of the SQL Server 2014 hybrid cloud features and learn how to start your transition to the cloud.
SessionID: 15728
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Performance Track
Speaker: Janis Griffin
Abstract:
SessionID: 15810
Encryption 101: A look at SQL Encryption Options
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Prof Dev/Security
Speaker: Jason Carter
Title: Encryption 101: A look at SQL Encryption Options
Abstract:
Are your backups like a stack of cash free for the taking, or a hardened ATM? Are your database connections scrambled and safe or are you sending data over the party line? In this session we will walk through the many ways SQL Server allows us to protect our data using encryption. We will evaluate the various methods for protecting data at rest, in the database, and while in transport. Since nothing comes for free, we will look at how much all of this is going to cost us, in time, money, and failure to implement.
SessionID: 15852
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Performance Track
Speaker: Jason Horner
Abstract:
SessionID: 15912
DataViz You Thought You Couldn't Do with SSRS
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI Track
Speaker: Jason Thomas
Title: DataViz You Thought You Couldn't Do with SSRS
Abstract:
SessionID: 16353
How to be a GREAT DBA
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Prof Dev/Security
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: 16389
Database Projects
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin Track
Speaker: Jonathon Moorman
Title: Database Projects
Abstract:
SessionID: 16779
TempDB Parasites!
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin Track
Speaker: Jason Hall
Title: TempDB Parasites!
Abstract:
Unless you happen to be Chuck Norris, your SQL Server instances only have one tempDB. That makes tempDB a single point of contention for an instance. What’s worse is that there are a lot of things going on in tempDB that you may not be aware of. Let’s look at some things that can use tempDB while we’re not looking.
SessionID: 16995
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI Track
Speaker: James McAuliffe
Abstract:
SessionID: 17462
Database Design Disasters: Common Mistakes Found in the Wild
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Performance Track
Speaker: Richie Rump
Title: Database Design Disasters: Common Mistakes Found in the Wild
Abstract:
Not every system has a database architect available to design it. But what happens when a database is created and the proper care wasn't taken into designing it? This session will take a real-world look into my experiences with some database design choices. We'll take a deep look into these design choices including a detailed discussion on why they didn't work and what could have been done better. We may even take a peek into SQL Server internals. This session is primarily for data professionals that are new to database design.
SessionID: 17473
Mastering T-SQL Window Functions
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: T-SQL/SQL 2014 Track
Speaker: Jose L. Rivera
Title: Mastering T-SQL Window Functions
Abstract:
TSQL window functions, originally introduced in SQL Server 2005, have proven to be quite useful to solve complex ranking and aggregation scenarios. The new additions in SQL Server 2012 make them irresistible. In this session, we will discuss how to use them and highlight the new order, offset and distributions functionalities in real-world examples.
SessionID: 17531
Show me whatcha workin' with: Big Data Edition
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI/Big Data/Misc
Speaker: Josh Luedeman
Title: Show me whatcha workin' with: Big Data Edition
Abstract:
SessionID: 17549
An Introduction to FileTables
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin Track
Speaker: John Pertell
Title: An Introduction to FileTables
Abstract:
With the release of SQL Server 2012 Microsoft introduced FileTables, a better way to store large objects inside a database. With FileTables you get the advantage of the security and transactional consistency of a database AND improved file streaming from the OS. In this session I'll show you how easy it is to set up and use FileTables, as well as improved methods of searching document keywords with FullText and Semantic searches.
SessionID: 17963
Flash 101- An Introduction to Flash Storage for MS SQL Server and Data Centers
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: T-SQL/SQL 2014 Track
Speaker: Karla Landrum
Title: Flash 101- An Introduction to Flash Storage for MS SQL Server and Data Centers
Abstract:
SessionID: 18088
Discover, Document, Diagnose Your Servers on Your Lunch Break
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Bonus Track
Speaker: Kendal Van Dyke
Title: Discover, Document, Diagnose Your Servers on Your Lunch Break
Abstract:
Documentation is the bane of every DBA's existence. We all know we should do it but it's time consuming; by the time you're finally done it's probably out of date. Throw in the new servers you just found out about last week and keeping documentation up to date can turn into a full time job. And with everything we have to do in our day, who has time for that?
You need a way to work smarter, not harder, and automate your documentation. It can be done, and in this session you'll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches - all while you're out at lunch. You'll look like a rock star without writing a line of code on your own or having to ask management to sign a check.
Attend this session and walk away with everything you need to generate documentation for your entire SQL Server environment on your first day back at the office
SessionID: 18657
Getting Started with Power Query
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI Track
Speaker: Devin Knight
Title: Getting Started with Power Query
Abstract:
SessionID: 19009
Why I won't hire you and what you can do about it!
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Prof Dev/Security
Speaker: Leigh Freijo
Title: Why I won't hire you and what you can do about it!
Abstract:
SessionID: 19673
Big Data Analytics with SQL Server, Hadoop and MongoDB
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI/Big Data/Misc
Speaker: Mark Kromer
Title: Big Data Analytics with SQL Server, Hadoop and MongoDB
Abstract:
If you would like to see how real businesses build real-world Big Data Analytics solutions, then come to this session. I will dive right into a number of reference architectures and demos of Big Data Analytics using SQL Server, Hadoop and MongoDB.
SessionID: 19870
SQL Security Best Practices Shrinking Your Attack Surface
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Prof Dev/Security
Speaker: Matthew Brimer
Title: SQL Security Best Practices Shrinking Your Attack Surface
Abstract:
Every industry has a governing body or standard that requires some layer of security to your data. In my travels I have come to realize that when someone mentions security, DBA's tend to get frightened. This could be due to a lack of understanding of the requirements or not knowing what SQL Server offers to meet those requirements. In this session we will go over what SQL Server has to offer, Security Best Practices and how you can shrink your attack surface to meet Confidentiality, Integrity and Availability of your Servers and Data.
In addition, attending this talk is worth 1.5 Continuing Education credits.
SessionID: 19919
Powershell Working with Windows Azure SQL Database Server
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Cloud/Security
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: 20035
A practical guide to Windows Azure SQL Database for the DBA
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin Track
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: 20241
Virtualizing SQL Server: Doing IT Right - The SeQueL
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: SSIS/Virtualization Track
Speaker: Michael Corey
Title: Virtualizing SQL Server: Doing IT Right - The SeQueL
Abstract:
SessionID: 20424
Database Development Comes out of the Dark Ages
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin 2 Track
Speaker: miguel Cebollero
Title: Database Development Comes out of the Dark Ages
Abstract:
SessionID: 20610
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Performance Track
Speaker: Mike Lawell
Abstract:
This is a very demo intensive session some basic issues and performance analysis that will be used as a starting point for performance tuning.
There will be homework!
SessionID: 20635
Test Automation - Where to Start
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin Track
Speaker: Mikey Nelson
Title: Test Automation - Where to Start
Abstract:
SessionID: 21727
Permission Management: 12 Pitfalls Misconceptions
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Cloud/Security
Speaker: Sebastian Meine
Title: Permission Management: 12 Pitfalls Misconceptions
Abstract:
This is a two-part session. During the first part, we will go through a review of SQL Server security terms and concepts, particularly the GRANT, REVOKE and DENY statements. For the second part, the audience selects topics that we will cover in detail. You will be able to choose from 12 different security pitfalls and misconceptions. All these pitfalls/misconceptions have one thing in common: If you are not aware of them, you might GRANT or DENY more permissions than you intended.
SessionID: 22284
Re-Indexing - The quest of ultimate automation
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin 2 Track
Speaker: Prakash Heda
Title: Re-Indexing - The quest of ultimate automation
Abstract:
In this session, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a dynamic re-indexing script , created based on his real-life experience from managing high performing database systems.
SessionID: 22368
Tips Tricks for dynamic SSRS Reports
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI/Big Data/Misc
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: 22580
Understanding the SQL Server Transaction Log
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin Track
Speaker: Randy Knight
Title: Understanding the SQL Server Transaction Log
Abstract:
The SQL Server transaction log is one of the most misunderstood components of the database engine. What makes it grow? How does it get truncated? Should I shrink it? What is a VLF? In this session we will answer these questions and more.
SessionID: 22677
Getting Started with Hekaton (In-Memory OLTP)
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: T-SQL/SQL 2014 Track
Speaker: Brian Davis
Title: Getting Started with Hekaton (In-Memory OLTP)
Abstract:
SessionID: 23151
Loading a Data Warehouse with SSIS
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: SSIS/Virtualization Track
Speaker: Robert Biddle
Title: Loading a Data Warehouse with SSIS
Abstract:
SessionID: 23345
Revenge: The SQL! - Director's Cut
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: T-SQL/SQL 2014 Track
Speaker: Rob Volk
Title: Revenge: The SQL! - Director's Cut
Abstract:
Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?
Hint: You attend Revenge: The SQL!
This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!
Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
SessionID: 23395
First Day DBA - Installation to Fascination withou
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Beginner
Speaker: Rodney Landrum
Title: First Day DBA - Installation to Fascination withou
Abstract:
In this session we will step through the very basics of SQL Server for the new DBA. Since we can not delve into the SQL Server without a SQL Server, we will install one from scratch. Next we will add a database, write a couple of simple queries and export and import some data. All of this will be in preparation for our final look at running a report using data that we just loaded. At the end you will be familiar with many of the tools and techniques that DBAs use every day.
SessionID: 23443
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Prof Dev/Security
Speaker: Ronald Dameron
Abstract:
Attendees will learn how to define a permission set with a single script that allows your company’s DBAs to do routine work and how to elevate DBA permissions quickly to respond to production emergencies.
DBAs will leave this session with an easy to implement, low hassle solution that provides DBAs the minimum necessary access required to maintain the server but not be able to view user data.
In addition, I’ll talk about our DBA’s real world experience with reduced permissions
SessionID: 23480
Hadoop + SQL Server: The Emerging Patterns in Big Data
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI/Big Data/Misc
Speaker: Rowland Gosling
Title: Hadoop + SQL Server: The Emerging Patterns in Big Data
Abstract:
Ever wonder how to take Big Data technology such as Hadoop and use it to extend SQL Server? Archives, Data Lakes, ETL solutions. I'll show you how to create solutions with little or no MapReduce code! These will center around Linux-based Cloudera Enterprise, Impala, Hive, Pig, and Sqoop coupled with SQL Server 2014.
SessionID: 24808
Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI Track
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: 26964
Object Level Recovery Made Easy
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI/Big Data/Misc
Speaker: Todd Phillippe
Title: Object Level Recovery Made Easy
Abstract:
SessionID: 27156
How to Partition Anything!
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin 2 Track
Speaker: Elijah Baker
Title: How to Partition Anything!
Abstract:
SessionID: 9590
From Student to IT Professional - Part 1
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Beginner
Speaker: Andy Warren
Title: From Student to IT Professional - Part 1
Abstract:
SessionID: 9592
From Student to IT Professional - Part 3
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Beginner
Speaker: Andy Warren
Title: From Student to IT Professional - Part 3
Abstract:
In the final hour of our half day seminar for students we'll discuss the SQL Server Community including key web sites, events, and the idea of SQLFamily, followed by tips on how to build your professional network, and wrapping up with a presentation on how to use IT staffing companies effectively.
SessionID: 9593
Turbocharge Your Career With a Learning Plan
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Prof Dev/Security
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: 9790
Rolling Upgrades, The Easy Way!
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Bonus Track
Speaker: Argenis Fernandez
Title: Rolling Upgrades, The Easy Way!
Abstract:
In this session we will discuss how to perform upgrades while maintaining high availability of your SQL server infrastructure by leveraging rolling upgrades. We will review how to use database mirroring or AlwaysOn Availability Groups for this, along with a simpler version using Log Shipping. This is a demo-intensive session that you won't want to miss.
SessionID: 9791
Making DBCC CHECKDB Go Faster
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Performance Track
Speaker: Argenis Fernandez
Title: Making DBCC CHECKDB Go Faster
Abstract:
SessionID: 9882
Access As A Front-end to SQL-Server
Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI/Big Data/Misc
Speaker: Arvin Meyer
Title: Access As A Front-end to SQL-Server
Abstract:
Microsoft Access makes an unparalleled front-end for any version of SQL-Server. This session will explain the how and why.