Build Schedule

Advanced Filters:
  • Track

    clear all














  • Speaker


  • Level


  • Session Type

Sessions Found: 44
Did you think cloud databases like Azure Database could replace your job? It's not, but it will  redefine your job as you know it today.  Platform as a service (PaaS) databases are here and adoption is growing.  In this session, you will learn how to take your current DBA skills and utilize them with Azure Databases.  We will focus on getting started, migrating databases, disaster recovery, performance, and security.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: August 13

Time: 1:00 PM - 2:00 PM

Room: CEAC 218

Your team does all the SQL Server maintenance and auditing, but it really shouldn't take quite so much time. It would be nice to get on that new project that's coming up in Q3, or study up on SQL 2016, right?  
You definitely need MinionWare: Minion Backup, Minion Reindex, and Minion Enterprise.
Minion Backup and Minion Reindex are FREE standalone solutions for SQL Server backup and index maintenance. Each module has a simple installation, extensive logging, and multi-level configuration options. 
 
Our flagship product, Minion Enterprise (or as we call it, "ME"), is the SQL Server management solution you've been looking for.  ME lets you see your entire enterprise from a single location. It easily answers questions like, "What are the service accounts for all the production servers? Who has sysadmin access to any server? How how much disk space will I need to add to the QA servers next year? Are there any databases that haven't had a full backup this week?"
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Spotlight

Level: Beginner

Session Code:

Date: August 13

Time: 8:30 AM - 9:30 AM

Room: CEAC 223

This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you will learn how you can leverage Powershell to not only efficiently meet the needs of your business, but also free up your time for other things.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 13

Time: 3:30 PM - 4:30 PM

Room: CEAC 334

Come eat lunch and let's talk Azure
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Lunch

Level: Beginner

Session Code:

Date: August 13

Time: 12:00 PM - 1:00 PM

Room: CEAC 333

Come eat lunch and let's talk BI! 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Lunch

Level: Beginner

Session Code:

Date: August 13

Time: 12:00 PM - 1:00 PM

Room: CEAC 334

Come eat lunch and let's talk about High Availability
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Lunch

Level: Beginner

Session Code:

Date: August 13

Time: 12:00 PM - 1:00 PM

Room: CEAC 337

Come eat lunch and let's talk performance tuning
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Lunch

Level: Beginner

Session Code:

Date: August 13

Time: 12:00 PM - 1:00 PM

Room: CEAC 424

Come eat lunch and let's talk SQL Server 2016
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Lunch

Level: Beginner

Session Code:

Date: August 13

Time: 12:00 PM - 1:00 PM

Room: CEAC 218

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 13

Time: 9:45 AM - 10:45 AM

Room: CEAC 424

The more clustered they are, the harder they fall. Sometimes. And sometimes, nobody notices anything happened at all. 

Whether you're having to design your first SQL Server failover cluster implementation, or have inherited a cluster built in the long, long ago before there was a historic record (or server manifest), join John Harp on an adventure through some of the most noteworthy failures a SQL cluster can encounter. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 13

Time: 11:00 AM - 12:00 PM

Room: CEAC 337

Loading large amounts of data into SQL Server can be challenging. Many factors may challenge your goal for tuned performance. To make the decision making process more difficult, many of the choices listed below have both Pros and Cons to their implementation. For this reason, bulk loading large amounts of data requires a strategy.

Create a strategy to optimize your massive data loading processes.
•	High Performance Data Loading
•	Minimal Logging and Bulk Loading
•	Indexing Considerations
•	Delayed Durability
•	Eager Write

This session uses a Virtual Sandbox to demonstrate “real” data loads using these techniques listed above. We will look at the T-SQL used in these data loads. We will briefly discuss how the different settings and configurations effect the data loads. Power Point slides and sample SQL will be provided.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 13

Time: 3:30 PM - 4:30 PM

Room: CEAC 333

Do you ever have that nagging fear that your dimension tables don't have the data they need?  Maybe you're working too hard to capture and store detail no one is using or maybe you can't stop thinking that you've missed something?  This session will (hopefully) set your mind at ease.  Let's design a dimension the agile way!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 13

Time: 1:00 PM - 2:00 PM

Room: CEAC 334

