Build Schedule

Advanced Filters:
  • Track

    clear all




  • Speaker


  • Level


  • Session Type

Sessions Found: 15
Starting with the 2005 release, SQL Server captures information about the workload on an instance, which you can use to monitor the system, gather performance metrics, and validate system settings.  This information is available via Dynamic Management View and functions and officially they "return internal, implementation-specific state data." This session gives an introduction to these concepts, how they make DBA life much sweeter and we discuss many of the different community queries available to help you get jump started in your environment.  We also open up the floor for ideas of how you are using these views/functions.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Power BI for Office 365 is Microsoft's new self-service BI offering. Just because it emphasizes self-service doesn't mean a system administrator isn't an important role! In this session we will discuss the overall system components and how a Power BI site in SharePoint Online differs from an on-premises SharePoint BI site.  We will walk through how to best handle setting up connectivity to data sources, when a gateway is needed, and what data refresh capabilities exist. We will also consider how and when to create OData feeds from your corporate on-premises data sources, and how those OData feeds affect Enterprise Data Search functionality.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Chris Hyde has been working with the Microsoft SQL Server stack for over thirteen years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000.  He is a Senior Consultant with Leidos Health specializing in the healthcare market, which he particularly enjoys as he gets to tackle different types of data problems at each client.  He is currently on the board of the Albuquerque chapter of SQL PASS.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Data center migrations are all the rage these days and the SQL Server DBA is one of the most important accessories to success. I find that approximately 10-20% of all Windows Servers in the business enterprise are SQL Servers.  When an organization makes the decision to move from one data center to another, of all the very important servers that will be migrated, the ones with the company data will be the most watched. Just like any other project, a good plan followed by good execution is required. In this session you’ll learn about the research, design, planning, process, and execution that go into migrating SQL Servers from one data center to another. I’ll go over some lessons learned and discuss whether you go it alone or brings in some help.  I’ll discuss the big options and decisions on migration techniques and methodologies and the pros and cons.  You’ll also hear about the big decisions like keeping the same server names, production downtime, data synchronization & more.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

On this session we are going to build an ETL framework that dynamically create SSIS templates according to metadata information. This methodology can be used to enforce standard, reduce development time and simplify ETL processes. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Attend the lunch demo and see how you can use Master Data Services and Maestro to:
•	Create a golden record for any subject area in a matter of minutes
	Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment?
•	Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything?
•	Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting
•	Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Overview of PowerShell and how to perform SQL scripts using PowerShell
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Research has proven that professionals who spend time deliberately planning their career achieve greater successes and accomplishments. Have you thought much about your career as an IT pro? Or have you drifted from one opportunity to the next without much forethought? Now is the time to change your approach. Join our panel discussion with noted bloggers, MVPs, and IT pros who can answer your questions and help you get onto a better career trajectory. These sessions are always fun and packed with wisdom. So don't miss out!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?

Hint: You attend Revenge: The SQL! 

This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!

Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

A walk-through of creating a sliding window table partition on an AdventureWorks table.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

"Just what the heck is a window function and why should I care?"  Have you ever needed to provide a running subtotal or average in your dataset?  Need to provide a total by customer or a grand total on each row?  Need to assign row numbers or counts that change when a certain value in your data changes!  Window functions to the rescue!  That's why you should care.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

Almost everyone uses SSMS to write queries and to browse around on the server - but do you use all of the features that SSMS offers to increase your productivity? Come to this session, consisting mostly of demos, to see features built-in to SSMS that will improve your experience and productivity. Time permitting, we'll also go into some 3rd party products that also increase your productivity in SSMS.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server is easier to administrate than any other relational database on the market.  But “easier than everyone else” doesn’t mean it’s easy, nor does it mean is problem free. After all, many apps are growing from small, home-grown applications every year, with green IT professionals encountering issues that others had tackled and solved years ago.  Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. There is a short list of mistakes that, if you know of them in advance, will make your life much easier. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

There are so many security tips out there for SQL Server. Almost all of them are rated as a best practice.What do you listen to? What do you focus on? In this session we'll break down what you absolutely must know about securing SQL Server. We'll look at the things to look for within SQL Server, including some of the nooks and crannies an attacker might use but what are rarely audited. You'll leave with a checklist of what to investigate and a set of scripts to run on your own systems.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: December 13

Time: 12:00 AM - 1:00 AM

Room: TBD

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