Online Course: SQL Query Processing & Optimization
In SSWUG.ORG’s virtual class, conducted by Microsoft SQL Server MVP Kalen Delaney, you will be able to explore needed information about query plans, basic index structures and plan cache management.
As Kalen is a foremost authority on SQL Server query processing and optimization, this comprehensive class offering will bring you key information to apply to any work with SQL Server.
|
Event
|
2/7/2012
|
Webcast: Building Your First SQL Server Cluster
This session will focus on the hardware and software involved in building a SQL Server cluster on Windows Server 2008 R2.
Joey D'Antoni, who is a senior database administrator with Comcast and author for SSWUG.ORG, will go through the architecture, discuss potential pitfalls and talk about considerations that need to be made for clustered environments. Lastly, he will discuss briefly some of the big changes that are coming to this space with SQL Server 2012/"Denali".
|
Event
|
2/8/2012
|
Online Course: Introduction to SSAS
In a partnership agreement with Pragmatic Works, SSWUG.ORG’s virtual class will provide you with the skills to properly use SQL Server Analysis Services (SSAS) 2008 in your enterprise.
Brian Knight, course instructor and SQL Server MVP, will take you from the ground-up, teaching you the fundamental skills you need to develop and deploy SSAS solutions and present this new data to your end users. This class is presented in SQL Server 2008, but is appropriate for those using SQL 2005 as well.
The target audiences for this class are developers, architects or IT professionals who have basic SQL skills already. This class assumes that you have no previous knowledge of OLAP or Analysis Services. Technical knowledge of basic database design concepts is assumed. It is required that you already know how to navigate around SQL Server 2005/2008 and how to query a SQL Server.
|
Event
|
2/14/2012
|
Webcast: The Four-Hour DBA
Do you feel that you are overworked, always fighting fires and never can get ahead?
Sarah Barela, Manager of Database Services for Cbeyond Cloud Services, will help you identify what is important to your job and how to find the time to address those critical tasks. She will share scripts to automate those tasks that are central to all DBAs and discuss how to establish a methodology to quickly automate daily database chores.
The flip side of automation is auditing. Routinely auditing your server is essential to avoid nasty surprises that can lead to a loss of control. Sarah will show you how to create an auditing system using features within SQL Server, including Policy Based Management and scripts that will provide you peace of mind to enjoy your work and maybe even life beyond the office.
|
Event
|
2/15/2012
|
Free Expo: Database Security Countermeasures
SSWUG.ORG’s free virtual expo will review ways for information technology (IT) professionals who work with enterprise environments to design and monitor security for database systems.
Through our in-depth sessions with some of the leading functional specialists in the IT field, you will see many examples and case studies on understanding database forensics, encrypting data, preventing SQL injection hacks and more.
By the end of our free event, you should have the tools and understanding needed to develop database security solutions for protecting business-critical databases.
|
Event
|
2/17/2012
|
Online Course: T-SQL Querying Fundamentals
In a partnership agreement with SolidQ, SSWUG.ORG's virtual class will provide you with the skills to work with SQL Server and write queries using Transact-SQL (T-SQL) — SQL Server’s dialect of the standard SQL language.
Itzik Ben-Gan, who is a SQL Server MVP and the acclaimed author of several books on T-SQL querying and programming, will help students understand the logic behind T-SQL and thinking in terms of sets. He will also explain how to write T-SQL code to create tables and define data integrity, as well as how to write queries against single and multiple tables, and how to write T-SQL statements that modify data.
|
Event
|
2/21/2012
|
In-Person Training: Enterprise ETL with SSIS
In a partnership agreement between SSWUG.ORG and SolidQ, a four-day, in-person class with hands-on labs on SQL Server Integration Services 2008 (SSIS) and applying its enterprise functionality to data warehouse ETL systems will be offered on March 6-9 in Denver, Colorado for students with no prior experience with SQL Server DTS or SSIS.
Chris Randall, course instructor and mentor for SolidQ USA, will focus on the design, development, deployment and operation of SSIS solutions. This will cover source systems extractions, data integration and transformation, as well as business intelligence system loading such as processing SQL Server Analysis Services (SSAS) cubes. Chris will also demonstrate a fully working ETL solution, including extensive demos, sample projects that will not only teach how to use the new technology, but also illustrate business intelligence ETL and data warehouse best practices.
|
Event
|
3/6/2012
|
