sqlsathistory

Nr: 362

Back to Main list

SQLSaturday #362 - Austin 2015

Start Time (24h)	Speaker	Track	Title
00:00:00	Jason Brimhall	DBA, Cloud	SQL 2012 Extended Events
00:00:00	Conor Cunningham	Thunderdome	Query Store - A New SQL Query Tuning Feature
00:00:00	Daniel Janik	DBA, Automation	SQL Server: Monitoring disk usage
00:00:00	David Stein	Business Intelligence	Writing Your First BimlScript
00:00:00	Gene Webb	Business Intelligence	Learn How To Build A Golden Record for Any Subject Over Lunch!
00:00:00	Hakim Ali	Development	T-SQL Throwdown
00:00:00	Janis Griffin	DBA, Cloud	Introduction to Wait Types and Response Time Analysis
00:00:00	Jason Carter	Development	5 TSQL Commands I've Been Missing
00:00:00	Jennifer McCown	Thunderdome	Introduction to Powershell cmdlets for DBAs
00:00:00	Kal Yella	DBA, Cloud	No DR Site?! No problem!! Enhance your SQL Server HA/DR capabilities using Windows Azure
00:00:00	Kevin Wilkie	Development	The Real Value of Name-Value Pairs: Using PIVOT and UNPIVOT
00:00:00	Konstantin Melamud	Development	Turbo Boost Performance: In Memory Tables index optimizations
00:00:00	Lori Edwards	DBA, Cloud	SQL Server Statistics – What Are The Chances?
00:00:00	Michael Bourgon	DBA, Security	SQL Watchdog - find out instantly when SQL change
00:00:00	Mike Byrd	DBA, Cloud	SQL Server Foreign Keys – De-mystifying the Rest of the Story
00:00:00	Mindy Curnutt	DBA, Automation	SQL Server Bingo – Install, Migration Config
00:00:00	Nancy Hidy Wilson	DBA, Security	CIS Benchmarks – A Guide to SQL Server Security
00:00:00	Reeves Smith	Thunderdome	Increase your SSIS productivity with Biml
00:00:00	Reinaldo Kibel	Thunderdome	SQL Server 2014 In Memory technologies - In Memory OLTP (aka Hekaton) ColumnStore
00:00:00	Ryan Adams	Thunderdome	AlwaysOn Live Deployment
00:00:00	Ryan Adams	DBA, Security	How Active Directory affects SQL Server
00:00:00	Shawn Weisfeld	DBA, Security	SQL Server Data Tools
00:00:00	Lance Tidwell	Development	Parameter Sniffing the Good and the Bad
00:00:00	Richard Heim	Business Intelligence	XML SQL: Best Frenemies Forever
00:00:00	Steve Wake	Business Intelligence	Capture Change and Apply it with CDC SSIS
00:00:00	Kevin Boles	DBA, Security	SQL Injection
00:00:00	Thomas LeBlanc	Business Intelligence	Getting started with Tabular Analysis Services
00:00:00	Tim Mitchell	Business Intelligence	15 Quick Tips for SSIS Performance
00:00:00	Tim Costello	Development	Windowing Functions
00:00:00	TJay Belt	DBA, Automation	Database Release Management: Tips to help organize it
00:00:00	Wayne Sheffield	Thunderdome	Table Vars Temp Tables - What you NEED to Know!
00:00:00	Naomi Williams	DBA, Automation	SQL Server Internals
00:00:00	Kevin Hazzard	Business Intelligence	Change Data Capture Change Tracking Deep Dive
00:00:00	Anil Mahadev	DBA, Cloud	Getting Started with SQL Server in the Cloud with Microsoft Azure
00:00:00	AJ Mendo	DBA, Automation	DBA Toolbox: Surviving A Disaster
00:00:00	Amy Herold	DBA, Automation	Beginning Automation with Powershell
00:00:00	Andy Warren	DBA, Security	Turbocharge Your Career With a Learning Plan

SessionID: 10885

SQL 2012 Extended Events

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Cloud

