Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type


Sessions Found: 73
Many database developers sooner or later need to consume from or feed data to an accounting application such as the 
General Ledger.  Not being trained as bookkeepers, we may find bookkeeping conventions confusing at best and mystical at 
worst.  When is a credit negative, and a debit positive ?  The subject also has a reputation for being dull.  

But not really understanding the concepts and semantics seriously impedes unit testing, effective communication with the business, and  excessive dependence on business analysts as intermediaries.  We can do better !  This session will focus on demystifying the concepts and terms, facilitating further study if you are so inclined, and enabling you to understand the requirements and be proactive in testing.  

The session will conclude with a brief demo showing how SQL Server's Analysis Services directly supports some bookkeeping concepts.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (70 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: May 30

Time: 10:35 AM - 11:45 AM

Room: Brooks Atkinson (5-16)

This session will go well beyond creating SSAS cubes with the cube wizard.  I'll cover topics such as the pros and cons of ROLAP,  XMLA Processing options, Many to Many Bridge Tables and the use of the DefaultMember and IsAggregatable properties, SSAS Report Actions, Dynamic SSAS Roles with custom MDX code,  Advanced MDX in SSRS, Partitioning and Aggregations,  Data Driven KPIs, and Dimension Attribute Discretization.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
BI / SSAS / DW

Level: Advanced

Session Code:

Date: May 30

Time: 1:05 PM - 2:15 PM

Room: Central Park East (6-80)

As an ETL developer using SQL Server Integration Services have you ever wondered how to:
1.	Import all .csv files from a folder
2.	Replace dynamic SQL using variables in SSIS
3.	How to configure the data flow buffer
4.	Create custom logging solutions
5.	Use a script component as a data flow transformation
This session focuses on advanced techniques that are used in SSIS and is meant for the experienced SSIS developer.  We will focus on tasks and techniques that are native to SSIS 2005-2014 as well as some of the more advanced and vague  properties.  
Attendees must have a good working knowledge of SSIS as well as familiarity with VB.NET or C# as some time will be taken looking at extending SSIS with script tasks and components.
Upon completion of this workshop attendees will be able to:
1.	Import/export multiple sources/destinations
2.	Use an execute SQL task with variables to replace dynamic SQL within a package
3.	Dynamically handle errors within any part of a package
4.	
Speaker:

Accompanying Materials:

Session Type:
Regular Session (70 minutes)

Track:
Other

Level: Advanced

Session Code:

Date: May 30

Time: 3:45 PM - 4:55 PM

Room: Music Box (5-46)

Being able to accomodate the most demanding requirements on security is more important now than ever. This session will take you through a variety of approaches on how to implement basic to complex security on dimensions in SSAS. A quick intro through the GUI will bring us to AMO through PowerShell as the weapon of choice. Different concepts on hierarchy security models will also be demonstrated.
Speaker:

Session Type:
Regular Session (70 minutes)

Track:
BI / SSAS / DW

Level: Advanced

Session Code:

Date: May 30

Time: 9:15 AM - 10:25 AM

Room: Brooks Atkinson (5-16)

Most data warehouses are scheduled to update periodically, such as once nightly.  Others need to be refreshed in real-time, providing business users with up to the minute reports and analytics.  This session will review the architecture required to construct a dimensional data warehouse, source it with real-time ETL using Change Data Capture (CDC), and query it efficiently from various reporting tools.  It will cover advanced topics such as managing concurrent reads/writes using RCSI, storing real-time aggregates using indexed views, avoiding deadlocks using application locking, and other real-world construction/tuning/maintenance issues inherent in a real-time system.
Speaker:

Session Type:
Regular Session (70 minutes)

Track:
BI / SSAS / DW

Level: Advanced

Session Code:

Date: May 30

Time: 1:05 PM - 2:15 PM

Room: Music Box (5-46)

Do you have questions about your SQL Server installation? Want to know what a PAGEIOLATCH_EX means? Come along and ask your questions. This is a Q&A session, we're not going to solve your SQL dumps, but the limit to the questions is the time we have and the areas we cover.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lunch (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: May 30

