Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type




Sessions Found: 49
When was the last time you read up on SQL Agent features? Is there more you could be doing with it?

We'll answer this question and more as we take a deep dive into the SQL Server Agent. In this session we will cover some of the basic best practices of SQL Agent configuration as well as more advanced topics like managing large numbers of jobs, properly managing job history, and keeping jobs in sync across multiple instances.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 17

Time: 9:00 AM - 10:00 AM

Room: Room 2300

"Its.Slow!" are probably the two most dreaded words for any database professional (right behind "You're fired!") 

What's slow? Since when? Compared to what?

Join this "something-everyone-should-be-doing-but-isn't" session, in which we will discuss baselines and performance monitoring for your SQL Server Analysis Services (SSAS) environment. We'll cover what a baseline is, what information it needs to include, and how it can help you troubleshoot immediate problems and proactively avoid them in the future. Walk away from the session with a plan that you can implemented next week to help avoid being caught off guard by SSAS performance issues and to make troubleshooting a breeze.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 17

Time: 10:15 AM - 11:15 AM

Room: Room 3316

Azure SQL Database is now based on the same bits as SQL Server 2014, bringing great enterprise capabilities.  We will discuss business continuity features such as geo restore, point-in-time recoveries, and how to recover a deleted database with only a few clicks.  No more retrieving tapes from you off-site backup vault!  Learn how easy it is to configure a geo-replicated solution which allows for both disaster recovery and readable secondaries. Use the built-in SQL Server Management Studio wizard to migrate your on-premises databases into Azure SQL Database.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 17

Time: 1:45 PM - 2:45 PM

Room: Room 3316

Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA's can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA's are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 17

Time: 10:15 AM - 11:15 AM

Room: Room 2315

The cloud is here! Are you ready?  Microsoft, Amazon and others are all vying for your cloud attention.  In this session, we will review the different types of cloud platforms available and what they mean to you.  We will pay close attention to Microsoft’s Azure platform that offers two hosting solutions.  What are these hosting options and what are the differences between them?  Most importantly, how do I get started with all of this cloud business?  Let's put SQL Server into the cloud!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 17

Time: 3:00 PM - 4:00 PM

Room: Room 2302

In this presentation Brian Davis and Scott Fallen will demonstrate how SQL Sentry tools help UpSearch and their managed services customers monitor and tune their SQL Servers.  Brian is a SQL Server Consultant for UpSearch, and Scott is a Sales Engineer for SQL Sentry.  During the presentation, we will look at baselining, performance bottleneck identification, query tuning, alerting, and automated response with SQL Sentry in the context of how the team at UpSearch leverages these features.  We will conclude with a demo of some of the powerful features of SQL Sentry Plan Explorer FREE.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Vendor Lunch Session (30 minutes)

Track:
Sponsored Session

Level: Beginner

Session Code:

Date: October 17

Time: 1:00 PM - 1:30 PM

Room: Room 2315

For most of us, our career in technology was and is the result of our combined education, experience, opportunities, and luck. In this presentation we will explore approaches to creating the career we want instead of the one we stumble into.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 17

Time: 1:45 PM - 2:45 PM

Room: Room 3315

In this session, we are going to connect to a fully deployed Hadoop Cluster using PolyBase and Power BI. We will go over the Pros vs Cons of using this solution and what use cases this architecture fits.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: October 17

Time: 1:45 PM - 2:45 PM

Room: 3314

Crash course on becoming better SQL developer by focusing on common mistakes and how to overcome it. What does one need to know to become better SQL Developer? What tools can make your job easier and how to use them? How can I write modular code to make it reusable? These and many other questions will be answered by reviewing mistakes, showcasing free tools and going over bad code.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 17

Time: 9:00 AM - 10:00 AM

Room: Room 2316

These talks discuss using the native Windows performance tools System Monitor and WMI technology to create logs that track the overall performance of SSIS, SSAS, and SQL Server. This will be a deep dive into Windows Performance Monitoring and WMI tools that are native to all Windows Operating Systems and how they can be used to track and monitor your SQL applications. I will discuss memory utilization, counters, WMI classes, and threading that is collected during SQL operations within the Windows OS. I will also show you how to collect this data manually or via automated schedule and export it for later evaluation or logging
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: October 17

Time: 1:45 PM - 2:45 PM

Room: Room 2315

Database corruption could happen to you. This could potentially be one of the worst nightmares you could experience in the database world.  In this session I will be talking about what database corruption is. I will also give a lesson on how dbcc works and the limitation of it. I will give examples of database corruption and how to resolve them.
I will also give examples of how to verify integrity of backups. Backups are essentially the last resort for resolving database corruption.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: October 17

Time: 3:00 PM - 4:00 PM