Data is the central component of most applications.   The modern day application user expects applications to be reliable, performant and have minimal downtime.  Designing a database and its constructs with this aspect in mind is critical to the success of any application both for internal customers as well as external.  This session will explore addressing those performance and design needs by understanding how the query processor works, how statistics impact plan selection and some useful query building tips to proactively build your database awesome the first time so you never hear the words ‘Must be the database!’.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 13

Time: 11:00 AM - 12:00 PM

Room: CEAC 223

2016 is the year of All-Flash for primary storage and EMC’s industry leading portfolio of All-Flash arrays unlock the speed, efficiency, and agility that your business stakeholders have been demanding. Whether supporting 1,000 or 10,000,000 IOPS, EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type. 

Beyond just production database performance, EMC provides robust database repurposing via our iCDM or Integrated Copy Data Management capabilities. Creating and maintaining test/dev, near real-time analytic, or sandbox environments has never been simpler. Join us and hear how we can address the needs of all of your Microsoft SQL Server instances.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Spotlight

Level: Beginner

Session Code:

Date: August 13

Time: 12:00 PM - 1:00 PM

Room: CEAC 223

The need for organizations to provide Row Level Security (RLS) in their applications is increasing every day, often in existing applications where code changes are not easy. Microsoft has addressed this need in SQL Server 2016/Azure SQL DB with predicate based RLS.  


This session will show how organizational & asset hierarchies are leveraged together to provide predicate-based RLS on tables in SQL Server 2016/Azure SQL Database without application changes. This session will go beyond the basic RLS setups and show a real-world production setup of RLS using a small number of security records to secure large and small organizations. 


Attendees will leave with a complete working demo they can take to their work and begin to use immediately. The demo will walk completely through creating the database, creating the application tables and security related tables, loading demo and security data, setting up the RLS and testing the RLS using Power BI as a test application.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 13

Time: 1:00 PM - 2:00 PM

Room: CEAC 333

When you create an AG the default backup preference is secondary.....and let the detective work begin. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 13

Time: 8:30 AM - 9:30 AM

Room: CEAC 424

There are multiple options for hosting relational databases in Azure. A common challenge we come across frequently is helping ISVs to understand all of the options and sorting out which is right for their scenario. This first video address that challenge by helping you to navigate the decision tree between PaaS (Platform as a service) and IaaS (Infrastructure as a service). Specifically, When deciding what type of database to use in Azure.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Azure

Level: Beginner

Session Code:

Date: August 13

Time: 2:15 PM - 3:15 PM

Room: CEAC 334

Have you ever thought to yourself  “All these people think I’m smarter than I really am" or "I really don’t know what I’m doing, they're going to figure out I'm a fraud!”  If yes, then you suffer from the Impostor Syndrome. And despite all the accomplishments, awards and accolades, you still doubt yourself. It’s rampant in the modern day tech workplace, and the fear will make you shrink back from opportunities. You dismiss praise. You overcompensate by working harder, being charming and demanding perfection from yourself. What would happen if you were released from this bondage, and kicked your impostor to the curb? In this session, learn 3 powerful techniques that can help to improve your confidence and silent that annoying voice in your head!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: August 13

Time: 11:00 AM - 12:00 PM

Room: CEAC 334

Have you ever needed to generate dozens (or even hundreds) of similar SSIS packages? Do you ever find yourself needing to regenerate a lot of packages when some piece of the upstream data format changes? Using native SSIS, this can be a tedious and error prone exercise. However, using Biml (Business Intelligence Markup Language) can greatly increase your productivity as an ETL developer.

In this session, we'll cover the essentials of Biml. I'll discuss what it is and what it can do for SSIS, demonstrating how it can easily generate dozens or even hundreds of packages in just a few minutes. I'll also demonstrate some realistic examples and discuss how Biml fits into the enterprise ETL picture.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 13

Time: 2:15 PM - 3:15 PM

Room: CEAC 337

SQL Server has some of the best monitoring tools out there. But what about that server you just discovered? And you're all out of monitoring licences? Or, what if you need additional information that your monitoring tool isn't providing? Or, would you like execution plans and lock information for further analysis? All this and more is possible using the industry standard sp_whoisactive, created by Adam Machanic, to monitor and log activity on your SQL Servers. This session will teach you how to log and query the wealth of information sp_whoisactive provides.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 13

Time: 9:45 AM - 10:45 AM

Room: CEAC 218

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