Time: 12:15 PM - 1:15 PM

Room: Central Park East (6-80)

In this demo-heavy session we will take a look at the SQL Server auditing capabilities of Azure-based resources and on-premises resources.  We will discuss and demonstrate the basics of SQL Azure Database Audit,  how configure it, and how to review and analyze the audit findings generated from SQL Azure Database Audit.  We will also discuss and demonstrate  the basics of using the SQL Server 2014 Audit feature on-premises and for  SQL Server IaaS resources in Azure.   We will also discuss best-practices and real-world considerations for both the SQL Azure Database Audit and the SQL Server Audit Feature.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: May 30

Time: 10:35 AM - 11:45 AM

Room: Marquis (5-18)

In many data warehouses we model fact tables with measures based on attributes which we can count and do arithmetic upon. It is more difficult to handle fact tables with measures based on length of intervals of events happening in the source systems. So questions like "What are the typical waiting times in our order process?" are seldomly modelled in the data warehouse. Especially if the event data comes from different source systems. 

In this talk I will show you how Rehfeld has overcome this difficult problem using an autogenerated datawarehouse based on metadata on the objects in the EDW/DM layers. In this approach you can autogenerate the process data warehouse if only you have the timestamps present in the EDW layer and are able to correlate them. The talk will consist of slides and demos.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
Other

Level: Advanced

Session Code:

Date: May 30

Time: 12:15 PM - 1:25 PM

Room: Radio City (6-48)

Tired of watching progress bars and waiting for servers to reboot while you follow run books on how to install SQL Server. This session teaches you how to automate the whole process of installing a Windows Server (Core Installation), Install SQL Server, setup Clustering and configure an AlwaysOn availability groups.

The whole process is presented as a live demo
Speaker:

Session Type:
Regular Session (70 minutes)

Track:
CI / DevOps / Automation

Level: Intermedia

Session Code:

Date: May 30

Time: 3:45 PM - 4:55 PM

Room: Marquis (5-18)

Deploying your database changes to production can be nerve-wracking. We'll discuss methods that take the stress out of the process by ensuring that you practice your deployments using continuous integration before you ever get near production. Automating the deployment and testing processes through various pre-production environments can make the whole experience of production deployments more repeatable, more reliable and more robust.

In this session, we'll explore the concepts of continuous integration and continuous delivery for databases – what to consider, the challenges, the benefits, the testing, and the crucial approval gates necessary for a reliable production deployment. We'll discuss these and other release strategies as you think about how to evolve your deployment pipeline towards a more automated approach, starting with continuous integration and ending at your production systems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
CI / DevOps / Automation

Level: Intermedia

Session Code:

Date: May 30

Time: 9:15 AM - 10:25 AM

Room: Central Park West (6-200)

By now you’ve probably heard about Big Data 1.000 times or more so why a new session about big data you might ask.
Show how to make creation and deletion of AZURE elements automatically as part of your ETL process or by Powershell, automate the trivial procedures and work on the interesting parts
 This session will show you how :
• Downloads and prepares several years of demo data and storing it in a dedicated Azure Blob Storage account.
• Create a storage account and container for the HDInsight Cluster.
• Create a SQL database server instance and a SQL database for the Hive Metastore. We will also setup the necessary firewall rules so that you can access the server directly.
• The HDInsight cluster is provisioned and configured for access to the sample data.
• A partitioned Hive table is created over top of the sample data 
• Exploration of the result
• And how to automate these task either in Powershell or SSIS.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (70 minutes)

Track:
NoSQL / Big Data

Level: Intermedia

Session Code:

Date: May 30

Time: 3:45 PM - 4:55 PM

Room: Majestic (5-18)

You just found out that a client needs a SQL database to be designed from scratch. However, your existing DBA has given two weeks notice.

This presentation is meant for the Accidental DBA that has little to no experience with creating a database from the group up. 

Topics are focused on data storage structures, security, and integrity. After this presentation, you will be ready to meet that clients need.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
SQL Developer

