Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 62
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:
DBA \ BI \ Cloud

Level: Intermedia

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2012. The query makes no difference, this time it's all about the output. 
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

A typical enterprise database environment comprise of hundreds of database server hosts. Each host has at least the following database administrator's tasks:

	User database full backup
	System database full backup
	Transaction Log backup
	Check database integrity
	Index defragmentation and update statistics
	Backup cleanup per retention policy
	Backup history and agent history cleanup

	Quick N Easy recovery strategy

SQL Server native environment, the maintenance plan, is not comprehensive enough to cover all scenarios and is not friendly enough to debug. While CMS environment is great, it is not possible to automate via User Graphical Interface.
I use CMS, T-SQL and Powershell custom solution to construct a worry-free, stable, easy-deploy DBA task plan and automated monitoring alert notifications including backup failure, backup reports and sql agent job failure.
These maybe the processes that future SQL Server version could incorporate as a standard.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Advanced

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

The session explains Attributes and Hierarchies in Analysis Services 2012 Semantic Model. They are used to slice (filter) and dice (group) measures and dimensions used to view analytical data.  The slicing and dicing of data involves fields, columns, or whatever you want to labeled them. But, in SQL Server Semantic model these are called Attributes and Hierarchies. The configuration of these slicers and dicers are important in SQL Server Analysis Services. This session will demonstrate the difference between an attribute and columns in a hierarchy in the dimension as well as the configuration of these for best performance and viewing.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

If your company is planning to build a data warehouse or BI solution, you need to be aware that BI projects have high failure rates. Gartner says between 70% to 80% of corporate business intelligence projects fail. And with “big data” adding more complexity you can expect even more failures. However, the major causes of these failures are well known and can be avoided by implementing a set of best practices.

I have worked on dozens of end-to-end BI projects and have seen my share of successes and failures. I will talk about the reasons BI projects fail and share best practices and lessons learned so your BI project will fall into the “successful” category.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Lots of people know that Full Text Search is a powerful tool for searching unstructured data but did you know that you can utilize its power for structured data as well?  Functions like FREETEXTTABLE and CONTAINSTABLE open up some pretty groovy doors in terms of usability.  We’ll discuss ways to give your users that search engine like interface that everyone has grown accustomed to without sacrificing query performance.  We’ll also hit on creating synonyms to give your users results even when they aren’t quite sure what to search for.  It’s an entirely different type of search altogether.  
Speaker:

Session Type:
Regular Session

Track:
AppDev

Level: Intermedia

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Master, model, msdb, tempdb. You see them on all of your servers, but what do you really know about them? If you ever wanted to learn about the SQL Server system databases, their purpose, and the maintenance and configuration required to keep your server running its best, then this session is for you! Learn best practices and techniques, including how to restore master and how to configure tempdb to reduce contention. You'll leave with a better understanding of these shared resources and how they affect your database applications.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA \ BI \ Cloud

Level: Beginner

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Change Tracking came out with SQL Server 2008, but SS2012 almost eclipsed it with Change Data Capture.  Change Tracking is now the red-headed step child, but in many cases may be a better solution for data ETL movement from an OLTP database to a data warehouse database.  This session will provide a review of change tracking syntax and implementation with detailed demos.  It will then dive into an actual ETL subset implementation from the AdventureWorks database to a data warehouse solution (modified AdventureWorksDW) with detailed code discussion and demos.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn about Cisco Unified Computing System (UCS) and how it provides an optimal platform for Microsoft SQL Server.  During this session we will discuss key differentiators that place Cisco well ahead of the competition.  Learn about UCS’ management model, Service Profiles, Service Profile Templates, Virtual Interface Adapters, and how they all can help to simplify and standardize SQL Server deployments.  We will also discuss how these differentiators drastically reduce deployment and recovery times, and how UCS provides the best of class hardware platform that can help to achieve the highest levels of consolidation and performance for both virtual and bare metal SQL Server implementations.  Bring your business card to enter a raffle for a Bose® - SoundLink® Mini Bluetooth Speaker.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

