Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 37
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Development

Level: Beginner

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Thunderdome

Level: Intermedia

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA, Automation

Level: Beginner

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
DBA, Security

Level: Beginner

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
DBA, Automation

Level: Intermedia

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
DBA, Automation

Level: Beginner

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
DBA, Cloud

Level: Beginner

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
DBA, Security

Level: Advanced

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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. 
Speaker:

Session Type:
Regular Session

Track:
Thunderdome

Level: Intermedia

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Thunderdome

Level: Beginner

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
DBA, Cloud

Level: Beginner

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA, Cloud

Level: Intermedia

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Development

Level: Intermedia

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Thunderdome

Level: Intermedia

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
DBA, Cloud

Level: Advanced

Session Code:

Date: January 31

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 37
Back to Top cage-aids
cage-aids
cage-aids
cage-aids