Home > Blogs > SQL Server 101 Back to Basics at SQL Bits

SQL Server 101 Back to Basics at SQL Bits

By  Sep 7, 2010

Topics: SQL Server, Data

I’m traveling to the United Kingdom (York, England, to be specific) in September, joining Brent Ozar, Brad McGehee, Kevin Kline, Simon Sabin – and a host of other top-notch speakers. They will be covering deep technical topics ranging from server health checks to SANs and Virtualization. So what will I be talking about? SQL Server 101.


Every time I attend a conference like this, I’m amazed at the depth of technical information you can learn about. And for those of us who make a living at SQL Server, they are a great bargain – you get a “knowledge accelerator” that helps you do your job.

But there’s a segment of folks that don’t always get served at these events. There are lots of technical professionals that work as system administrators, developers, or all-around technical professionals that have been asked to manage a SQL Server system. And there’s also a segment of technical folks that want to learn to be a data professional, but don’t know exactly where to start.


I’m giving a one-day session on Thursday, September 30th at SQL Bits called “SQL Server for the Technical Professional”. It’s an intense, one-day immersion into the world of SQL Server, and will give you a hands-on, lab-style class that takes a technical professional from zero to sixty (kilometers per hour) on SQL Server. You’ll take this concrete information with you:

• SQL Server Architecture

• Server and Database Components

• Tools and utilities for working with SQL Server

• Designing a simple database project

• The Basics of Transact-SQL

• A security primer

• Maintenance and Monitoring basics


During the session, you’ll create a full database project that encompasses all of these concepts.


I’m sure that the folks that read this blog already have a lot of this information – but you probably know a technical professional who has to manage a SQL Server, or who wants to become a  data professional. If they know what a Windows Service is, then they’re ready to come. Just have them bring a laptop and tell them to be ready to learn:


I’m also speaking to the SQL Server professionals as well – on Friday the 1st of September I’ll show you how to create a Business Continuity Plan, and on Saturday we’re planning on a panel discussion on the DBA career – something you don’t want to miss! It’s cheaper than the college course I teach, and for many other conferences and training events. For £450, you get this pre-conference session on Thursday plus full days of training on Friday and Saturday.


Sign up here: http://sqlbits.com/information/Event7/SQL_Server_for_the_Non_DBA/TrainingDetails.aspx

Full conference agenda is here: http://sqlbits.com/information/Agenda.aspx

Become an InformIT Member

Take advantage of special member promotions, everyday discounts, quick access to saved content, and more! Join Today.