Essential Guide

Microsoft SQL Server training: What you need to know

Refresh basic skills and explore new trends to rev up your Microsoft SQL Server training. Whether you are a database administrator or not, the articles in this guide will point you in the right direction.

Introduction

All users who interact with the SQL Server database can benefit from improving their knowledge through ongoing training. Database administrators, "reluctant" DBAs and professionals in other areas can enhance performance and productivity by revisiting the basics and exploring new capabilities of SQL Server.

Several resources are available, including SQLSaturday events. Professionals need to assess when it's time to earn certifications and which aspects of SQL Server training are necessary. Learn more about these topics as well as an insider's look at what to expect from the SQL Server 2014 release in this guide.

This essential guide offers basic information on the SQL Server database, expert advice for keeping your skill set up to date and news about the latest SQL Server technology trends.

1SQL Server basics-

Basics and benefits of SQL Server training

Database administrators, "reluctant" DBAs and non-DBAs all have the need to improve their knowledge of SQL Server. The articles in this section offer resources and advice so that all types of users can benefit from SQL Server fundamentals.

Tip

Non-DBAs benefit from SQL Server training

Read this tip for information on how SQL Server training benefits users other than database administrators. Continue Reading

Tip

Helpful SQL Server resources for reluctant DBAs

Expert Don Jones points reluctant DBAs in the right direction for SQL Server resources in this tip. Continue Reading

Feature

SQL Server professionals come together for SQLSaturday

SQL Server pros have a chance to network and gain expert advice and training at one-day SQLSaturday events. Continue Reading

Tip

The basics of SQL Server: How does it really work?

This article offers the disoriented DBA an explanation on how data moves from disk to memory in Microsoft SQL Server. Continue Reading

Feature

Checklist: Step by step SQL Server performance tuning

The steps outlined here provide a talented team with an easy reference for measuring and tweaking SQL Server performance. Continue Reading

2Expert insights-

Trends, perspectives and advice on enhancing SQL Server skills

Microsoft database professionals and developers looking to update their skill sets or for some refreshers will find expert advice in the articles here. This section also explores certification information and common server performance errors to avoid.

Feature

Expert highlights Microsoft SQL Server trends

Expert SQL Server manager Denny Cherry discusses Microsoft SQL Server trends of 2013. Continue Reading

Tip

Ways that application developers unwittingly hurt performance

Learn how SQL Server developers can prevent eight common server performance errors. Continue Reading

News

SQL Server certification: Is it worth it?

Database professionals who are not sure what to pursue will find information about Microsoft certifications in this article. Continue Reading

Tip

SQL Server Parallel Data Warehouse: Get to know the client tools

Learn about the new set of client tools when you take on Microsoft's Parallel Data Warehouse in this tip. Continue Reading

News

Three hot SQL Server technologies you need to know

SQL expert Denny Cherry wants you to know about these technologies related to business intelligence and data growth. Continue Reading

3Latest DBA essentials-

Essentials for DBAs in 2014

The release of SQL Server 2014 brings news and updates for even the most experienced DBAs. Learn more about the latest version and technology trends that all DBAs need to know with the news stories below.

News

SQL Server DBAs: Prepare to take on big data and more roles

Today's DBAs have to be prepared to take on big data and a wider variety of tasks, according to leaders of the Professional Association for SQL Server. Continue Reading

News

DBA focus shifts to big data technologies

A platform architect advises DBAs to turn their focus to SQL Server big data technologies. Continue Reading

Feature

New features of the SQL Server 2014 database release

The release of SQL Server 2014 includes in-memory and cloud integration features. Continue Reading

Feature

SQL Server 2014 to offer increased availability and scalability

Learn more about the availability and scalability features of SQL Server 2014. Continue Reading

News

Community Technology Preview of SQL Server 2014

Check out this CTP for the new SQL Server release before it becomes generally available. Continue Reading