Speaker: Jason Brimhall

Title: SQL 2012 Extended Events

Abstract:

Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun.

SessionID: 11786

Query Store - A New SQL Query Tuning Feature

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Thunderdome

Speaker: Conor Cunningham

Title: Query Store - A New SQL Query Tuning Feature

Abstract:

Have you ever come in to work only to have the boss come tell you that your main site is down and the database is "broken"? Fixing query performance problems can be rough, especially in high-pressure situations. Microsoft has developed a feature to help customers gain significantly easier insight into production systems and to be able to quickly fix cases where a new plan choice from the query optimizer has undesired performance consequences. This talk introduces the Query Store, explains the architecture, and shows how it can be used to solve real-world performance problems. It will now be possible to ask questions like "show me what query plans have changed since yesterday" and to quickly ask the optimizer to "go back" to the query plan that was working fine for you previously.

SessionID: 12174

SQL Server: Monitoring disk usage

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Automation

Speaker: Daniel Janik

Title: SQL Server: Monitoring disk usage

Abstract:

This technical session covers everything you ever wanted to know about troubleshooting the storage in SQL Server. Have you ever observed high latency, only to be told "It's not the disks" by the storage admin? This empowering session will give you the knowledge you need to dig down to the root cause! This session will cover DMVs, Performance Monitor, XPerf, and more!

SessionID: 12450

Writing Your First BimlScript

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: David Stein

Title: Writing Your First BimlScript

Abstract:

In this highly interactive presentation, I'll guide you through the process of creating your first BimlScript. During the process we'll cover the basics of Biml syntax, language options for generating BimlScript, recommended methods of storing and using metadata to drive your BimlScipts, and a lot more. As an added bonus, you'll leave the presentation with several BimlScripts you can adapt to use in your own environments.

SessionID: 14442

Learn How To Build A Golden Record for Any Subject Over Lunch!

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Business Intelligence

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: 14932

T-SQL Throwdown

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Development

Speaker: Hakim Ali

Title: T-SQL Throwdown

Abstract:

Join us for a game of SQL that combines fun, learning SQL, networking, and friendly competition with your peers. Create your team for a SQL-off against other teams. If you can write a SQL query, you have the skills required to play. Each team must bring a laptop with SQL Server 2005 Express or higher installed. Please read full rules here: http://www.sqlzen.com/t-sql-throwdown.html

SessionID: 15747

Introduction to Wait Types and Response Time Analysis

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Cloud

Speaker: Janis Griffin

Title: Introduction to Wait Types and Response Time Analysis

Abstract:

Using Response Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Response time performance analysis to solve the most difficult performance related issues.

SessionID: 15803

5 TSQL Commands I've Been Missing

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Development

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: 16501

Introduction to Powershell cmdlets for DBAs

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Thunderdome

Speaker: Jennifer McCown

Title: Introduction to Powershell cmdlets for DBAs

Abstract:

You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell. You’ll want to take notes, or better yet, bring your laptop and start using Powershell immediately. We will get Posh running and then I’ll introduce you to the basic concepts, with examples to make things happen right away. We’ll work on SQL Server with Powershell, and learn some cool techniques. Come see this all-demo, hands-on session!

SessionID: 17857

No DR Site?! No problem!! Enhance your SQL Server HA/DR capabilities using Windows Azure

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Cloud

Speaker: Kal Yella

Title: No DR Site?! No problem!! Enhance your SQL Server HA/DR capabilities using Windows Azure

Abstract:

You may already know that Windows Azure cloud service will help you build cost-efficient, scalable and flexible SQL Server solutions. But do you know you can also use it to enhance the High Availability and Disaster Recovery of your SQL Server solutions? In this session, we will show you how you can use the IaaS (Infrastructure as a Service) capabilities of Windows Azure to build highly scalable and available SQL Servers. We will then take it further to demonstrate how you can use AlwaysOn Availability Groups to improve availability and provide disaster recovery for your SQL Servers either on premise, in the cloud or both (Hybrid). We will also introduce you to the cloud enhancements in SQL Server 2014 that makes deploying databases to Windows Azure and implementing AlwaysON replicas in the cloud merely a child play. We will also look at how Windows Azure Blob Storage provides flexible, reliable off-site storage location for your SQL Server database backups.

