Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 32
Agile methodologies are widely used in the dev world and are becoming increasingly adopted in the database world. But what about BI? 
Covering the technology and process sides of enabling agile BI, this session is designed to give you practical tips to get things moving more quickly for you.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 01

Level: Beginner

Session Code:

Date: April 25

Time: 9:25 AM - 10:25 AM

Room: Track 1 - Room: Calico Jack

Text mining is becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media. Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understanding the meaning of documents. The Term Extraction and Term Lookup components from SQL Server Integration Services also help with text analysis. Free statistical package / language R is also useful for the text mining tasks. However, the question arises: is all this enough? This presentation unveils the good and the bad side of text mining with the tools mentioned.
Speaker:

Session Type:
Regular Session

Track:
Track 01

Level: Intermedia

Session Code:

Date: April 25

Time: 8:00 AM - 9:00 AM

Room: Track 1 - Room: Calico Jack

For a long time people have been asking where is SSIS for the cloud.  Truth is it was never going to happen.  Azure Data Factory has been designed from the ground up.  It is designed for moving data at scale and with agility.  Come to this session to learn about this new service and how it come provide value to your business processes
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: April 25

Time: 9:25 AM - 10:25 AM

Room: Track 2 - Room: Anne Bonney

SSIS is a powerful tool for extracting, transforming and loading data, but creating the actual SSIS packages can be both tedious and time-consuming. Even if you use templates and follow best practices you often have to repeat the same steps over and over again. There are no easy ways to handle metadata and schema changes, and if there are new requirements you might have to go through all the packages one more time. It's time to bring the Don't Repeat Yourself principle to SSIS development. 

In this session I will use the free BIDS Helper add-in to show you the basics of Biml and BimlScript, how to generate SSIS packages automatically from databases, how easy those packages can be changed, and how to move common code to separate files that can be included where needed. See why they say Biml allows you to complete in a day what once took more than a week! 

This session is intended for SSIS developers who are not yet familiar with Biml.
Speaker:

Session Type:
Regular Session

Track:
Track 01

Level: Beginner

Session Code:

Date: April 25

Time: 10:45 AM - 11:45 AM

Room: Track 1 - Room: Calico Jack

This all demo session will take you through a case of how to build a completely meta-driven SSIS solution relaying on BIML and MDS to do the hard-work for you. Being able to do this and have the system finding the fastest way to load data automatically using system stored procedures enables you to offer near real-time reporting to your users.
Topics covered in the session
* BIML & SSIS
* MDS
* System SPs (especially sp_depends)
* Near Real-time reporting, what it takes and how to do it.
Speaker:

Session Type:
Regular Session

Track:
Track 01

Level: Intermedia

Session Code:

Date: April 25

Time: 11:45 AM - 12:45 PM

Room: Track 1 - Room: Calico Jack

When loading a large amount of data, e.g. into your data warehouse, you want 
the data inserted into the table as fast as possible. You know you have to use bulk 
load, but what do you need to do to ensure that data is loaded as fast as possible? 

In this session, you will learn about the different methods for bulk loading data 
into your data warehouse; using SSIS, BCP and T-SQL. You will also learn what is 
happening behind the scene of minimal logged inserts, why they are so 
important when doing bulk load, and what is required to achieve a minimal 
footprint on the transaction log. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 01

Level: Advanced

Session Code:

Date: April 25

Time: 9:25 AM - 10:25 AM

Room: Track 3 - Room: Flora Burn

Several years of work in one industry. A few years in another. The first professional exams, certification and specialization. For last few years, the next - this time in ICT. Even more exams (successful or not), the requirements, specializations, orientations. Is certification for information technology or information technology for the certification? Where to start, what to stop. Where is the end to the possibilities, and where the boundary joy of work. As far as proving something to someone in need IT career. These and several other strange, philosophical, perhaps unnecessary questions I will answer. A few would be left to their own assessment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: April 25

Time: 9:00 AM - 10:00 AM

Room: Track 3 - Room: Flora Burn

In Session One:  - Just what is database partitioning?  - Do I even need it?  - So what can be done in Standard edition?  Knowledge is power and after these sessions those big tables won’t be so scary anymore. They can be tamed and will soon be purring like a kitten. It’s never all pain-free sailing partitioning large live tables but, armed with the correct knowledge, you can start planning and implementing your partitioning. Sweet.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: April 25

Time: 10:45 AM - 11:45 AM

Room: Track 3 - Room: Flora Burn

In Session Two:  - And what can be done in Enterprise edition?  - Is it useful for Data warehouses and SSAS Cubes?  - And what’s new in SQL 2014?  Knowledge is power and after these sessions those big tables won’t be so scary anymore. They can be tamed and will soon be purring like a kitten. It’s never all pain-free sailing partitioning large live tables but, armed with the correct knowledge, you can start planning and implementing your partitioning. Sweet.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 25

Time: 11:45 AM - 12:45 PM

Room: Track 3 - Room: Flora Burn

Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, where files are stored outside the database, and from a homogeneous d
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: April 25

Time: 2:00 PM - 3:00 PM

