Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 40
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:
3 - Business Intelligence

Level: Intermedia

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Data mining is a technique used to derive previously unknown information from large amounts of data. The process of this knowledge discovery can help uncover new patterns within data and help analysts better understand the large datasets. Additionally, once these patterns have been defined, you can use them as part of predictive modelling estimating the likelihood of some event occurring.

SQL Server Analysis Services includes a data mining engine that can be used at various levels within an organization, from analyst to developer. This session will look at data mining as tool for data investigation by the business analyst.  We examine the business case, requirements and outcomes of data mining so that it can enhance our understanding of datasets. We will look at both simple and complex implementations of data mining that allow new information to be extracted from data and used in novel ways within the MS Stack.
Speaker:

Session Type:
Regular Session

Track:
7 - Free Data

Level: Intermedia

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Query plan shows how your query is physically executed and without a doubt, it is the best way to analyze most of the performance problems. We will delve into the internals of query plan operators, investigate how they work and where to look into query plan to find any problems.
Speaker:

Session Type:
Regular Session

Track:
4 - Super Development

Level: Advanced

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

When it comes to clustered columnstore indexes, you may already understand row groups, delta stores, and compression methods, but come see how clustered columnstore indexes work with locking and blocking and when using different compression methods and techniques. We will also dive deep into Dictionaries creation and different methods for ETL processes.
Speaker:

Session Type:
Regular Session

Track:
1 - DBA

Level: Advanced

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

With the evolution of SQL Server new possibilities are being opened, and today we have a vast range of possibilities to achieve our objectives. For a clustered instance is not different, as nowadays a shared storage living in a SAN is not the only possibility. 

On this session I will introduce all the available ways to store database files in a clustered SQL Server instance, including the news of SQL Server 2014. If you never installed or even worked with a clustered instance, this is not an issue! A quick introduction about the role of clustered instance will be made.

I'll wait for you there!
Speaker:

Session Type:
Regular Session

Track:
6 - Clustered Data

Level: Intermedia

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever flipped the pages of Books Online, only to find that the aggregate function you need is simply not there? So why not add it?
Ever since SQL Server 2005, you can easily create your own aggregate functions. All it takes is a bit of .NET code.
This session will show you exactly how to create a CLR user-defined aggregate function, and how to use it in your queries. But it will also show you many workarounds to avoid having to do this for many commonly requested aggregates.
Speaker:

Session Type:
Regular Session

Track:
5 - Mixed Data

Level: Advanced

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation's want to demonstrate some features of Data Auditing in SQL Server 2012.
What are the advantages and disadvantages of its use, where and in what environments to apply. The three approaches used were :
•	DML Triggers
•	Change Tracking
•	Change Data Capture
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
2 - Developers

Level: Intermedia

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Get a look through the tools that enable us to get information from data. In the last years BI became something that we all can get! Experience some of the patterns, tools and visualizations that are enablers of that change. SQL Tools through Excel is one of the keys…
Speaker:

Session Type:
Regular Session

Track:
5 - Mixed Data

Level: Intermedia

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

SharePoint databases are considered a black box - touch them and you lose support. Furthermore, SharePoint leaves an unintelligible track of database names and GUIDs on your server. They are supposed to scale, but how and how much? Here are some techniques DBAs should be aware of to optimize SharePoint performance and scalability. This demo-packed session, based on real-life experiences, will show you how to tune your SQL Server for SharePoint and how to customize your SharePoint installation so that it fits your IT conventions, not the other way around.
Speaker:

Session Type:
Regular Session

Track:
5 - Mixed Data

Level: Intermedia

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

TThis talk is about new features in Microsoft Entity Framework 6 - the new major release of EF. In December 2012 Entity Framework 6 beta was announced and made publicly available. In October 2013 were released EF 6.00 (major release) and EF 6.01. This is the first new version of EF since the announcement in 2012 that the product would be Open Sourced. Entity Framework is hosted on CodePlex. This presentation is about the new features, included in EF 6: Async Query and Save, Custom Code First Conventions, Multi-Tenant Migrations, Configurable Migrations History Table, Code-Based Configuration, Dependency Resolution, Updated Provider Model, Enums, Spatial and Better Performance on .NET 4.x, Stored Procedures & Functions in Code First, Connect
Speaker:

Session Type:
Regular Session

Track:
2 - Developers