SessionID: 18180

The Real Value of Name-Value Pairs: Using PIVOT and UNPIVOT

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Development

Speaker: Kevin Wilkie

Title: The Real Value of Name-Value Pairs: Using PIVOT and UNPIVOT

Abstract:

This session will show in-depth how to use both PIVOT and UNPIVOT. How to use the functionality will be described in detail along with how to use more advanced features like Dynamic PIVOT!

SessionID: 18583

Turbo Boost Performance: In Memory Tables index optimizations

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Development

Speaker: Konstantin Melamud

Title: Turbo Boost Performance: In Memory Tables index optimizations

Abstract:

With the introduction of in-memory based tables in SQL Server 2014, it’s natural to expect significant increases in query performance. But what do we do when queries which utilize in-memory tables actually start to perform same or, in some cases, even worse than their equivalent disk based table predecessors? In this session, we are going to take a look at the changes to the indexing design for in-memory based objects and how it differs from existing disk based table indexing. Also, we are going to cover how to choose the appropriate indexes for your in-memory object to give you the performance boost that you have been expecting.

SessionID: 19240

SQL Server Statistics – What Are The Chances?

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Cloud

Speaker: Lori Edwards

Title: SQL Server Statistics – What Are The Chances?

Abstract:

For far too long, I thought that statistics only contained information on table row counts. While they do contain that information, there is more to it than that. In this beginner session, we’ll go over statistics – how they are created, the different types of statistics that exist, how they’re maintained and how the Query Optimizer uses them. We will also touch on system tables and DMVs that will provide additional information on your statistics. At the end of this session, you should have a better idea of how the query optimizer within SQL Server makes decisions on how to gather data.

SessionID: 19932

SQL Watchdog - find out instantly when SQL change

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Security

Speaker: Michael Bourgon

Title: SQL Watchdog - find out instantly when SQL change

Abstract:

It happens - problems due to changes, be it ALTERed SPs, index rebuilds, or even configuration changes. But what if you could look historically and track down what changes were made when, by who, and from where? What if you could see in realtime when changes occur? It exists, it's in SQL Server (even standard edition) from 2005-2014, and it's easy to implement. Come learn what Event Notification is and why you'll want it in your environment. This is not theory, all code provided and in production on hundreds of servers in multiple environments.

SessionID: 19960

SQL Server Foreign Keys – De-mystifying the Rest of the Story

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Cloud

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: 20781

SQL Server Bingo – Install, Migration Config

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Automation

Speaker: Mindy Curnutt

Title: SQL Server Bingo – Install, Migration Config

Abstract:

Get ready to play SQL Buzzword Bingo with the subject matter being SQL Install, Migration Configuration. Are you preparing to move a database from one SQL Server to another? Whether it's your first SQL install, a SQL Server Upgrade or changing from physical to virtual, there is a lot to consider. In some areas of the setup, you get only one chance to "get it right." Come to this session and find out all about the process - and have some fun while you're at it. First one to hit BINGO! will win a cool prize.

SessionID: 21300

CIS Benchmarks – A Guide to SQL Server Security

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Security

Speaker: Nancy Hidy Wilson

Title: CIS Benchmarks – A Guide to SQL Server Security

Abstract:

Ever wonder where your auditors come up with the security settings they look for in your environment? One of their sources is the CIS (Center for Internet Security) Security Benchmarks. This session will introduce you to the current CIS SQL Server Security Benchmarks and the recommendations they contain. Then, I’ll show you an easy way to setup your own validation checks using SQL Server’s Policy Based Management feature. Lastly, you’ll learn how you can be part of the CIS Community input. So, bring your current security setting checklist to see if you’ve missed anything or to propose changes in future CIS Security Benchmarks.

SessionID: 22796

Increase your SSIS productivity with Biml

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Thunderdome

