Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 35
You've always wanted to get promoted into the DBA position. The good news is you got it - the bad news is you have no idea what to do first. What's important, what's not a big deal, and what can get you fired if you're not careful? If your answer wasn’t, “update my resume”, then this session is a good start. We’ll chat about a natural priority for the overwhelming flood waiting in our offices. By focusing on a few words ending in “ity” we’ll realize what is most important. Through the interaction, stories and examples you’ll leave feeling ready to attack your environment. Be warned – along the way to knowing where to start, you may get that feeling in your stomach that makes you log on to the VPN to check a few things out.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
S212

Level: Beginner

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

While SQL Server Standard Edition ships without several advanced enterprise features, it nonetheless can be used as a cost-effective data platform for many Big Data OLTP applications.  This talk will highlight what exactly SQL Standard Edition is, discuss the scale-up vs. scale-out debate, dive into techniques for ordering, splitting and joining very large tables, and present a case study.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
S214

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Fat!  That’s how you’d have to describe most databases these days.  Add up all the costs and each Terabyte ends up costing as much as $75,000.  The Biggest Looser: Database Edition presentation shows you how to put your database on a diet using the features of SQL Server:
Compression, Filtered indexes, Sparse Columns, Maintenance, REBUILD and REORGANIZE, Index management and Application Changes.  

Topics include 
- Calculating storage for each row and measuring the actual storage.
- Finding hidden overhead such as Snapshot Isolation bytes
- How to recover extra space
- Why NOT to SHRINK your database files
- Rebuilding files to recover all the extra space

Managing your data well can lead to savings in disk space as much as 75%.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
S212

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server MVP Jeff Moden demonstrates and explains simple methods for converting gobs of “vertical data” into horizontal numeric and textual data by date or other key using Cross Tabs and Pivots.  This session includes the “Black Arts” method of “Pre-Aggregation” for incredibly high performance and how to dynamically and automatically produce reports based on a date.  The methods learned in this session can be used to provide “dynamically pivoted” result sets to SSRS, Crystal Reports, and other reporting software. Don’t let the “Intermediate” rating scare you “Beginners” away.  This “Black Arts” session is for anyone that uses T-SQL.   
Speaker:

Session Type:
Regular Session

Track:
S213

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Deploying application code is easy, at least in theory: in a word, xcopy.But you can't exactly do that with databases. First and foremost, databases can only be changed through a script, and if you run a database change script that drops a column, there's no way you can bring that column (and especially its data) back without a restore… and that in and of itself is a whole mess.In this talk, we'll discuss best practices (and a few worst practices) in database change deployment, including change scripts vs. object scripts; source control and SQL; synching tools like Redgate SQL Compare and Visual Studio Database Projects; keeping track of changes; and efficient deployment and change management practices.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
S212

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Transform traditional database development by using SQL Server Data Tools - a declarative, model-based experience that supports both online and offline (project-based) database development.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
S213

Level: Beginner

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

As DBAs we are often stuck at the mercy of higher ups and Project Managers for completion of our assigned tasks/ projects.
In this session we wil actually take an arbitrary application and its affiliated databases and go throught the tasks/resources needed to accomplish the task. We will think and act like a Project Manager and DBA rolled into one. This will surely help you advance your career within organization and help you think ahead of time.
Speaker:

Session Type:
Regular Session

Track:
S216

Level: Advanced

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever received a call from a client asking for help when their SQL Server database is corrupted?  You suggest that they restore the database from the last good backup.  There is a long pause on the phone as the client states that the only backups/tapes they have are bad.  Do not let this situation happen to you!  

I will review how to build a custom maintenance plans from the ground up using TSQL commands.  What are the best practices for daily, weekly and monthly tasks?  This presentation includes tape rotation schemes and restoring those backups to make sure they really work.  If you company has the budget, use disk to disk backups to reduce the backup/restore times. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
S214

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Today's large data fields (LDF) are full of unstructured information stored in varchar, text, varbinary or xml data types.  How do you write an application to search the column for patterns?  Traditional SQL techniques using a column INDEX and LIKE operator result in a query plan that contains a full table scan.  I will be introducing the brother's grimm database that has the full text of each fairy tale.  I will create a full text catalog / index, select a change tracking strategy, define optional stop list / thesaurus file, and then populate the index.  I will use CONTAINS and FREETEXT operators in SELECT queries to leverage the FTI.  This resulting query plan performs index seek. 
Speaker:

Session Type:
Regular Session

Track:
S216

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012: Over the past 18 months many financial and portfolio management firms have been severely ‘hit’ by the depressed markets and poor economic conditions.This lead to risk exposure and considerable client liability.We like many firms have gone through the 'teething process'with regards to data mining model predictions and have now taken our systems from the prototype stage to our “shop floor” and are getting the 'good word' out to management via SQL Server Reporting Services .
Speaker:

Session Type:
Regular Session

Track:
MPT

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
S213

Level: Beginner

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

What does a plane crash have to do with technical skills? You might be surprised. There are many lessons to be learned from disasters. Most accidents are caused not by one factor, but by a series of seemingly-small missteps; It’s the same for us. Even if a freak accident occurs, training and preparation can make all the difference; it's the same for us. In this session we’ll discuss as a group some real-life disasters and see what skills, attitudes and thought processes we can take back to our day jobs. We'll look at a handful of aviation disasters and look for patterns of behavior at fault or that saved the day. Hopefully you'll leave looking for those behaviors in yourself and on your project teams. Fasten your seatbelt!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
S212

Level: Beginner

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Provision, Create, Maintain and use SQL Azure Databases
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
MPT

Level: Beginner

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft SQL Server 2012 Power View provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from tabular models based on PowerPivot workbooks published in a PowerPivot Gallery, or tabular models deployed to Analysis Services (SSAS). Power View is a browser-based Silverlight application launched from SharePoint Server 2010. In this session I will give you an overview of the key features of Power View and then I will develop some of these views and export them to interactive PowerPoint slides.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
S214

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will review some of the do's and don'ts of using SSIS when loading your datawarehouse.  We will also review some of the new features of SQL 2012.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
S214

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

As IT personnel, we tend to get boxed-in, stranded on our own little island. We fail to make people aware of our activities, both within our own organization and in our wider professional circles. Just like a shipwrecked captain waiting for the rescue boat on a desert island, if you fail to communicate, your career will be stuck with no possibility of progression. This presentation will show you how to leverage networking and self-marketing techniques that will allow you to set sail off the island and into new opportunities. 

Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
MPT

Level: Advanced

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

"We need a new server before you leave on vacation!" Never mind that it's Friday at 2:00 PM and you need to be in the airport in a couple of hours. This isn't the time to panic. Mike Hillwig deploys new servers every week and has a streamlined process that allows him to deploy a new server in an hour from delivery of the Windows server. We're not talking just installing SQL Server. This is having the new server production-ready in an hour, including scripts to backup, monitor, and maintain databases. With a little bit of advanced planning, following a few simple rules, and some scripting, you can be ready for just such an emergency. And you'll still catch you flight!
Speaker:

Session Type:
Regular Session

Track:
S214

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

A Dynamic Dialog session: Whether you’re considering implementing business intelligence for the first time, have completed projects in the past (and are perhaps looking at later phases), or are somewhere in between, an investment in this session will likely pay dividends. Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog about common pitfalls or traps that we can encounter in designing and implementing BI. We’ll discuss, as a group, environmental and other challenges we have experienced, and share ways to avoid or minimize them, in our ongoing efforts with BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
S213

Level: Beginner

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you found yourself tasked with managing settings and environment definitions across a large pool of SQL Server 2008 servers and felt overwhelmed with where to start? Do changes in your environment go unnoticed and have a ripple effect within your application stack? Do you find developers and others not following standards time and time again even with the best process definitions and promises in place? Then you will benefit from understanding a powerful feature tucked neatly within SQL Server 2008; Policy Based Management. I will provide a clean overview of this management tool along with some demonstrations that help explain its usage in action.
Speaker:

Session Type:
Regular Session

Track:
MPT

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

As a DBA in the modern era, you may be required from time to time to do something outside of your comfort zone.  One of these things may be to become quickly acquainted with SSRS.  Even better is that you may be required to do things you have not considered in a standard report.  In this session, you will learn how to implement a framework to help provide a common ground for your reports.  This session will delve into fun topics such as dynamic grouping and dynamic sorting.  We are not talking about the interactive sorting that your accountant may use.  Attendees will also be introduced to a few quick methods of exporting Reports from the report server - this is from a DBA perspective after-all!
Speaker:

Session Type:
Regular Session

Track:
S216

Level: Intermedia

Session Code:

Date: September 15

Time: 12:00 AM - 1:00 AM

Room: TBD

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