Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 38
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:
Database Development

Level: Beginner

Session Code:

Date: June 27

Time: 9:45 AM - 10:45 AM

Room: C130

SQL Server Master Data Services (MDS) is a robust platform for master data and hierarchy management that provides master data capabilities such as business rules, a managed schema, hierarchies, versioning, workflow, and Excel Integration.   Profisee Maestro slashes your time to deployment on MDS by providing an alternate UI for data Stewards and Application owners.  Maestro adds data modeling, a first-rate user experience, ER-Win Integration, Simplified Import/Export to simplify getting MDM in the hands of your users.
Maestro also adds data quality, matching, harmonization, address corrections, an API, web parts and CRM integration.   
Come see how Profisee Maestro can take your MDS implementation from the department to the enterprise.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Lunch Sessions

Level: Beginner

Session Code:

Date: June 27

Time: 12:15 PM - 1:15 PM

Room: Theatre C300

Lots of businesses nowadays dream about the software tools which could make analytics available and easy for them. 
Microsoft offers several options for implementing variety of analytical scenarios:
·         data modeling and feature engineering with PoverPivot, Power Query,
·         interactive visual analytics with Power View, Power Map, Power BI and
·         advanced analytics with Sql Server Analysis Data Mining and recently released Azure Machine Learning.
We will give an overview of these tools and represent the power of combining them all to hack different datasets for hidden insights.
We will share lessons learned by our team from Microsoft Big Data Hackathon with Translink public data. We hope that this session will give a boost for Sql Server developers to put all the power of Microsoft BI tools together and implement advanced and flexible analytical solutions for their customers.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: June 27

Time: 8:30 AM - 9:30 AM

Room: C130

Azure Data Factory is a new Service offered by Microsoft on Azure that can help you to  manage your data on premise and in the clouds. This session will allow you to familiarize yourself with the different concepts and opportunities offered by the Azure Data Factory service.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Cloud

Level: Intermedia

Session Code:

Date: June 27

Time: 2:45 PM - 3:45 PM

Room: Theatre C300

As more enterprises start implementing big data solutions, how does the DBA support these efforts and do they have the skills and knowledge to integrate big data solutions into your current architecture and processes? This demo-filled session has two purposes; first, to help DBAs understand how to apply their existing SQL Server skills in understanding and utilizing HDInsight and related technologies. Big data technologies don’t need to be intimidating, and this session will help DBAs see how they can easily apply their current skill when working with big data. Second, this session will show how SQL Server and HDInsight be used together to create solutions to solve big data problems without the complexities of massive learning curves and using technologies DBAs are already familiar with. We’ll look at technologies that make working with big data much less daunting, including HiveQL and Sqoop, both of which don’t require a rocket science degree to use.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Big Data

Level: Intermedia

Session Code:

Date: June 27

Time: 8:30 AM - 9:30 AM

Room: Theatre C300

Sometimes users require underlying data to be static and unchanging. In this session we'll examine steps used to create a static server from a copy of a live data warehouse server, including implementing clustered columnstore on large partitioned tables, simplifying the management of files and filegroups, and reclaiming large amounts of database space.
Speaker:

Session Type:
Regular Session

Track:
Data Warehousing

Level: Intermedia

Session Code:

Date: June 27

Time: 8:30 AM - 9:30 AM

Room: C180

Techies and business people will learn how to choose the right projects for Hadoop. We'll talk about how Hadoop fits into end-to-end architectures and when it makes sent to put new Hadoop projects in the cloud, focusing on Microsoft Azure. I will show you HDInsight on Azure as well as Hortonworks HDP and Cloudera EDH/CDH on Azure VMs. http://smallbitesofbigdata.com/archive/2015/02/25/master-choosing-the-right-project-for-hadoop.aspx 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Big Data

Level: Beginner

Session Code:

Date: June 27

Time: 1:30 PM - 2:30 PM

Room: Theatre C300

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 sub-second 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. 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:

Session Type:
Regular Session

Track:
Data Warehousing

Level: Intermedia

Session Code:

Date: June 27

Time: 9:45 AM - 10:45 AM

Room: C180

Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration has proven to be a valuable technique in improving software quality by finding problems quickly and letting developers know immediately they have introduced a bug.This session demonstrates how you can implement CI for SQL Server databases, execute automated tests against your code and inform developers that they have caused a problem immediately. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: June 27

Time: 9:45 AM - 10:45 AM

Room: C100

TBD
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Lunch Sessions

Level: Intermedia

Session Code:

Date: June 27

Time: 12:15 PM - 1:15 PM

Room: C130