Room: Track 3 - Room: Flora Burn

Maybe you are a developer who is quite comfortable writing T-SQL queries and stored procedures, but maybe someone has started asking about performance issues.  Maybe you have tuned the query and it runs fine; maybe someone is asking for you to tune it that little bit more, but you don't know where to start. Maybe someone has mentioned execution plans, but you don't really know much about them.  In this session Kevan will explain what execution plans are, where they come from, what they are used for and why are they so important that everyone keeps going on about them.  You will find out how to produce them, how to understand them and how to use them to find opportunities for further performance tuning.  This session will take you to the next level of understanding what SQL Server is doing under the covers when it runs your query.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: April 25

Time: 9:25 AM - 10:25 AM

Room: Track 4 - Room: Blackbeard

It’s often difficult to know how your SQL Servers will perform under different loads. By performing load testing, we can gain these key insights, perform modifications to existing configurations, and understand the impact on performance levels.

Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 25

Time: 4:20 PM - 5:20 PM

Room: Track 4 - Room: Blackbeard

There are many different ways of using SSIS to load data into a Data Warehouse. To populate a simple star schema it is quite easy to use an SCD transformation task  in SSIS. But when you want to handle advanced Data Warehouse requirements such as Type 3 SCDs, auditing execution details, error logs and fast performance, the SCD transformation makes it difficult. In this session I will present a pattern which can handle these in a scalable , efficient way in SSIS.I will also show how this pattern will benefit us when we use the Kimball audit model ,SSISDB and the SSIS catalog in SQL Server 2012.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: April 25

Time: 8:00 AM - 9:00 AM

Room: Track 3 - Room: Flora Burn

Machine learning is the science of making computers act without being unambiguously programmed. Machine learning (ML) is something that we use every day when we search and shop on the web and talk to our devices. Microsoft Azure ML is a fully-managed cloud service that enables data aware developers to efficiently embed predictive analytics into their applications,  without a PhD in statistics helping organizations use massive data sets and bring all the benefits of the cloud to machine learning. So join Andrew for a practical insight into the fascinating world of Machine Learning, where you can be significantly different but never certain, deviation is normal, and you are amongst friends if you found the above quote funny.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: April 25

Time: 2:00 PM - 3:00 PM

Room: Track 2 - Room: Anne Bonney

Making PowerShell useful for your team

You have heard about PowerShell and may be spent a little bit of time exploring some of the ways in which it will benefit you at work. You want to be able to perform tasks more specific to your organisation and need to share them with your team.
I will show you how you can achieve this by demonstrating
An easy way to learn the syntax
How to explore SQL Server with Powershell 
How to turn your one off scripts into shareable functions
How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions
Where else to go for help
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 25

Time: 10:45 AM - 11:45 AM

Room: Track 2 - Room: Anne Bonney

Multi-Site configurations are the natural progression from the more orthodox Failover Cluster Instances that form the basis previous High Availability configurations. With the introduction of Availability Groups and multi-subnet capability with SQL Server 2012 it is now even easier to build a multi-site & multi-subnet solution. With this ease of deployment it is more important than ever to look at the important configuration options that can have a big impact in multi-site implementations but not in single-site.

Covering things like Asymmetric storage configurations, DNS considerations and the advances in clustering. By the end of this session, you will be in a position to confidently start building out multi-site Highly Available and ef
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: April 25

Time: 4:20 PM - 5:20 PM

Room: Track 3 - Room: Flora Burn

Being more agile sounds like the right thing to do, unit testing, source control even SSDT should help to make us Sql Developers more productive and happier but how do we actually do it?

This is a talk about how to start with an existing database and drag it kicking and screaming into source control. 

We will cover what practical choices of IDE there are and how to use them to help, rather than hinder the development process.

In a nutshell, how do we become more agile on our Sql development!
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: April 25

Time: 8:00 AM - 9:00 AM

Room: Track 2 - Room: Anne Bonney

In my job as a SQL Consultant, I have my weekly recurring customers. They don’t have a DBA, so I have to perform the daily DBA checklist on a weekly basis ;) Initially, I've started with executing some T-SQL scripts to verify the SQL Servers. But as more servers were installed, my DBA checklist became really time consuming and I didn't even have the time for a coffee… In this session you will learn how you can perform your DBA morning checklist while sipping coffee. I will demonstrate how you can use Policy Based Management to evaluate your servers and how I configured my setup. By the end of this session, I guarantee you will have more time for your morning coffee!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 25

Time: 8:00 AM - 9:00 AM

Room: Track 3 - Room: Gold Island

Session Details not available
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 01

Level: Beginner

Session Code:

Date: April 25

Time: 2:00 PM - 3:00 PM

Room: Track 1 - Room: Calico Jack

An introduction to the different databases that SharePoint uses, with recommendations for High Availability, Disaster Recovery and configuration settings for SQL Server, including the constraints imposed in a single farm, a stretched farm between data centres and a separate DR farm.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 25

Time: 11:45 AM - 12:45 PM

Room: Track 2 - Room: Anne Bonney

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