Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 34
Are all your databases backed up?  Has SQL reported any errors? Are there critical Windows or SQL patches you need to apply?  Are all of your SQL Servers configured to Microsoft "Best Practices"?  This sessions shows how Microsoft Atlanta Tool can be used to provide the CIO or DBA an "extra set of eyes" to check the health of your SQL Severs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Performance/Monitoring

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS/ETL

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

The Dynamic Management Objects--a set of views and functions that first shipped with SQL Server 2005--are a window into the inner workings of your SQL Server instance. Locked within is the data you need to help solve virtually any performance problem, quickly debug issues, and gain insight into what's actually happening on your server, right now. This session is a fast-paced tour of the ins, outs, whys, hows, and even pitfalls of 15 of the most important views and functions--information gleaned from heavy use of the objects in a number of environments. You will learn how to understand transaction behavior, locking, wait statistics, sessions, requests, and much more. Attend this session and you will be the master of your SQL Server instance.
Speaker:

Session Type:
Regular Session

Track:
Performance/Monitoring

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

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:
BI

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Data Masking is the act of replacing sensitive data with fictitious but realistic data in order to eliminate the risk of exposure to unauthorized parties.     Implementing a sustainable data masking program in a modern enterprise environment can be surprisingly challenging—not just technically and organizationally, but culturally.     The reactions and concerns you’ll encounter from your development and QA teams are understandable. You’re not just introducing new controls over confidentiality exposures in development and testing systems. You’re shutting off developers’ and testers’ unfettered access to live customer Production data—something that’s been quite normal and convenient for them to date, something they think they just can’t do th
Speaker:

Session Type:
Regular Session

Track:
Data Development

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Interested in high availability, but don't know where to start? This session will start at the ground level and work through all the requirements of building a SQL Cluster environment, including Windows steps, storage steps, and networking needs. Of course, SQL Server will be included in this process.
Speaker:

Session Type:
Regular Session

Track:
Infrastructure

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether you are seeking a new position or working to increase your knowledge-base, career development is a hot topic in the greater Boston area.  This session will address tips and tactics that successful SQL professionals are utilizing to further their career and increase their income potential.  Jason Alexander is the Managing Partner of Alexander Technology Group, a full service consulting and staffing firm focused exclusively on the greater Boston marketplace.  Jason also serves on multiple area boards of directors including the Massachusetts and New Hampshire High Technology Councils and speaks frequently on the topic of career development at area colleges and outplacement events.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Future Directions

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Consolidating SQL Server Instances can be daunting. Virtualizing SQL Server instances can be intimidating. Doing both at the same time can be absolutely frightening. 

When Mike Hillwig inherited his SQL environment, he had 14 SQL Server instances, running five different versions of SQL, all using local disk. In one project, his team consolidated this down to four servers. And the entire environment is virtual. In this session, MIke will share what they did, how they did it, what worked, and what didn't work so well. 
Speaker:

Session Type:
Regular Session

Track:
Infrastructure

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Recently I have had a client that required migrating and re hosting a data warehouse from the Oracle environment to the Netezza Appliance. The application had hundreds of tables and almost 2900 Source to Target Mappings. This would have taken 1000's of hours of manual coding. For this client we implemented a reusable data driven architecture, via SSIS, that rely on a metadata mart. The end result a greatly reduced TCO(development effort) for generating the code required vs manual coding. In addition the process leaves behind a metadata mart to report on for auditing and other Data Governance efforts. We generated over 100,000 lines of code and over 3000 load scripts. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS/ETL

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Varchar(1) and other Varying datatypes * Identity Properties * Naming Standards - Who needs them? * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Data Development

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Efficient and effective database design is so important that  leaving it solely to the DBAs is simply not a solution. We as developers will more than likely have to create applications to access the data stores and as such must ensure that all application related considerations are taken into account within the database design.
In this session, (aimed at software developers) we shall be touching upon several concepts of special importance to the developer. These include database development "patterns and anti-patterns",  final proofing of design and creating versatile deployment scripts that can and will be utilized in future endeavors.
Speaker:

Session Type:
Regular Session

Track:
Data Development

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

A review of Database Mirroring in the context of operations at Baker Hostetler, where mirroring has been a cornerstone high availability tool for over 5 years. A high level look at the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a rolling upgrades or to move large databases to a different location.
Speaker:

Session Type:
Regular Session

Track:
Infrastructure

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

We will discuss the “how to’s” of column encryption from the perspective of the DBA, Performance Analyst, Application Architect, and Programmer. We will actually encrypt the “NationalIDNumber” column of the Personel.Employee table in AdventureWorks – and subsequently the entire AdventureWorks database.   I will contrast column encryption with Transparent Data Encryption (TDE).  We will also briefly discuss business role changes necessary to support encryption and subsequently DR. 
Speaker:

Session Type:
Regular Session

Track:
Data Development

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem.  We don't always know how to do this easily and consistently.  This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Performance/Monitoring

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Performance-driven SSIS ETL solutions require a mix of both SQL and SSIS developer optimizations. In this session attendees will learn SQL code and SSIS data flow optimizations, tips and best practices that are specifically geared to obtain the best performance from your enterprise ETL solution. This session demonstrates high-speed ETL techniques using dimensional datamarts, but much of the information presented can be applied to any SSIS solution.
Speaker:

Session Type:
Regular Session

Track:
SSIS/ETL

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will give a brief overview of the different types of triggers available in SQL Server (DDL & DML) and then go into more detail on how and when to use DML triggers. This session will cover misconceptions about how triggers work, when triggers should and shouldn't be used (we will discuss options), common mistakes, and how to fix the most common mistakes. After attending this session a person will: 1. Identify different types of triggers and when to use them. 2. Be able to identify when a trigger is the right solution 3. Be able to write triggers that perform well 
Speaker:

Session Type:
Regular Session

Track:
Future Directions

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

PerformancePoint is now part of SharePoint 2010. You can now get a complete view of your business data using SharePoint and Analysis Services Cubes. How do you create interactive and context driven dashboards? In this session I will demo how you can go about doing this. 
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

The Cloud is fast becoming the latest hot topic in the technology arena. We need to understand how we as SQL Developers and Administrators can utilize SQL Azure, Microsoft’s platform for relational data storage in the Cloud, to meet our needs. This talk will be a step-by-step demo of how to obtain an Azure subscription, create and administer a SQL Azure database, and work with it from your own SQL Server Management Studio AddIn. You’ll find that Azure is so easy to work with, you’ll get two for the price of one in this talk: you’ll learn Azure and learn how to create a Management Studio AddIn!
Speaker:

Session Type:
Regular Session

Track:
Future Directions

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

If you want to get the most out of your Analysis Services cube it’s essential to know and understand MDX: you need to be able to write MDX queries and calculations. MDX is part of the underlying foundation for the SSAS (OLAP architecture), and it offers detailed and efficient navigation and drill across of multidimensional data. MDX is designed to ease the process of accessing data from multiple dimensions
This session aimed at those with little or no previous MDX experience will teach you the basic concepts of the language as well as show you how to write common queries and calculations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Service Broker was introduced in SQL Server 2005 to provide asyncronous messaging in your database applications, but it's seldom used because it isn't well understood.  In this session we'll walk you through the basics of Service Broker and show how you can use it to build highly scalable applications.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Future Directions

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

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