Do you want to test hardware upgrades, index tuning or multi-client applications? Would you like to do this with data specific to your organization?  Distributed Replay, introduced in SQL Server 2012, is a tool that will allow you to accomplish exactly that. In this session, we will cover why you should use it, how to set it up, and what types of data to collect for testing  and replay.  This session will demonstrate tangible methods and undocumented tidbits, that you can take back to your environment to create immediate, and measurable tests.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: June 27

Time: 1:30 PM - 2:30 PM

Room: C100

This session will show attendees how to use database replication to manage the ever-increasing volume of data by using database replication to maintain near real time copies of databases closer to the consumers of that data.  We'll discuss the use of database replication to both distribute and consolidate data with no impact to performance or reliability.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: June 27

Time: 8:30 AM - 9:30 AM

Room: C100

Is your database development process as mature, automated and repeatable as your other code development processes? Do you have source control, builds, unit tests and automated deployments as part of your database software development lifecycle? Or instead, do you have some change scripts saved somewhere and rely on your DBAs to hit F5 on the correct scripts in the correct database?

The client services IT team at Orbis is coming to the end of an ambitious project to refactor a large legacy codebase. Like many organisations, we had a lot of business logic in our database layer and didn't have much of a software development lifecycle process to keep it under control. 

This talk will demonstrate the process we took to implement SQL Server Data Tools Database Projects, how that enabled us to get control of our database development, and how easy it is for you to start getting control of your database development too.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Database Development

Level: Beginner

Session Code:

Date: June 27

Time: 8:30 AM - 9:30 AM

Room: C150

SQL Server licensing is complex—& expensive.  Consolidating on Flash provides savings of hundreds of thousands *per server*. A contemporary commodity two-socket server costs around $10K; SQL licenses for that server cost $200K to $300K or more. An idle CPU isn't doing nothing—it's burning money. You paid for your licenses, learn how to leverage them fully by leveraging Flash.  Whether upgrading to leverage the latest-&-greatest SQL Server features or to maintain support owing to the Windows Server 2003 & SQL Server 2005 EOL events, or consolidating strictly for economics, learn about real-life examples in which SanDisk has collaborated with our customers to save up to millions—& learn how you can educate your engineers & CxO's so you can do the very same thing. Doing so not merely covers your server & Flash hardware budget, you'll have piles of money left over—and an even bigger pile when you stop paying for SAN maintenance. Standardize to optimize! Move electrons not molecules!
Speaker:

Session Type:
Regular Session

Track:
Lunch Sessions

Level: Beginner

Session Code:

Date: June 27

Time: 12:15 PM - 1:15 PM

Room: C100

Quick overview on who is Pyramid Analytics and demo on Pyramid Analytics BI Software
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Lunch Sessions

Level: Beginner

Session Code:

Date: June 27

Time: 12:15 PM - 1:15 PM

Room: C180

Presented By Dell
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Lunch Sessions

Level: Beginner

Session Code:

Date: June 27

Time: 12:15 PM - 1:15 PM

Room: C130

Many of the things a DBA needs to monitor on a regular basis can be performed with Policy Based Management. Mistakes made by junior DBAs or developers who don’t understand the database policies can be caught and prevented with Policy Based Management. As a built-in feature in SQL Server, Policy Based Management is often overlooked. Learn about policies, facets, and conditions. With more demo than slides, this session will show you what you need to know to get started with Policy Based Management in your organization. By the end of this session you will have a solid understanding of what Policy Based Management is, when you should use it, and how to use it appropriately. This session is also a good prep for some material in the 70-462 Administering Microsoft SQL Server exam.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Beginner

Session Code:

Date: June 27

Time: 2:45 PM - 3:45 PM

Room: C100

Have your efforts to trim a few pounds off your log file been met with frustration? Are you scratching your head on why that DBCC SHRINKFILE doesn’t seem to do anything?  Log file obesity is a problem that can challenge DBAs of any level.  This session will help you deal with your overweight database by covering how log files grow, why truncating the log is a bad idea, and what you can do to keep your files trim and fit.  
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: June 27

Time: 2:45 PM - 3:45 PM

Room: C100

This session will provide an introduction to Master Data Management (MDM). We explore the basic concepts, types of MDM solution, and the basics for a successful MDM Implementation. With a working definition in hand, we'll discuss strategies for beginning a successful MDM pilot in your organization and look at some of the pitfalls to avoid. We'll wrap the business discussion up with some tips for selecting the right domains to solve and some tips for managing the politics of MDM. After we've set the stage for what, how and why you need MDM, we'll take a brief look at SQL Server MDS through the Excel add-in and talk about the Architecture of MDS
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Enterprise Information Management

Level: Beginner

Session Code:

Date: June 27

Time: 2:45 PM - 3:45 PM

Room: C180

Demonstrate Power BI Technologies utilizing 30 years of NFL data
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: June 27

Time: 1:30 PM - 2:30 PM

Room: C130

Sessions Found: 38
Back to Top