Level: Beginner

Session Code:

Date: May 30

Time: 2:25 PM - 3:35 PM

Room: Central Park West (6-200)

Perfmon is a standard windows monitoring tool available on every windows deployment. It can provide a wealth of information about the activities within your system. We will cover the basics in this session which include how to setup/schedule perfmon to capture data as well as some basics around initial analysis. This session will have a strong component of demos.
Speaker:

Session Type:
Regular Session (70 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: May 30

Time: 9:15 AM - 10:25 AM

Room: Marquis (5-18)

On this session we are going to cover, how to create ETL frameworks by using existing metadata to generate SSIS packages at run-time using C# code. Expand the potential of Integration Services, create your own custom components, and enforce standards across your organization. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
Other

Level: Advanced

Session Code:

Date: May 30

Time: 9:15 AM - 10:25 AM

Room: Winter Garden (5-46)

One of the biggest challenges in any large SQL environment is maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. Additionally by default, SQL Server does not install with the best practices for every environment. You will learn best practices for system settings, file system layout and scheduling maintenance tasks. You will learn about what the best practices are for most SQL Server configurations, and how to automate your SQL Server builds in both a physical and virtual world. You will learn about the tradeoffs and benefits to completely automating the build process. You were hear about lessons learned building a private cloud at a Fortune 100 telecommunications company. You will also learn how use these same methods to ensure consistency with your servers whether they are in the cloud, or on-premises.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
CI / DevOps / Automation

Level: Beginner

Session Code:

Date: May 30

Time: 2:25 PM - 3:35 PM

Room: Imperial (5-18)

With the rapid advance in analytic features and the increased capabilities to produce more informative reports, SQL Server 2014 opens a plethora of new and exciting opportunities.
In the hands-on presentation we shall be constructing a few simple analytic reports (from background financial data). More importantly we shall see how our conclusions help us target new prospective business opportunities.
Speaker:

Session Type:
Regular Session (70 minutes)

Track:
BI / SSAS / DW

Level: Intermedia

Session Code:

Date: May 30

Time: 1:05 PM - 2:15 PM

Room: Brooks Atkinson (5-16)

If you've ever found yourself stating the above, this session is for you.  For many developers, writing T-SQL that works is not the challenge.  But too  often, functional T-SQL is not the same as good T-SQL.  In this session, we  will examine why "SQL that works" is not good enough.  Understanding  indexes, exectuion plans, sargability, and more are all critical to writing  good T-SQL.  We will also examine several real-world examples of T-SQL that  "worked great in dev" but caused major issues when it hit production. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
SQL Developer

Level: Beginner

Session Code:

Date: May 30

Time: 1:05 PM - 2:15 PM

Room: Central Park West (6-200)

There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
SQL Developer

Level: Beginner

Session Code:

Date: May 30

Time: 1:05 PM - 2:15 PM

Room: Radio City (6-48)

SQL Server 2005 made much of information necessary for performance available through easily accessible DMVs. Ad-hoc performance tuning is possible simply with direct queries to the DMVs. Many database today actually show signs of having too many indexes. A degree of index consolidation is possible by visual examination. A more ambitious objective is to build a set of good  indexes with no more indexes than necessary. To do this, it is necessary to catalog the index usage of hundreds if not thousands of SQL statements. Impossible or impractical? This can be done by automating execution plan analysis using ExecStats (free on QDPMA.com)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
Other

Level: Advanced

Session Code:

Date: May 30

Time: 2:25 PM - 3:35 PM

Room: Marquis (5-18)

In this session we are going to focus on the interaction between SSDT and Team Foundation Server. Developing locally and publishing the changes to an on-premises instance of SQL Server. We will look at how we can do continuous integration between development and other environments pushing the schema changes and upgrading the version numbers in a seamless manner upon successful build of the solution.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (70 minutes)

Track:
CI / DevOps / Automation

Level: Intermedia

Session Code:

Date: May 30

Time: 9:15 AM - 10:25 AM

Room: Carnegie (6-18)

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