Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 35
This session will focus on the time intelligence functions built in to DAX along with writing custom date logic to deal with a range of common reporting requirements.
We will cover the use of the built in functions as well as how to recreate their logic with non-standard calendars.

Some key topics include:
- DAX time intelligence functions
- Date tables
- Filter expressions
Speaker:

Session Type:
Regular Session

Track:
BI 2

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

I am following up to a 2011 SQL Saturday presentation that I gave on this same topic.  Open Data is freely available for everyone to use and republish as they wish without restrictions from copyright, patents or other mechanisms of control.  The United States Government has a dedicated open data portal at Data.gov, and there are now hundreds if not thousands of open data portals from countries, provinces, counties, companies, and cities.  Now that there is open data available for you to reach out and grab, what comes next?  I'll review the maturation process of the open data movement, some examples of what's been done with it by myself and others, and how Microsoft BI tools are prime for mashing it up to make it usable and understandable.  Now that open data is widely available, the benefits it has to offer governments, companies, academia, and individual citizens will continue to expand exponentially.  We now have the information, so let's get going with the integration!
Speaker:

Session Type:
Regular Session

Track:
BI 1

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

The modern data platform is more than a server in your data center.  It goes far beyond that with the ability to reach beyond your data center to the cloud.  Through cloud offerings, you have the ability to grow past your current hardware limitations and deliver data solutions that grow and expand with your data needs. In this white board session, we'll explore cloud offerings for your data platform and how the support the needs of DBA to provide the infrastructure and performance that data platforms demand.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

You have heard all of the buzzwords and hype surrounding Microsoft Azure and the Cloud but what is it really and more importantly how can you use it effectively to solve the most important problems facing your organization today. We will look at both Windows Azure SQL Databases and using Azure VM's to host SQL Server.
Let Microsoft Certified Master of SQL Server Jason Horner show you how to apply your existing DBA skills to leverage SQL Server in the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Is there a great difference in the brain chemistry of someone fleeing a hungry mountain lion and someone presenting to a group of colleagues in a corporate board room? The answer is: NO. Over the past decade, a lot has been learned about the chemistry of the brain and why humans react the way we do to events in our environment. The concept of EQ (Emotional Intelligence) is a compelling and growing concept that applies this knowledge in a set of learnable, improvable skills for leading human beings. While EQ is often applied to corporate leadership, the parallels to presenting are fantastic. This session will explain the basics of EQ and demonstrate how you can apply it to make your presentations better in the following areas: * Crafting better slide decks * Preparing yourself for presenting * Delivering your content * Dealing with the unexpected Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room--including you.
Speaker:

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you back up your databases? If the answer is yes (and I really hope it is), do you test your restores? If a table gets dropped at 1:53PM, can you restore the database to 1:52PM using log backups? Can you use the WITH STANDBY parm to apply log backups to a read-only copy of a database? For the answers to these questions and a whole lot more about database restores, plus some nifty scripts, join me for this presentation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA 2

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session for beginner/accidental DBAs, we will cover 5 concepts we've come across that have helped make SQL easier to manage. These are practical applications that attendees can start designing and implementing in their environments right away. With a unique approach to presenting, Jen and Mark create an interactive session that you can not only learn from but have fun in as well.
Speaker:

Session Type:
Regular Session

Track:
DEV 1

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Sometimes half the battle in computing is just to see what's happening. We will take a visual tour of physical database storage structures, using live demos with the freeware application SQL Server File Layout Viewer and our old friends the DBCC commands as guides. See what happens in a data file when you convert a table from a heap to a clustered index! See fragmentation and the havoc wrought by Shrink! Marvel at the behavior of multiple files and filegroups! Index Rebuilds! Eureka!
Speaker:

Session Type:
Regular Session

Track:
DBA 1

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns?  Did your gut tell you that this is bad, but you had difficulty explaining why?  Did you know that these Datatype Choices can be a real performance killer?  Attend this session, learn how database records are stored within SQL Server, and why all data types are not created equal.  Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now!  When you leave, you should be able to explain why datatype choices matter to your colleagues, assess your own systems, and implement some best practices to mitigate these performance killers.
Speaker:

Session Type:
Regular Session

Track:
DBA 2

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session you will learn about the self-service ETL capabilities that have been added into Excel.  See how easy it is to pull in data from the web and integrate it and enhance your existing data to provide useful insights.  We will also take a look at the new data visualization capabilities provided with Power Map and see how easy it is to interact with and explore geographic and temporal data.  These are two new self-service capabilities that have been added and are part of Power BI, don't miss out!
Speaker:

