Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 43
In the most marketing departments, the tactical question is about who are going to buy our products.  It is more cost effective to identify and spend money on highly potential customers (than those who are not likely to purchase).  This also affects the advertisement strategy. Potential customers and their traits can be identified by analysing previous purchasing information. Management experts can predict who is going to be their new customers by analysing their current customer purchase information. There are many data mining algorithms which can help with this task.  Microsoft Business Intelligence employs data mining algorithms that are deployed in an easy to use environment.
This demonstration based session will show how to use previous customer purchase information to predict potential customers. We will discuss how to set data sets and use different data mining algorithms to get predictive results and then demonstrate how to find the best predictions.
Speaker:

Session Type:
Regular Session

Track:
5

Level: Beginner

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Reporting Services Report Manager provides a great web platform for managing and delivering many types of reports. We will review delivering reports with Report Manager and look at the options for integrating SSRS as the report presentation engine within web and windows applications. We will also explore creating a standalone application to navigate and display reports using the reporting services database.
 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
5

Level: Intermedia

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you working with an application supporting different time zones and international date formats? How does your choice of storing date / time values differ if you are using Windows Azure SQL Database instead of on-prem SQL Server database? Did you know that SQL Server Database Engine, Integration Services (SSIS) and Analysis Services (SSAS) all have slightly different date / time data types? How can you bullet proof your system for the ever growing data in your organization with much more date and time data to come?  
 
With time being the one thing that constantly changes, date and time calculations are widely used and essential to all business transactions. Yet, most systems only use one or two date data types; Is this a wise decision? Quite often data retrieval relating to a period of time does performs poorly, or worst of all, is not accurate. These 10 tips will help you bridge the gap, and provide the techniques to build bulletproof systems the users demand and DESERVE! 
Speaker:

Session Type:
Regular Session

Track:
6

Level: Beginner

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Some aspects of SQL Server installations are easily repeatable using things like config files and command line installs.    However, so much of the preparation and post-install configuration still needs to be done manually.

This session will show how Powershell can be used to prep the servers (including how easy it can be to deploy a cluster) and how Powershell can then be used to deploy and configure SQL Server according to your company standards.
Speaker:

Session Type:
Regular Session

Track:
2

Level: Intermedia

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

When loading a data warehouse you want the data inserted into the tables as fast as possible. You know you have to use bulk loading, but what do you need to do to ensure a minimal footprint on the transaction log? 

In this session, you will learn about minimal logged operations. You will also learn about the different methods for bulk loading data into your data warehouse; using SSIS, BCP and T-SQL.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
4

Level: Advanced

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn about formatting T-SQL for readability and why top down design is not the best solution for writing T-SQL. You’ll learn why implicit conversions slow queries down and how to leverage simple techniques for minimizing the performance impact of explicit conversions. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
9

Level: Beginner

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft Cluster MVP Dave Bermingham will discuss how to create #SANLess clusters in environments where traditional shared storage clusters are impractical or impossible. He will also be discussing high performance clusters leveraging SSD and Flash-based PCIe storage for faster SQL application response times - no SAN (or SAN Admin required) - and be touching on HA protection and native Windows Failover Clustering in cloud environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
2

Level: Beginner

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Columnstore indexes were introduced in SQL Server 2012 & have been wholly re-architected & optimized in SQL Server 2014.  Columnstore indexes are optimized for data warehouse workloads & are a hybrid technology leveraging the best of off-disk & in-memory capabilities. Transparent to the app, columnstore has been shown to render queries at subsecond response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites & inside MSIT. The presentation is rich in demos, including leveraging IaaS—Columnstore in The Cloud.  Learn whether columnstore can change your users' world & why columnstore may be a compelling reason to upgrade. Learn how columnstore indexes flip the DW faster bit & why columnstore manifests my motto, “Change the world or go home!”
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
8

Level: Intermedia

Session Code:

Date: November 01

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3

Level: Intermedia

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