Speaker: Reeves Smith

Title: Increase your SSIS productivity with Biml

Abstract:

Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.

This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.

SessionID: 22872

SQL Server 2014 In Memory technologies - In Memory OLTP (aka Hekaton) ColumnStore

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Thunderdome

Speaker: Reinaldo Kibel

Title: SQL Server 2014 In Memory technologies - In Memory OLTP (aka Hekaton) ColumnStore

Abstract:

With the advent of new hardware servers with hundreds of Gigabytes of RAM memory and incredibly faster CPUs with multi-core dies Microsoft has catapulted SQL Server above competitors with some new In Memory technologies. Did you ever want to have no locking, no blocking, no latch? For highly transactional systems, In Memory OLTP can boost performance 10x by hosting a table in memory and compiling the stored procedure in C code/DLL. Did you ever wanted to have queries return blazing fast for slow changing data? Updatable ColumnStore index allows for quick results to be returned as massive compression on the column exist and data is kept in RAM.

Having participated in SQL14/Hekaton TAP, I'll be showing demo on both of these technologies, gotchas, best practices.

SessionID: 23754

AlwaysOn Live Deployment

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Thunderdome

Speaker: Ryan Adams

Title: AlwaysOn Live Deployment

Abstract:

This session is 90% live demonstrations. I'll walk you through a complete AlwaysOn deployment. You will see firsthand how to install and configure an AlwaysOn Failover Cluster. I'll also show you how to setup an AlwaysOn Availability Group across 5 nodes using both the GUI and T-SQL so you know why and when to use each method. I'll finish up by showing how you can connect to a readable secondary.

SessionID: 23755

How Active Directory affects SQL Server

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Security

Speaker: Ryan Adams

Title: How Active Directory affects SQL Server

Abstract:

If you have ever had a Kerberos or SSPI context error, then you won't want to miss this session. SQL Server has a large surface area and Active Directory can influence a big part of it. I will discuss AD DNS configuration, Group Policy Objects, Kerberos (of course), and how all of them affect your SQL Server. By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work.

SessionID: 24409

SQL Server Data Tools

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Security

Speaker: Shawn Weisfeld

Title: SQL Server Data Tools

Abstract:

Working with SQL schema is a chore for most developers. In this session we will take a look at the SQL Server Data Tools in Visual Studio and how we can leverage them to make your development life a bit easier.

SessionID: 24433

Parameter Sniffing the Good and the Bad

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Development

Speaker: Lance Tidwell

Title: Parameter Sniffing the Good and the Bad

Abstract:

Parameter sniffing is something that more than often helps performance on your servers; however, there are times when it can hinder performance as well. In this session we will define exactly what parameter sniffing is, and examine when it is good and when it is bad. Lastly, we will explore the different options available to fix bad parameter sniffing. After this session, you will be able to locate and fix bad parameter sniffing when it occurs on your servers.

SessionID: 24989

XML SQL: Best Frenemies Forever

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Richard Heim

Title: XML SQL: Best Frenemies Forever

Abstract:

A look at how XML data integrates with SQLServer via SSIS packages, XPath, TSQL and Bulk Inserts. What works, what sort of works, what you should never attempt even though SQLServer will let you try. This session will hit on several ways to get XML formatted data into and out of your SQL Server database. Basic knowledge of TSQL, SSIS XML is expected.

SessionID: 25713

Capture Change and Apply it with CDC SSIS

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Steve Wake

Title: Capture Change and Apply it with CDC SSIS

Abstract:

Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.

SessionID: 26450

SQL Injection

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Security

Speaker: Kevin Boles

Title: SQL Injection

Abstract:

Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!

SessionID: 26535

Getting started with Tabular Analysis Services

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Thomas LeBlanc

Title: Getting started with Tabular Analysis Services

Abstract:

This session will give the basics of starting a tabular model with Analysis Services 2014 and PowerView from Excel 2013. We will start by opening the Visual Studio environment to create a Solution/Project. The Fact and Dimension tables will be imported and Filtered. Basic attribute and hierarchies will be created along with some calculations on the fact data. The Deployed project will be previewed in PowerView from Excel 2013.

