Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 51
What is "Windows Azure SQL Database" all about ? What does this mean for me as a DBA ? What is the process for setting up a Windows Azure database ? How would I go about migrating one of my databases to "The Cloud" ? How do I possibly leverage this new technology in my production environment ? 
If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe, you have been tasked with finding out about "The Cloud". Join me in exploring the cloud where I will show you how SQL Server works in the Windows Azure SQL Database world. We will run through the simple process of configuring a Windows Azure SQL database. We will investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Windows Azure. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
the Profisee Experience

Level: Beginner

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Every company has a backup strategy. That backup strategy is worthless and will cause your business to fail miserably while losing valuable customer data and more importantly you will lose my order of chicken wings! In this session you will learn why backup strategies are for losers, what can I do to keep from being a loser, and how can I build a winning strategy! 
Speaker:

Session Type:
Regular Session

Track:
Cisco Solid Gold

Level: Beginner

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Join this session to learn about  traditional data mining with the power of Mahout in Hadoop and Azure Machine Learning.
Mahout is a machine learning library, supported in HDinsight. HDInsight is the Microsoft service that brings Apache Hadoop to the cloud, and Mahout is a powerful tool for processing models within HDFS and MapReduce. This session will cover how data mining is implemented in the context of big data and the cloud. 
This session will cover the full data mining cycle: ETL,building, testing, and training data models to visualization, testing, and real-time querying. You will see how to discover patterns and make predictions, classifications, and recommendations to get all the insights from your structured and non-structured big data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Pyramid Cafe

Level: Intermedia

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Office 365 Power BI offers new and exciting features that are leading a lot of companies into the cloud. However, there are several additional considerations that you must factor into deciding how to architect your overall BI solution. 

In this session, you will learn about the available Microsoft Azure components and services that support a BI ecosystem. In addition, you learn how to properly configure your solution, whether it’s a completely cloud-based solution or a hybrid solution that includes on-premises data sources and on-premises client tools. You will gain an overview of Azure networking, and how it works in Azure VMs as well as for Office 365.
Speaker:

Session Type:
Regular Session

Track:
Microsoft Music Magic

Level: Intermedia

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Some of the biggest challenges in any large SQL environment are maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. Join us in this session to learn best practices for system settings, file system layout, and scheduling maintenance tasks. 

By default, SQL Server does not install with best practices for every environment. In this session, we will discuss the best practices for most SQL Server configurations, and how to automate your SQL Server builds in both physical and virtual worlds. As you may know, completely automating the build process has great benefits, but it also has great trade-offs. We will talk about lessons learned from building a private cloud at a Fortune 100 telecommunications company with thousands of servers. 

You will also learn how use these same methods to ensure your own server build consistency, whether your SQL Servers are in the cloud or on-premises.
Speaker:

Session Type:
Regular Session

Track:
Dell Hall of Fame

Level: Beginner

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Cloud, Cloud, Cloud.  Microsoft is "all in". CxOs love the idea of renting compute resources.  You know this is where our profession is headed, but when and how fast.  When should you jump on board?  The good news is cloud will not eliminate or even reduce the need for IT and Data professionals.  The bad news is our world and our profession is changing.  Adapt or be left behind.  Come see what Microsoft Azure has to offer Data Professionals.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
the Profisee Experience

Level: Intermedia

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

After a long maturation process, SQL Server Data Tools is emerging as a huge step forward in database development.  It won't be long before Visual Studio replaces SSMS as the primary IDE for SQL Server developers.  One of the greatest benefits of making the switch is the continuous integration capabilities that are now streamlined by the tool set.  In this session we will discuss how SSDT works, the goal of continuous integration, and how you can put them together to dramatically improve your productivity as a database developer.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Amazon Arena

Level: Intermedia

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

This was the top scoring professional development session from the PASS Summit 2013. 

Ever wanted to convince the boss try something new, but didn't know where to start?  Ever tried to lead your peers only to fail to achieve your goals?  This session teaches you the eight techniques of influencing IT professionals, so that you can innovate and achieve change in your organization.

1.	Learn about the fundamental difference between influence and authority and how you can achieve a high degree of influence without explicit authority.
2.	Learn the eight techniques of influencing IT professionals, when to apply them, and how to best use them.
3.	Discover the communication and procedural techniques that ensure your ideas get a hearing by bosses and peers, and how to best win support for them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
the Ryman

