[tabby title=”Course Overview”] This online training event combines a thorough overview of key concepts followed by hands-on demos to reinforce each conceptual lesson. Since most technologists learn by doing, this training is designed to maximize the time attendees spend working with SQL Server. With ample demos, we’ll cover the spectrum of best practices as they relate to server and […]

  [tabby title=”Course Overview”] There comes a point in the career of most IT Professionals that advancement means taking on at least some degree of leadership in their organization. The only problem is that most IT pros built their career and earned all of their accolades on a set of technology skills that aren’t transferable into leading people and managing […]

  [tabby title=”Course Overview”] Kalen Delaney, course instructor and celebrated author of SQL Server 2012 Internals, will introduce you to the new features of SQL Server 2014 that every DBA should know about. The target of this class is administrators, developers or IT professionals who have experience with a recent version of SQL Server. Session Descriptions In this course you […]

  [tabby title=”Course Overview”] Kalen Delaney, course instructor and celebrated author of SQL Server 2012 Internals, will tell you all about how SQL Server 2014’s In-Memory OLTP works. In-Memory OLTP (Codename “Hekaton”) is a completely new way of managing your SQL Server data, allowing incredible performance improvements. You can choose some or all of your critical tables to be stored […]

  [tabby title=”Course Overview”] In SSWUG.ORG’s virtual class, you will learn how to manage and maintain your SQL Server transaction log, as the log is critical to optimizing operability and functionality. By the end of the six sessions, you will know why the transaction log is considered to be one of the most important components of a database, as it […]

  [tabby title=”Course Overview”] In SSWUG.ORG’s virtual class, you will learn about locking, blocking and row versions, which are some of the most important topics to understanding SQL Server’s internal behavior. By the end of the five sessions, you will know how these technologies are used to manage SQL Server concurrency – the ability of multiple users to access data […]

  [tabby title=”Course Overview”] 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 […]

  [tabby title=”Course Overview”] When working with SQL Server, as with any relational database, data is king. But data becomes less useful if you can’t gain access to it in a timely fashion. With so much data, being able to spread information across multiple servers allows for backup and quicker access. Replication is a technology available in SQL Server that […]

  [tabby title=”Course Overview”] As we build larger and more powerful data centric applications, the need to bring all this information together will become more and more important. Building efficient and intelligent ETL processes will be both a requirement and a skill that will be found to be in high demand. SQL Server Integration Services (SSIS) is one such ETL […]