[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”] In 2005 Microsoft introduced SQL Server Integration Services, SSIS, as their primary ETL (Extract, Transform, and Load) tool. SSIS fully integrates with the Common Language Runtime, CLR, and provides a platform for building enterprise-level data integration and data transformations solutions. Integration Services includes a number of built-in tasks and transformations as well as tools for constructing […]

  [tabby title=”Course Overview”] This course is designed for software developers, architects and their managers who specify, design, code, assemble, test, deploy, support, update and live with business applications that manage SQL Server data or develop Business Intelligence solutions targeting Reporting Services [tabby title=”Sessions”] Session 1 – SQL Foundations –  1. Understanding the SQL Server service 2. Understanding the Query Optimizer 3. Understanding the […]

  [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”] This series of courses is designed to provide the foundations for developers or para-developers in SQL Server, SQL and Reporting technologies. [tabby title=”Sessions”] Session 1 – Database Foundations –  1. Understanding Databases and DBMSs 2. Understanding Relational Databases, Objects and Constraints 3. Understanding Normalization, Relationships and Indexes 4. Using the Database Explorer and SSMS to Create a Database 5. Understanding Login IDs […]