Level: Beginner

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session I will introduce the data mining capabilities of Excel. We will talk about scenarios for the use of the tools and how to interpret the results. We will cover data preparation with respect to the mining models. We will also discuss the very important issue of "margin of error" and the dangers of misinterpreting and/or misapplication of the tools and results. Attendees can expect to leave with a clear understanding of the available data mining tools along with how and when to use them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Cisco Solid Gold

Level: Beginner

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you ready to begin data warehousing in your organization but don't know where to start? This session will provide an overview of the three most popular data warehouse architectures including Kimball's Dimensional Model, Inmon's Corporate Information Factory, and Linstedt's Data Vault. In addition, this session will compare and contrast each architecture and discuss the pros and cons for each architecture when paired with SQL Server Analysis Services.
Speaker:

Session Type:
Regular Session

Track:
Microsoft Music Magic

Level: Advanced

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Power up your data presentations with Power View and Power Map. Charts and maps can be made interactive, generated on the fly, or recorded as video with a soundtrack and special effects. Instead of trying to make your point with a boring list of names, numbers, and dates, put on your movie director's hat and give your data the Hollywood treatment as you yell, "Lights! Cameras! Action!"
Speaker:

Session Type:
Regular Session

Track:
Dell Hall of Fame

Level: Beginner

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Database corruption is simply a fact of a DBA's life - if you haven't seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption.  In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it. 
Speaker:

Session Type:
Regular Session

Track:
Amazon Arena

Level: Beginner

Session Code:

Date: January 17

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 data type choices can be a real performance killer? 

Attend this session to 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 will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.
Speaker:

Session Type:
Regular Session

Track:
Cisco Solid Gold

Level: Intermedia

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

This is a beginner session that will look at the graphical execution plan, and the important operators, properties and what to look for in an execution plan. It will discuss the ways to determine a poor cardinality estimate, parameter sniffing and spill to tempdb.

Speaker:

Session Type:
Regular Session

Track:
Cisco Solid Gold

Level: Beginner

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Big Data is the new great tool in the IT Toolbox. There are so many different ways to utilize Big Data in your environment, that’s hard to know what way may be the best for your situation, even if all you want to do is create a Proof of Concept. Microsoft Azure has come to the table with their own cloud offering called HDInsight. In this session, we’ll go over HDInsight, and the differences that exist between it and other Hadoop deployments. We’ll go through the different options for deploying an HDInsight cluster. We’ll also go over using PowerShell for interacting with HDInsight, including scripts that you can use to automate the creation of an HDInsight cluster, run a Pig Script, and downloading your output file from Azure Blob Storage.
Speaker:

Session Type:
Regular Session

Track:
Pyramid Cafe

Level: Beginner

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

So you've heard of Hekaton (In-Memory OLTP) but you aren't sure where to start or if it's for you or not. Maybe you've heard or read some information and not sure what's true or not. There's a number of misconceptions out there about Hekaton. By the end of this session you'll have a better understanding of what Hekaton is and how it may be able to help you. We'll discuss the basics of Hekaton and more as well as walking through some demos to show you how to use Hekaton and what it can do as well as help you get started diving into Hekaton on your own.
Speaker:

Session Type:
Regular Session

Track:
SIOS Sound Stage

Level: Beginner

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will examine how SQL Server replication works.  A technology that has been around, this tool is not going anywhere anytime soon.  It's an excellent way to keep a subset of data synched with another database without having to synch the entire thing (although you could if you wanted to!).  We will examine terms, internals, and walk through the setup of different replication pieces so you can implement this technology in your environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Microsoft Music Magic

Level: Intermedia

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Join us as we explore SQL practices that cause database administrators to lose sleep, and cost companies time and resources.  Efficiency, security, and availability will be covered
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
the Profisee Experience

Level: Beginner

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

When it comes to SQL Server one of the biggest request you hear is “How can I make my Query Run FASTER!?”.  The answer understanding the first step in that process Is understanding the Query Optimizer.  Understanding the Optimizer beings with knowing the Rules.  The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SIOS Sound Stage

Level: Advanced

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we'll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you're just curious about Availability Groups, then you won't want to miss this session.
Speaker:

Session Type:
Regular Session

Track:
SIOS Sound Stage

Level: Intermedia

Session Code:

Date: January 17

Time: 12:00 AM - 1:00 AM

Room: TBD

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