The deployment process is frustrating; an object is missing, an object is 
deployed in the wrong order or the incorrect version. Each database is 
made up of a lot of objects in different environments. When you create an 
object like a table or stored procedure, you need to get this object deployed 
into each environment. Together we will discover how to separate each 
object for proper order deployment while releasing only objects which have 
changed. Deployments can cause you trouble but we will provide a reliable 
deployment and version control process.
Speaker:

Session Type:
Regular Session

Track:
AppDev

Level: Intermedia

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

OLTP versus DW ETL Strategies (Availability Groups/Mirroring, Change Data Capture, SSIS, FlatFiles). SSIS Synchronous & Asynchronous transforms. Demo SSIS performance. ETL versus ELT.  Demo FileTable.  
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * NULL/NOTNULL  * Surrogate Keys vs. Natural Keys * Varchar Minimums *the CLOUD * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
AppDev

Level: Intermedia

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Let’s talk about your career. You’ve been a DBA for a week, a month, a year, or ten, but do you know all you need to about keeping up to date? Job hunting and recruiters? Are you an interview ace? We’ll talk about all of this, and much more. To answer your specific questions, we’ll wrap up with a question and answer session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Prof Dev \ Cloud

Level: Beginner

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Stop relying on vendors to provide you with performance data.  Between Windows and SQL Server you’ve already got all you need to collect and report on server performance.  And it’s far more flexible than you’ll ever get from a vendor.  This is often called a poor man’s method, but it’s so much more than that.  I’m going to show you what your options are for collecting performance data for free and you’ll even walk away with a framework you can plug into your own environment and start using tomorrow with very little effort.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you confident that your application performs as expected on Leap Day?  Do you know how long it would take to run out of identity values in your major tables?  Can you support case-sensitive collations and non-standard sort orders?  If not, odds are good that you are not edge and corner testing your application.  In this session, learn how to define the edges of your application and start to stretch those boundaries by setting up challenging test and development environments.  For database administrators, learn what configurations in your environment may be a source of bugs in application code and what you can do about it.  Learn about edge cases that you can start hardening your code against on Monday morning!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
AppDev

Level: Beginner

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

In three years I went from a complete unknown to a popular blogger, speaker at PASS Summit, and a SQL Server MVP.  Along the way I saw my yearly income triple.  Is it because I know some secret?  Is it because I am a genius?  No!  It is just about laying out your career path, setting goals, and doing the work.  It's about building your personal brand and stepping out of your comfort zone.  It's about overcoming your fear of taking risks.  If you can do those things, you will be rewarded.  I will discuss how you too can go from unknown to well-known.  I will talk about building your community presence by blogging, presenting, writing articles and books, twitter, LinkedIn, certifications, interviewing, networking, and consulting and contracting.  Your first step to enhancing your career will be to attend this session!
Speaker:

Session Type:
Regular Session

Track:
Prof Dev \ Cloud

Level: Beginner

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window? 


Speaker:

Session Type:
Regular Session

Track:
DBA \ BI \ Cloud

Level: Beginner

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

We all know and love inner join, outer join, in and exists. But, there are a several other TSQL operators that do not get as much press as the rest. Expand your TSQL tool belt with Intersect, Except, Cross Apply, and Outer Apply. You'll get practical examples that you can use on Monday morning!
Speaker:

Session Type:
Regular Session

Track:
AppDev

Level: Beginner

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

We expand on a little known but widely modified feature of SQL Server. Fill Factor is something to address in performance tuning after all the low hanging fruit has been addressed. This is not a deep dive into the underlying mechanics of how SQL Server works, but a softer more useful approach to this subject. We will be looking into why changing this could be either good or bad for your environments. This presentation is useful for DBA’s as well as developers trying to get a little more out of their servers.
Speaker:

Session Type:
Regular Session

Track:
AppDev

Level: Intermedia

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

SAN’s and NAS’s have their own challenges but also open up a whole new set of tools for disaster recovery and high availability. We will touch on the basics that can be applied to most SAN’s and talk about strategies for setting up your storage. We will also cover what makes up a Storage Area Network and what seperates Network Attached Storage from SAN's and how iSCSI fits into this picture.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: May 10

Time: 12:00 AM - 1:00 AM

Room: TBD

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