Level: Intermedia

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Let's meet these two friends that can help us in our daily lives.
The System Center Operations Manager can greatly help us to manage our SQL Server.
Let's see what is the SCOM and meet some tips for monitoring our server SQL-server.
Speaker:

Session Type:
Regular Session

Track:
7 - Free Data

Level: Beginner

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Even in the most reliable ETL system, it's eventually going to happen: A package will fail, an output row count won't match what is expected, a data anomaly will force a forensic search of the package infrastructure... In this session, we'll talk about some of the things that can go wrong during package execution - and some of the defenses that can be built into SSIS to help head off those errors (or at least make the errors easier to troubleshoot). From error handlers to package restartability, and from logging methods to row count validation and remediation, we'll cover various ways to keep your ETL flowing when problems arise.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3 - Business Intelligence

Level: Beginner

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will take a look at Pig. Pig is a platform for analysing large datasets using a high level language in Hadoop.  It is easy to use, intuitive and embarrassingly parallel.  It was developed in order to avoid the complexities of Map Reduce. It is useful for ad-hoc analysis and of course ETL.  During this session we will see it being used to manipulate structured and unstructured data. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
6 - Clustered Data

Level: Intermedia

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

This session covers the Hekaton challenges for the developers at the 300-400 level including native compiled SPs but also some concerns about hekaton constraints etc.
Speaker:

Session Type:
Regular Session

Track:
2 - Developers

Level: Advanced

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 database Engine has so many business intelligence improvements that it might become your primary analytical database system. However, in order to get the maximum out of these features, you need to learn how to properly use them. This in-depth session shows some extremely efficient statistical queries that use the new Window functions and are optimized through proper indexing, including columnstore indices. We will also explain the formulas and usage of those statistical procedures. This session is useful not only for BI developers; database and other developers can successfully learn how to write efficient queries as well.
Speaker:

Session Type:
Regular Session

Track:
2 - Developers

Level: Advanced

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In this session with Microsoft Certified Master Brent Ozar, you’ll role play as the database engine while Brent gives you queries. You’ll learn first-hand about clustered indexes, nonclustered indexes, execution plans, sargability, statistics, TempDB spills, and T-SQL anti-patterns.
Speaker:

Session Type:
Regular Session

Track:
1 - DBA

Level: Intermedia

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

The Business Intelligence capabilities are with us several years. Nowadays,the needs of analysis have changed and the geolocation of data is essential - not only qualitative information. We need to see our data on maps. We need to integrate it with external services to add value to our insights. In this session you will learn to improve our BI solutions with geolocation and take advantage with the SharePoint tools to share and publish this information. Custom DLLs, Excel Apps, Tabular/Multidimensional techniques and the new Power BI capabilities will be shown in different examples using a mapping tool already developed by SolidQ.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
6 - Clustered Data

Level: Intermedia

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you currently working with Big Data? Do you wish it were easy to share that information with key stakeholders in your organization? In this demo-driven session, you will learn how to take the analysis you've done and share it with the entire organization via SharePoint 2013. 

We will look at surfacing Big Data via Excel with PowerView and eventually publishing it in a SharePoint 2013 farm. We will also look at the security and performance implications of integrating Big Data with SharePoint 2013, so you will be able to properly design your Business Intelligence infrastructure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
5 - Mixed Data

Level: Intermedia

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Understanding when and how to use NoSQL is already becoming essential, even for database professionals currently focusing only on the RDBMS world. This session will explain NoSQL for the SQL Server professional, discussing the history and needs that led to NoSQL solutions and the strengths and weaknesses in comparison with RDBMSs. We'll also explore the several NoSQL data models available in the market today (Key-Value, Column-Family, Document, and Graph) and cover the current solutions that implement them (Cassandra, MongoDB, Redis, Neo4j, etc.).
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
7 - Free Data

Level: Intermedia

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Power Query the new Excel Add In is a great data exploration toolset combined with other add ons
like Power Pivot, Power View and Power Map This session will take a deep dive into the language behind
the Power Query: "M". We will take the language concepts and possibilities and try to compare them
with another cool kids in town: "R" and "P" aka Python.  What possibilities
do these languages offer, where can you use them best and how good is the integration to the Microsoft stack.
The session is driven by demos and you will take away a good starting point how to work with these three
languages.
Speaker:

Session Type:
Regular Session

Track:
3 - Business Intelligence

Level: Intermedia

Session Code:

Date: April 12

Time: 12:00 AM - 1:00 AM

Room: TBD

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