Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 25
So you've heard about this cool scripting language from Microsoft called PowerShell. Maybe you've even thought "I need to learn something about that." Well today is your lucky day, in this session we'll take you from a PowerShell "noob" to Pop Star in one fast paced demo filled session. We'll start with the basics, cmdlets, variables, and providers. Then we'll look a quick look programming fundamentals, such as as branching, looping, script blocks and variable scoping. Finally we'll get into the advanced, fun stuff like functions, error handling, working with file types and wrap it up with creating a spiffy user interface. They'll be rolling out the red carpet when you get back to work Monday for the newest PowerShell Pop Star.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
HSB 129A

Level: Beginner

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server on VMware???  Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.
Speaker:

Session Type:
Regular Session

Track:
HSB 129C

Level: Intermedia

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Entity Framework 4 brings the ability to separate the data models from the data access implementation. We'll show how to build your application models using the EF 4 POCO templates and be able to test them without accessing your database using repositories and Mocks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
HSB 129B

Level: Intermedia

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

We will explore data quality issues that face today’s business and how Data Quality Services 2012 can help IT Pros and Data Stewards meet those challenges. We will start from zero, build a knowledge base, profile data to train our knowledge base and then use that knowledge to highlight both the cleansing and matching capabilities of DQS. This session will also cover the DQS SSIS component that’s available in SQL Server 2012.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
HSB 129C

Level: Intermedia

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn how getting involved in the SQL Community can help you get ahead within your organization, improve you skill set as well as help provide career stability.  PASS and other organizations practically give you all the tools you need to succeed in the DBA field, learn about the events that help make this possible as well as how you can get involved to help others who are starting out.  The rewards of the SQL Community are endless.
Speaker:

Session Type:
Regular Session

Track:
HSB 129B

Level: Beginner

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 introduces the first significant enhancement to FILESTREAM: FileTables. FileTables use the underlying FILESTREAM storage, but expose the stored data using traditional Windows file I/O APIs. In addition, they also support hierarchical data storage (read "folders"). This session will show how to set up your SQL Server instance to support FileTables, how to create a FileTable and how to access it using standard Windows file APIs.
It may be valuable to attend the Introduction to FILESTREAM session also.
Speaker:

Session Type:
Regular Session

Track:
HSB 129A

Level: Intermedia

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Businesses depend on reliable data that can be managed effectively and shared through-out the enterprise. In this session we will look at the how Master Data Services 2012 can provide a solid platform for your organization's master data management implementation. We will spend a majority of the session building a model, loading it with data and then refining it to highlight the features and capabilities that are available both out-of-the-box and through the excel plug-in.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
HSB 129C

Level: Intermedia

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

It is easy to schedule full backups to run each night, but is that the right decision for your organization?  You say you have a backup strategy, but what is your recovery strategy?  Do you have a well-executed recovery plan?  

In this session Tim Radney will cover several methods for performing much needed backups and how to recover those backups.  Full, Differential, File Group, Transaction logs and recovery the tail end of a the log.  He will discuss industry best practices and hopefully cause you to validate and test your current strategy.
Speaker:

Session Type:
Regular Session

Track:
HSB 129B

Level: Intermedia

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you struggling with performance issues and your current tools are not providing answers? This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response time analysis. The speaker will use real-life case studies to demonstrate the techniques.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
HSB 129D

Level: Beginner

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

PowerShell is everywhere, and that includes SQL Server. In this session we'll look at using PowerShell with both the SQL Server provider and the SMO (SQL Management Objects). Learn how to handle common DBA tasks, such as checking the status of various services, validating backups, and checking for disk usage. You'll also see how to perform developer tasks such as creating tables, inserting records, and querying data. Come see how to make your SQL Server Pop with PowerShell. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
HSB 129A

Level: Intermedia

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

As systems grow and evolve, we need tools to help manage these changes, including tracking changes to the database schemas, producing scripts to synchronize the changes between servers, and refactoring the corresponding application code based on the new structures. You'll see how you can use tools in Visual Studio to help manage these changes better.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
HSB 129B

Level: Intermedia

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Moving day is one of life's most stressful times.  Details drown you, critical items consume time and attention, and there is always someone demanding you get something done now.  This is true whether you are moving your home or your data platform.  SQL Server migrations are a core competency for a DBA.  This presentation will give you a strong structured process for a successful migration using examples focused on SharePoint workloads.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
HSB 129B

Level: Intermedia

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

We will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and Q&A so by the end you should be able to walk away ready to take control of your SQL Server environment using this awesome new feature!
Speaker:

Session Type:
Regular Session

Track:
HSB 129C

Level: Beginner

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

AlwaysOn is the new High Availability technology suite for Microsoft SQL Server 2012 that allows for multiple HA and DR solutions along with hardware reuse and reporting scale-out.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
HSB 129B

Level: Advanced

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

During this session we will discuss the new features within SQL Server 2012. I will demonstrated some of the new Reporting features such as Power View and PowerPivot. I will also demonstrate Master Data Servcies and explain the importance of MDS within an organization. I will also explain the benefits of implementing SQL Server 2012 AlwaysON as well as other new components that exist.
Speaker:

Session Type:
Regular Session

Track:
HSB 129A

Level: Intermedia

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Take your relational data warehouse query performance all the way to ELEVEN!!  The Column Store Index is a new feature that allows for stunning performance.  We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
HSB 129D

Level: Intermedia

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

The breadth and depth of improvements in TSQL coming out with SQL Server 2012 represent the most significant changes in, well, probably ever!  This fast and furious overview will touch on a large range of these goodies, with plenty of sample code for you to take home and review at your leisure!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
HSB 129D

Level: Intermedia

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we cover backups and restores from beginning to end. Want to know how to do point-in-time restores? Don't understand what the different recovery models mean? How do you handle backups for different size databases? All of these questions and more will be answered in this session. 
Speaker:

Session Type:
Regular Session

Track:
HSB 129C

Level: Beginner

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

In today's economic times, we are being asked to do more with less. Less budget, less hardware and yet our data needs keep growing! So how do we keep our database infrastructure humming along given these restrictions? In this session we will talk about different options of consolidation including: database-level consolidation, instance-level consolidation, and virtualization. Additionally we will also talk about some of the tools and methods you can use today to help you consolidate your SQL Server environment and do more with less!
Speaker:

Session Type:
Regular Session

Track:
HSB 129D

Level: Beginner

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Management Studio can be really annoying sometimes.  Over the years a few really nice features have been added that you may have overlooked or just couldn’t find.  This session will focus some time saving tips and tricks for SSMS 2008 R2.  We’ll also cover a few great new features being introduced in SSMS 2012.  Since I can’t provide scripts for this session I guess I better get started working on some screen shots on where they hid all this stuff!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
HSB 129D

Level: Intermedia

Session Code:

Date: May 12

Time: 12:00 AM - 1:00 AM

Room: TBD

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