SessionID: 26642

15 Quick Tips for SSIS Performance

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Tim Mitchell

Title: 15 Quick Tips for SSIS Performance

Abstract:

When reviewing your ETL processes, the No. 1 question is always, "Does it work as expected?" Closely following that question is the ubiquitous, "How fast does it run?" This session’s tips are targeted at improve the latter.

In this session, we’ll focus on SSIS package performance, quickly reviewing 15 common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.

SessionID: 26813

Windowing Functions

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Development

Speaker: Tim Costello

Title: Windowing Functions

Abstract:

Window functions are one of the coolest new things in SQL Server 2012, but they can be tricky to figure out. In this session we'll talk about how windows functions work and why you should start using them. This is going to be a demo heavy session with code samples you can take back to work and start using Monday morning!

SessionID: 26921

Database Release Management: Tips to help organize it

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Automation

Speaker: TJay Belt

Title: Database Release Management: Tips to help organize it

Abstract:

The very nature of a database system is to be dynamic; rarely static. The applications that use databases tend to change, requiring changes to occur within our databases. The totality of pieces and parts that comprise this ‘change’ will be combined into a ‘Release’ that will be applied to your systems. Controlling this change is not rocket science, but it is not without its complexities. We will discuss various terms, define processes, share ideas, and suggest tools to assist you in performing this necessary function, while minimizing risk, and impacting your systems in a graceful fashion.

SessionID: 27747

Table Vars Temp Tables - What you NEED to Know!

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Thunderdome

Speaker: Wayne Sheffield

Title: Table Vars Temp Tables - What you NEED to Know!

Abstract:

Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"

SessionID: 28228

SQL Server Internals

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Automation

Speaker: Naomi Williams

Title: SQL Server Internals

Abstract:

How does SQL do what it does? Take a look under the hood at how the SQL database engine works with the storage engine. What causes those waits and where do we look to resolve them!

SessionID: 28241

Change Data Capture Change Tracking Deep Dive

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Kevin Hazzard

Title: Change Data Capture Change Tracking Deep Dive

Abstract:

Change Data Capture (CDC) and Change Tracking (CT) have been standard features in SQL Server for a few years now but there's not really that much useful information out in the blogosphere about how they work under the hood. Kevin Hazzard will dig deep into the implementations of CDC and CT in SQL Server, showing you all of the parameters you can use to make these great features serve your organization well. This will be a highly-interactive, highly-entertaining session with lots of questions answered and mysteries revealed.

SessionID: 34603

Getting Started with SQL Server in the Cloud with Microsoft Azure

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Cloud

Speaker: Anil Mahadev

Title: Getting Started with SQL Server in the Cloud with Microsoft Azure

Abstract:

This will be a hands on approach for anyone that wishes to learn about setting up their very first SQL Server instance and what needs to be kept in mind while connecting apps to the SQL Server in the Microsoft Azure Platform.

SessionID: 9124

DBA Toolbox: Surviving A Disaster

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Automation

Speaker: AJ Mendo

Title: DBA Toolbox: Surviving A Disaster

Abstract:

From human error to the SAN crashing disasters happen. Knowing what to do and having the skills needed to recover after a disaster is one of the most important skills a DBA must have. We will discuss Disaster Recovery Plans and why you need them. We discuss your role and what you must know. This is a demo heavy session and all scripts will be provided so you can practice your skills and make you more confident and help you survive a disaster.

SessionID: 9425

Beginning Automation with Powershell

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, Automation

Speaker: Amy Herold

Title: Beginning Automation with Powershell

Abstract:

This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you wil learn how you can leverage Powershell to not only efficiently meet the needs of your busines, but also free up your time for other things.

SessionID: 9589

Turbocharge Your Career With a Learning Plan

Back to calendar

Event Date: 31-01-2015 - Session time: 00:00:00 - Track: DBA, 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!

This site is open source. Improve this page.