Session Type:
Regular Session

Track:
BI 1

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

There are many automated test frameworks available for different types of applications, but Extract, Transform, and Load (ETL) data movement applications seem to lack an efficient and easy to use automated test framework. 
We will review how to create automated tests with a data driven approach by showing how the tests self-generate based upon the data in the Information-Model schema in SQL Server and 4 slender custom tables that define the field data mapping between the source and target.
The last half of the session will be a demonstration of the tests to illustrate how they execute. To do this we will quickly review the functionality of the tSQLt test framework and the stored procedure code we created that generates the tests. We will review the considerable functionality in tSQLt that makes ETL testing and database testing easy and efficient. 
We will execute hundreds of tests in the short time during the presentation.
Speaker:

Session Type:
Regular Session

Track:
BI 1

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you feel like you spend hours going round-and-round with your system, storage, and virtualization administrators over SQL Server best practices? Are their application-agnostic requirements hurting your SQL Server’s performance, or worse, their reliability? David Klee (@kleegeek) will discuss valuable insight into how to start and work through the common conversations with them on the SQL Server infrastructure practices that matter to you the most, and how to succeed in getting what you need while keeping everyone happy.
Speaker:

Session Type:
Regular Session

Track:
DBA 1

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

There are index methods in SQL Server that can enhance the performance of your queries - but most likely, you aren't using them! If you have a solid knowledge of index basics and want to add to your collection, this is the session for you! I'll show you how filtered indexes, compressed indexes, and indexed views work and can improve performance! 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DEV 1

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Understand the basics of SQL Server locking including lock modes, lock granularity and lock escalation.  Also what is blocking, why should you be concerned and what you can do about it.
Speaker:

Session Type:
Regular Session

Track:
DEV 2

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

If you've never queried an XML column you definitely want to attend.  After this hour there won't exist an XML element whose value you won't be able to retrieve. If you've been querying for years there is still a fair chance you'll learn something new.
Speaker:

Session Type:
Regular Session

Track:
DEV 1

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

NoSQL?!? No WAY!

Don't worry - the relational database still rules the data kingdom, but the world of data is moving beyond the confines of rows and columns and into a variety of types of systems.  

At the end of this session you will be able to dazzle your family and friends with your knowledge and application of the CAP theorem. We'll take a walk through the various types of NoSQL systems and discuss why you would use them.  You'll be armed with the right information to understand where document, columnar, key value, or hybrid solutions shine - and when you should avoid them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will take the beginner in big data and show them how to use powershell, HDinsight and Microsoft's Azure platform to enable on demand analytic and compute. These capabilities are critical in the modern data warehouse environment and can only be delivered by technologies working together to create an analytic fabric that the organization can use. From developers the analysts and operations folks, this session will have something for all of you. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 2

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

How often do you review your SQL Servers for basic security, maintenance, and performance issues?  If you say never, I'm not surprised - many of the servers I "inherit" as a managed services provider have many gaping holes.  It is not unusual to find databases that are never backed up, constant login failures (is it an attack or a bad connection string?), and servers that need more RAM/CPU/etc. (or sometimes that have too much!)

Come learn how to use freely available tools to check your servers for basic issues like backups and CheckDB as well as for more advanced issues like page life expectancy and indexing.  If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!
Speaker:

Session Type:
Regular Session

Track:
DBA 2

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

As SQL Server professionals, we have a complicated relationship with Excel-based tools. Rather than broadly paint Excel as friend or foe, why not learn how Power Query & Power Pivot can improve the SQL Server solutions you develop? In this session, we’ll cover scenarios where Power Query and Power Pivot can be leveraged to get the most from the proof-of-concept phase of your reporting, ETL, & analytics projects. Learn how Power Query can help you test the quality of your data well before the production ETL is deployed. We’ll also cover how Power Pivot can help you visualize the structure and granularity of your data, and why it’s the perfect “gateway drug” for SSAS cube development.  If you've ever had a BI project fall flat because “We didn't know what we didn't know” or want to avoid delivering a hundred reports when the data merits ten, this is the session for you!
Speaker:

Session Type:
Regular Session

Track:
BI 2

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

We DBAs are a busy lot. As time passes, it seems like we're being asked to configure and manage more and more servers and databases without an increase in headcount. What can we do to keep up? In this session, you'll learn about Powershell and how you can use it to automate your routine (and not-so-routine) tasks. After covering the basics, we'll get into some practical scenarios and compare the Powershell approach with the alternatives.
Speaker:

Session Type:
Regular Session

Track:
DEV 2

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

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