Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 36
The optimizer uses statistics to generate a cardinality estimate which, in turn, affects query plan decisions as well as system resources. In this session we're going to step through the process of evaluating the statistics present (or not present) and present a methodology for analyzing the presence of skew, candidate filtered statistics, and their efficacy in an environment. Additionally, we'll look at the impacts of the new Cardinality Estimator in SQL Server 2014 on plan generation This would, ultimately, be an excellent addition to any periodic SQL Server health check.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Often times, an Oracle DBA is given the new responsibility of administering SQL Server Instances.   Or, conversely a SQL Server DBA has been given Oracle database instances to manage.   This session provides a general survival guide to assist with the DBA’s journey to the “other-side”.    An overview will be presented on the differences & similarities between Oracle and SQL server in the areas of:  terminology, object structures, memory, storage architecture, back & recovery, basic administration, data transfers, security and performance analysis.   We’ll discuss steps & strategies to help guide you in learning this new database skill set, and also look at common performance analysis tools which can be used across both Oracle and SQL Server databases.   Whether a DBA, developer or manager, this overview will help gain a basic understanding of the key similarities and differences between SQL Server & Oracle.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Presenting BI in a sophisticated look that is both user friendly and easy to use can be challenging. In this session I will review the three major types of dashboards (Operational, Strategic, and Analytical).  Using Visio, SSRS, SharePoint and Pyramid Analytics I will demonstrate examples of each of the dashboard types.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Covering the basics for the beginner and those that have been thrown into a modeling role and have been cowboy’n it like the Wild West.  We’ll cover why you should bother with a conceptual model and invest some of your project time in the modeling task.  We will  go over some different modeling techniques around Normalized, Dimensional and Data Vault options.   And lastly, considerations for scalability, sustainability and empowering you with a Data Access Layer so you stay in control of your architecture as opposed to the application beast.  Yee-Haw!

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL 2012 best practices for data transformation
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

This will be an action-packed culmination of entertainment, story telling, jokes, and data wizardry using the next generation of Power BI! 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

All data warehouses need a date and time dimension to enable proper analysis across time. Most Data Warehouse designers will just use one provided by tools or whip it up in Excel, but what if you need to set up custom holidays or want different calendars, such as Fiscal or Julian? You can have any date and time dimension you need by using a single SQL script that can be modified and rerun as necessary. Learn what it takes to design a date and time dimension that does all of the calculations and formatting up-front so the reports can be easier to create. Sample script will be provided that creates the date and time dimensions and can be reused as often as necessary without breaking your data warehouse and it only take seconds to run!
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, you’ll learn about SQL Server stored procedures (SPs): what they are, when and why you'd use them, and how you'd go about developing a solution with one.  We will address common SP myths and learn about planning for performance. Most of all, we’ll walk through examples to explore the process of solution building in SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

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:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

We will discuss some of the most important things that you as a Data Professional can document to make your job much easier, ensure information consistency between groups, and better prepare your organizations for raising the bar on your day to day business.  Think of this as a sort of Database Library that allows you to finally detail the processes you follow currently to perform repetitive tasks.  This Library will also allow you to simply document your systems for your and others knowledge.  
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

We all appreciate a well-defined and well-tuned stored procedure. But sometimes the problem calls for a more dynamic solution. What are those problems and how do you generate SQL to solve them? After attending this session, you will be able to identify situations that call for dynamic SQL and address them with rapid, maintainable, and secure code.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Follow along as we adventure through the vastness that is Availability Groups in SQL Server.  In this beginners guys we show you how to make an Availability Group from scratch, the new system tables that go along with Availability Groups, and how to troubleshoot your Availability Group using the system tables and SSMS.
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Technology has revolutionized the way organizations run today. Rather than a few file cabinets, organizations use many different software packages and applications that are mission critical to running their business. These systems gather a large amount of valuable data that must be used in decision making to maintain a competitive advantage. However, we've all heard and likely been around when mission critical systems have been rendered useless due to long running reports. To solve this and a host of other source system reporting issues we have proven Data Warehousing techniques to store the data in a report friendly way. Dimensional modeling is one of the most widely used set of techniques that will provide source system relief for reporting. In this session, we will take a look at what Dimensional Modeling is along with some key terms and techniques.
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Do your backups take too long? Do you know how to determine how long they are taking?  Would you like database backups to run faster without having to ask for faster hardware?  Then come learn some tips and tricks to make your SQL database backups run faster.  In this session, we’ll look at several tangible things that you can take back to your environment and make an immediate measurable difference.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

The volume of data addressed by the typical ETL operation is constantly on the rise.  Not so many years ago, a table with a few million records was considered to be huge.  These days, it's not uncommon to deal with multibillion row tables.  As a result, ETL professionals are frequently tasked with finding efficient ways to incrementally process these large sets of data without resorting to expensive and time-consuming destructive reloads.
 
In this session, we will review the common decision points surrounding incrementally loading data, and will demonstrate some of the methods for incremental processing.  Among the topics of discussion:
--Deciding whether an incremental load is appropriate
--Pick your tool: T-SQL or SSIS?
--Methods for detecting new and changed records
--Common incremental load design patterns
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation will compare and contrast set operations with Except, Intersect, and Unions compared with performance of accomplishing the same tasks with inner, outer, and full join queries.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you wondered which high availability features might be best for your shop? In this session we will go over a quick look at log shipping, database mirroring, transactional replication, failover cluster instances and availability groups. John will identify pros and cons for each features and share some tips from the field.
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

We've all installed SQL Server and, most of the times, the default settings work just fine.  This is a beginner session that will help you to understand what those settings mean along with why there might be times that you want to use something other than the defaults and how that might impact your server.  We'll also go through unattended installs, both with and without a config file.  This can really help to standardize your SQL Server installations and save you some precious keystrokes.
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Communicating. We all do it, every day. But can you do it better? You present to management, share with peers, advise your direct reports. A common thread of success or failure here is how well you get your message across. 
Can you share bad news and soften the blow with humor while respecting the nature of the news you have to deliver?
Can you support your direct reports when they make a very human mistake?
Do you know how you communicate your support without micromanaging them can make a huge difference in the quality of their work for years to come? 
These questions and more will be answered, with stories, with humor, and with experience (both good and bad).
Once you've figured these things out, how do you communicate your own skills to the world? 
After attending, you’ll be on the road to better, more direct communication, whether it’s with your management, your peers, or your reports.
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

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