If "Data is the Lifeblood of Modern Business," then most businesses are walking corpses with sludge in their veins, because 10% to 25% of all data records in the average enterprise are wrong.  Until the dramatic problems of Data Quality Management are addressed, SQL can never fulfill its original promise to eliminate application "silos", enable systems to communicate and provide useful, actionable information to the modern business.  I believe that we are on the cusp of a revolution in Data Quality that is even greater in scope and impact than the revolution in manufacturing quality that began over 40 years ago.  Businesses that make the transition will survive and thrive.  Those that don't will finally stop shambling about and lay down to die.What is this revolution in Data Quality?  How can you be a part of it (and avoid the headman's ax)?!?  This presentation will change the way you think about your jobs as Database Administrators and Application Developers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
6

Level: Beginner

Session Code:

Date: November 01

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

Level: Intermedia

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, we will look at the new BI query language for PowerPivot and Tabular - DAX. This session will give you an introduction to Data Analysis eXpressions (DAX) and will provide you the necessary understanding to start using in your environment for data analysis. No prior experience with DAX is needed to attend this session.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
5

Level: Beginner

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
Speaker:

Session Type:
Regular Session

Track:
5

Level: Intermedia

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

This session discusses a proven organizational approach and important technical considerations that lead to the successful adoption of Master Data Management (MDM) on SQL Server. Organizational considerations include building buy-in, team capability & expertise, and selling MDM to the rest of the organization while building a subject-area center of excellence. We also discuss approaches to improved time-to-value and to ensure that the technology and staff investment is matched to the expected outcome. Great technology choices will help ensure that your best laid plans succeed and the second half of this session goes over some important technology considerations. In this part of the session we discuss User Experience, Integration Patterns, Matching, Programmability, and Data Quality. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3

Level: Beginner

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

There are different types of enumerators in the SSIS Foreach Loop Container which helps to implement different loop scenarios. In this chapter these different types explained with few case studies, with resort of these different types of enumerators , SSIS Developers can loop through specific files, or through rows of a data table, or items of an array or other kinds of list structures. Variaty of these types will reduce needs of scripting.
In this article these types of enumerators considered:
File Enumerator, Item Enumerator, ADO Enumerator, ADO.NET Schema Rowset Enumerator, From Variable Enumerator, NodeList Enumerator, SMO Enumerator. 
This session is based on the book chapter of SQL Server MVP Deep Dive 2
Speaker:

Session Type:
Regular Session

Track:
3

Level: Intermedia

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Everything that's old is new again, as Windows Server moves back to the terminal interface.  With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure.  This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
7

Level: Intermedia

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Major disaster events resulting in unplanned downtime get all the press—but planned downtime constitutes almost 80% of the outages in any IT environment. This downtime is typically for tech refresh, migration projects, and OS/SQL Server patching. And when do you have to schedule the large downtime windows required to accomplish these upkeep tasks? Nights and weekends. Like you don't have better things to do then! In this session, learn how you can get the safety of a parallel deployment with the speed of an in-place upgrade for OS and/or SQL Server as fast as SQL Server can stop & restart, no data migrations for tech refresh, low-impact break/fix, and planned downtime windows of less than 2 minutes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
4

Level: Beginner

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

As a Database Administrator, one will find that there are plenty of ways to implement SQL Servers, and develop code for applications.  While there is plenty of debate on how best to do things, there are some agreed upon practices that should be found in any implementation of a database project.  When these practices are ignored, the longevity of that server may be compromised.  This session will define the phrase "best practices", and discuss several things that should be found in any SQL Server implementation to avoid issues in the long run.
Speaker:

Session Type:
Regular Session

Track:
6

Level: Beginner

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

When a query is run against a database, a plan is formed to do the work.  This session will serve as an introduction on how to read and interpret execution plans.  We will also take a look at the execution plan that won the 'Hairy' Execution Plan contest on SQLCruise Miami in 2013!  Take a peek at http://sqlcruise.com/winner-of-the-2013-caribbean-landlubber-sql-sentry-hairy-execution-plan/
Speaker:

Session Type:
Regular Session

Track:
8

Level: Beginner

Session Code:

Date: November 01

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

Level: Beginner

Session Code:

Date: November 01

Time: 12:00 AM - 1:00 AM

Room: TBD

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