Room: Room 2300

Your organization relies on SQL Server to support its applications, customers and employees. But to maintain productivity, control costs and protect data, your SQL Server environment must be up and running, effectively supported and secured.  Come see how DELL SQL Server Solutions increase productivity, reduce costs and protect data in your SQL Server environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Vendor Lunch Session (30 minutes)

Track:
Sponsored Session

Level: Beginner

Session Code:

Date: October 17

Time: 1:00 PM - 1:30 PM

Room: Room 2316

So you have a good backup strategy in place, but now you have to think about a disaster recovery.  Where do you start and what are your options?  SQL Server offers several options, but then how do you choose the right one to meet your business requirements?  In this session, we will go over some of the common DR options including log shipping, replication, mirroring, clustering, and AlwaysOn.  Then we will talk about how to choose the best one to meet your business needs.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 17

Time: 1:45 PM - 2:45 PM

Room: Room 2314

The pervasiveness of Big Data has created significant challenges for companies that have historically utilized relational database management systems to perform data analysis and predictive analytics.  This presentation outlines the challenges that stem from Big Data as it relates to deriving value from data, the types of NoSQL data stores available and how NoSQL can serve as a data platform that enhances the data analysis and predictive analytics capabilities of companies.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: October 17

Time: 3:00 PM - 4:00 PM

Room: Room 3314

Microsoft has been busy working on the next version of SQL Server - SQL Server 2016.  We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB.  Row Level Security allows you to add another layer of security to your environment.  StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 17

Time: 9:00 AM - 10:00 AM

Room: Room 3315

This session is for database and application developers who know Microsoft's T4  (Text Template Transformation Toolkit) from Visual Studio but would like to make the transition to the powerful BimlScript language for generating SSIS and SSAS projects dynamically. Business Intelligence Markup Language (Biml) and BimlScript let you tap into the rich metadata of your SQL Server databases, multiplying your efficiency and accuracy many times over. During this highly-interactive session, we'll leverage your familiarity with template-based code generators like T4, comparing its features to BimlScript to tackle some difficult Business Intelligence tasks in a fraction of the time it would normally take. If you don't know T4, any prior experience with template-based code generators will prepare you well for this session. Moreover, if you've never done dynamic code generation before, you may still find this session fascinating and a quite useful addition to your toolbox.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: October 17

Time: 11:30 AM - 12:30 PM

Room: Room 3314

Are you just breaking into the query tuning side of managing your SQL Servers?  In this session, we will cover the basics you need to start leveraging execution plans as part of your tuning process.  We will discuss how SQL Server creates and uses plans, and how to collect them.  Once we have the plans, we will go step-by-step through how to read them, and what the most common operators mean.  We will look at the different types of operators not just from a standpoint of what they do, but how they can impact query performance.  We will also cover how good database design and maintenance allow you to get better execution plans through having the right indexes and up-to-date statistics.

Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 17

Time: 3:00 PM - 4:00 PM

Room: Room 3316

SSIS has many great built-in tasks and components. Sometime, though, you need to go further than what they allow. Come to this session for an introduction to the scripting capabilities of SSIS. 
Many data movement activities can be handled with SSIS using the built-in tasks and components. Eventually, though, you will run into a scenario that will be better handled by extending SSIS functionality with custom code. In this session, we will cover the basics of using scripts in SSIS control flows and data flows. We’ll talk about the pros and cons of scripts, review the development environment for scripts, cover some interesting and useful .NET classes, and walk through multiple examples of scripts that add useful functionality to SSIS.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 17

Time: 9:00 AM - 10:00 AM

Room: Room 2315

Any changes to Non-Memory Optimized tables require a certain amount of logging to the transaction log in order to ensure the integrity of the operation and of course the database. Most of these are fully logged operations and can write a tremendous amount of data to the transaction log. As you probably already know these can lead to various performance and availability issues. However you may be able to minimize the effect of these with what is called a minimally logged operation. This session will outline how these can be used under the right conditions to save time, resources and potentially a lot of headaches. Various demos will hit home on just how much of an impact this can have on some every day operations.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 17

Time: 10:15 AM - 11:15 AM

Room: Room 2316

Despite the wealth of analytical technologies available today, 65% of fraud at public companies is detected through tips, management review, or simple accidents.  Forensic Analytics combine human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities.
In this session, we explore Forensic Analytics: a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of Forensic Analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected.  We discuss guiding principles that are key to isolating data anomalies, and outline a standard, repeatable process to Forensic Analytics. Throughout the session, we view examples of how we can employ PowerPivot for Excel to drive Forensic Analytics via various tests and reviews.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 17

Time: 3:00 PM - 4:00 PM

Room: Room 3315

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