Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 25
Implimenting agility and leveraging tool to deliver cubes faster is the next generation for Data Warehousing initiatives.    I'll show you how to generate C# applications for SSIS And Cubes, impliment a tool for generating the SSIS, Dimensional structures, and building the cubes.  

This is just the start because I'll be interjecting how to Model Data Warehouses for major companies and how your company needs to do it.  You don't get hired for knowing Kimball and Inmon anymore.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Does your data sit around mocking your best attempts to support good data practices?  Databases are also bound by the GIGO rule: Garbage In is Garbage Out.  In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions.  Using real-life evidence of her own data in your systems.
Speaker:

Session Type:
Regular Session

Track:
Wild Card

Level: Beginner

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Chris Hyde has been working with the Microsoft SQL Server stack for over twelve years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000.  He is a Senior Consultant with maxIT-VCS, a subsidiary of SAIC that specializes in healthcare IT consulting for the healthcare market, which he particularly enjoys as he gets to tackle different types of SQL problems at each client.  He has been previously employed at ABQ Health Partners, Thornburg Mortgage, and Presbyterian Health Services.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Prof Dev

Level: Beginner

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance.  I have given this talk over FORTY times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session

Track:
Developer

Level: Intermedia

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Sure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? In an emergency, can you objectively demonstrate where a performance problem lies? This dynamic dialog session will present a solid process for checking your environment's overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

There are four basic tasks every DBA should know how to do. They are, in this order: Restore, Backup, Index and Stats maintenance, and Consistency Checking. After this session, beginning and "involuntary" DBAs will know the basic ins and outs of each of these four critical tasks, as well as how to set up recurring  maintenance on their servers, and handle some of the common issues these tasks present
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

With the release of SQL 2012, Analysis Services (SSAS) has seen some major changes.  An entire new method of modelling analytic data has emerged and it's called Tabular Mode Analysis Services.  In addition to that, a new semantic layer has been added to the tool, the Business Intelligence Semantic Model (BISM), which will help to bring the two modes -- Multidimensional and Tabular -- into one level playing arena.

In this session, attendees will gain understanding of what Multidimensional and Tabular modelling IS, as well as how the BISM layer helps to translate user requests to ensure no confusion is made. Attendees will also learn how to BUILD a Tabular model, and will help design a solution live during the presentation. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Every SQL developer or DBA should have a fully stocked toolbox that they can turn to in times of need. SQL Server enjoys a wide variety of support from 3rd party vendors that provide tools to help us peek under the hood and pinpoint issues. Sometimes we either don't have the budget for everything we would like, or we need something for a one-off project. In this session we will examine some of the free tools published by members of the SQL community and 3rd party vendors. 
Speaker:

Session Type:
Regular Session

Track:
Prof Dev

Level: Beginner

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Tired of clicking through all those setup screens and entering the same information over and over again? I know I am, so I'm doing something about it...I'm automating my installs!  From base SQL Server installs to Service Packs, Cumulative Updates and even Client Tools for DBA's and Developers, I'll show you ways to automate your installs using SQL Server FineBuild (CodePlex Project).  We'll cover many of the scenarios you may encounter and you'll walk away with some pre-built install scripts to help get you started.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

The best defense is a good offence. Learn how to practice hacking without going to jail or getting fired. In this presentation we'll be going over how to exploit weak SQL servers with actual tools of the penetration testing trade. You will learn why the SQL Service is a popular target on your network and how to defend against basic attacks.  We will also attempt to snag some credentials from the SAM cache so we can go galavanting across the rest of the network. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Wild Card

Level: Intermedia

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Hierarchical data sets are everywhere. If you haven't worked with one yet, you will. If you're already working with them, you know they can be horribly complex, slow performing, difficult to maintain resource hogs that can really take the steam out of any GUI or batch process. This simple but code intensive "black arts" session shows you how to quickly and easily get around all of that using all 3 common hierarchical structures and a new structure that just might make Nested Sets obsolete. For stalwarts, it also includes a very high performance method (100,000 nodes in 6 seconds) for converting Adjacency Lists to Nested Sets that even a beginner can understand.  You just have to know that a Tally Table is involved somewhere in this. ;-)
Speaker:

Session Type:
Regular Session

Track:
Developer

Level: Intermedia

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will review some example code of ways I use PowerShell to help me as a DBA.  Bring your questions and we will work together see how PowerShell can be the "Super Glue" that can be used to solve some of your problems.
Speaker:

Session Type:
Regular Session

Track:
Wild Card

Level: Beginner

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Introduction to spatial features in SQL Server: how to create, procure, integrate and leverage spatial data.
Demo using SQL Server 2008 R2.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

This session provides a technical overview of Hadoop and HD Insight targeted for Microsoft DW/BI professionals.  Emphasis will be on how Map/Reduce paradigms complement and extend BI architectures. Specifically highlighted will be the Hadoop ecosystem, HDFS, Cloud vs. On-Premise, and various strategies to integrate SQL and NoSQL technologies into cohesive solutions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever thought about speaking at a user group or SQL Saturday, but weren't quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and build a killer abstract for it, * Design and build the presentation, and * Prepare and deliver your first session
Speaker:

Session Type:
Regular Session

Track:
Prof Dev

Level: Beginner

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

LinkedIn is more than an online resume! The platform is chock full of useful features for networking, relationship building, and job searching. Think of it as your professional online image. LinkedIn is rapidly becoming the de facto platform for business networking. There are many powerful, advanced features that most people don’t know how to use or even exist. It is also an online communication platform, professional networking portal, and contacts database. Takeaways include: how to optimize and polish your profile, how to get your profile to 100%, quality vs. quantity networking strategies, selecting of and the correct use of LinkedIn groups   
Speaker:

Session Type:
Regular Session

Track:
Prof Dev

Level: Beginner

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

The expression language in SQL Server Integration Services is rich, and there are many locations within a package where the expression language can be used to make packages more dynamic. Within Derived Column transformations, Precedence Constraint evaluation, Script Tasks, Connection Managers, Containers and more, expressions and variables can be used to increase the flexibility of an SSIS package. Remember, “Write once, run many!”
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

You have more and more servers to manage and less time to accomplish everything. You're writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously.  In this session we'll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.
Speaker:

Session Type:
Regular Session

Track:
Wild Card

Level: Intermedia

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning seamlessly solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours?  Come see what partitioning can provide for you.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever thought about trying your hand at blogging?  Or maybe you've started a blog but struggle with what to write about.  We'll take a beginner's look at blogging and examine common roadblocks, finding topics, building readership, and setting you on the road to blogging stardom.
Speaker:

Session Type:
Regular Session

Track:
Prof Dev

Level: Beginner

Session Code:

Date: March 16

Time: 12:00 AM - 1:00 AM

Room: TBD

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