Survey: what SQL Server build number are you running?

Time for another survey (I’ll editorialize the files/filegroups data from the last survey next week).

This survey’s very simple, run the following code on as many of your instances as you can, and post a comment with the results or send me plaintext/spreadsheet output in an email. Please do not add any more info to the results (like server name) as it’s not relevant for this survey and adds a bunch of time to the results processing.

[Edit 8/15/13: The survey’s closed now – thanks!]

SELECT @@VERSION AS [Version];
GO

 

Version
------------------------------------------------------------------------------------------
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)
	Jun 17 2011 00:54:03
	Copyright (c) Microsoft Corporation
	Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

I’ll editorialize the results in a couple of weeks.

Thanks!

New Immersion Event for Accidental/Involuntary/Junior DBAs

As I announced in our Insider newsletter last week, we’ve designed some new Immersion Events to expand the curriculum we offer.

We have a new Immersion Event for the Accidental DBA! This is a three-day class taught by Jonathan Kehayias and Erin Stellato.

This course will help you learn how to keep the lights on so that SQL Server meets the business requirements for availability and performance, and is especially suited to:

  • A server administrator that has to maintain SQL Server as a part of the infrastructure
  • An administrator for a line-of-business application such as SharePoint, Microsoft CRM, Great Plains, Dynamics, or Biztalk
  • An administrator for one or many non-Microsoft systems that rely on SQL Server
  • A junior DBA just getting started with SQL Server

The first public class will be offered in Bellevue, WA on September 30 – October 2, 2013 – which is co-located with a new Advanced Transact-SQL class that Bob will be teaching that week.

The class costs US$2,245, with an early-bird price of US$1,945 available until August 15th (all our classes have the same per-day cost, regardless of length).

The agenda for the course is:

  • Module 1: Hardware Considerations
  • Module 2: Installing and Configuring SQL Server
  • Module 3: Security
  • Module 4: Backup and Restore
  • Module 5: Disaster Recovery vs. High Availability
  • Module 6: Database Maintenance
  • Module 7: Monitoring

You can get class information, a detailed agenda, and registration information HERE.

It’s pretty cool to see how excited everyone on the team is about these new classes – we’re looking forward to giving you all the best value for your training budget!

See you there!

New Immersion Event on Advanced Transact-SQL

As I announced in our Insider newsletter last week, we’ve designed some new Immersion Events to expand the curriculum we offer.

We have a new Immersion Event on Advanced Transact-SQL! This is a four-day class taught by Bob Beauchemin, our resident developer expert.

The first public class will be offered in Bellevue, WA on September 30 – October 3, 2013 – which is co-located with a new class that Erin and Jon will be teaching that week (announcement tomorrow).

The class costs US$2,995, with an early-bird price of US$2,595 available until August 15th (all our classes have the same per-day cost, regardless of length).

The agenda for the course is:

  • Module 1: Data Types, Functions and Operators, and Scaling
  • Module 2: Writing Effective Queries
  • Module 3: Summarization and Analysis
  • Module 4: Optimizing Procedural Code – Stored Procedures
  • Module 5: Optimizing User-Defined Functions and Triggers
  • Module 6: Best practices with Action Statements
  • Module 7: Solving Difficult Problems in Relational Databases

You can get class information, a detailed agenda, and registration information HERE.

This is very exciting – we hope to see you there!