SQL Server 2012 & SharePoint Connections to be Held in Kongresshaus Berchtesgaden in May

Red Gate Software and SQLServerCentral.com will be one of the sponsors for the upcoming SQL Server 2012 & SharePoint Connections to be held in Kongresshaus Berchtesgaden, Germany, May 8-9, 2012.

The SQL Server 2012 and SharePoint Connections conference agenda brings  together more than 40 top-ranking experts from Microsoft, along with leading independent presenters to deliver in-depth sessions on how to succeed with SharePoint and SQL Server based on real life production deployments with the latest hot news from Microsoft’s biggest launch this year for SQL Server 2012.

The event will include a SQLServerCentral.com track consisting of six sessions from two SQL Server MVPs that I selected to participate in the track: Constantin Klein and Satya Jayanty. Their sessions include:

Constantin Klein

  • New T-SQL Features in SQL Server 2012
  • SQL Server for Developers
  • Fun Managing Documents with SQL Server

Satya Jayanty

  • Upgrading SQL Server: Tools and Best Practices
  • DMVs – Best of the Bunch. Troubleshoot Your Data Platform Like a Pro
  • SQL Server High Availability Concepts and Solution Guidance: 2008 R2 & 2012

PASS SQLRally Dallas 2012 Pre-Con: How to Perform a SQL Server Health Check

If you are attending the PASS SQLRally this May in Dallas, I will be presenting a one day preconference session called “How to Perform a SQL Server Health Check”. Here’s the abstract for the session:

Are all the SQL Server instances you manage healthy, running optimally, and providing the high availability your organization expects of them? If you don’t know, or if you have inherited, or are consulting with some SQL Server instances you are not familiar with, then you need to perform a SQL Server Health Check in order to find out.

Think of a SQL Server health check similarly to a health check with your physician. On your visit, the doctor will record your basic stats, take a medical history, and perform a number of tests. In many ways, what the doctor does is to document your health, and then compares what he finds to medical health best practices, to determine your current health. The next year at your annual check-up, the doctor will examine your again and then compare it to the baseline from the initial checkup. This helps the doctor determine if your health is the same, getting better, or getting worse. A SQL Server health check is very similar.

In this day-long session, you will learn how to document your SQL Server instances and how to determine if your instances are employing generally accepted best practices. Based on this information, you will be able to conclude if your instances are healthy, which means that they are running optimally and providing the level of high availability your organization expects of them. If not, you will learn how to fix any problems you find.

More specifically, you will learn about how to document your instances, and learn best practices in all of the following areas: Hardware Setup & Configuration, Operating System Setup & Configuration, SQL Server Instance Level Settings, Database Level Settings, Security Settings, Database Maintenance, SQL Server Jobs, Logs to Monitor and Review, SQL Server Monitoring, Performance Optimization, and High Availability. In many ways, this session will bring together all the best practices every DBA should know about administering a SQL Server instance.

This session will cover hundreds of health checklist items and their best practices. To help you keep track of all this information, you will be provided with scripts to collect the data, and a spreadsheet in order to collect and analyze the data.

This session is designed for database administrators from novice to intermediate level. After attending this session, attendees will be able to go back to their organizations and begin to immediately perform their own SQL Server health checks.

For more information on the event, visit the PASS SQLRally website.

Interview with BI Expert Tim Mitchell

Tim Mitchell will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas, NV.


tim mitchellTell us about yourself.

I’m a practitioner of business intelligence, primarily focusing on SQL Server. I’ve been in the IT field for over a decade, and have worked with SQL Server in various capacities for about 8 years. By day, I work as a BI consultant. I’m proud to be a part of Artis Consulting in Dallas, where I help deliver BI solutions across the entire SQL Server stack. During my spare time, I serve on the board of directors for the North Texas SQL Server User Group in Dallas (Irving), and I blog and speak at community events as much as I am able.

Continue reading

Interview with SQL Server MVP Grant Fritchey

Grant Fritchey will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas, NV.


Grant Fritchey

Tell us about yourself.

I have twenty plus years’ experience in IT, in the areas of technical support, development, and database administration. Currently, I work for Red Gate Software as a Product Evangelist, where I spend a lot of time speaking, and writing articles for SQLServerCentral.com and Simple-Talk.com. I’m one of the founding officers of the Southern New England SQL Server Users Group and I am its current president. I’ve been involved with the SQL Server community since the 2005 PASS Summit when I saw people having a good time while they were learning. I’ve also been a Microsoft SQL Server MVP since 2009.

Continue reading

Interview with SQLServerCentral.com Editor Steve Jones

Steve Jones will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas, NV.


Steve Jones

Tell us about yourself.

I’m the editor of SQLServerCentral.com, which is a position I’ve held for over 8 years. I started writing articles as a DBA to help other people and to share the knowledge I’d been given by so many other great authors over the years, and it has turned into an amazing job. Prior to that, I was a DBA for almost a decade, working with SQL Server v4.2, 6.5, 7.0, and 2000. I am a Microsoft MVP and enjoy working with data, mostly from the administration and management side of the DBA job.

Continue reading

devLINK Technical Conference to be Held in Chattanooga, TN, August 17-19

imageThis year’s devLINK Technical Conference will be held at the Chattanooga Convention Center, Chattanooga, TN this upcoming August 17-19, 2011. This three day event includes over 120 sessions, costs only $100, the least expensive full conference you can attend anywhere. While the conference is developer-oriented, it still offers plenty of SQL Server sessions.

I will be presenting a session on “Inside the SQL Server Transaction Log”. Other SQL Server speakers include Joe Webb, Robert Cain, David Buckingham, and Jeremiah Peschka.