Top SQL Server stories of 2013

Practical tips about SQL Server 2012 dominate the list of top SQL Server stories on SearchSQLServer this year.

SQL Server pros settled into SQL Server 2012 this year, and this year's top SQL Server stories reflected that. They no longer are just about whether to upgrade to SQL Server 2012, or how to upgrade. Now they are about management tools for the database, and in one expert tip, little-known features.

Mark Fontecchio

Two of these top SQL Server stories aren't about SQL Server 2012. The first deals with SQL Server 2014, which is expected to be generally available early next year. The last article -- the most popular on SearchSQLServer in 2013 -- is a guide to one of the most important features in any database. Can you guess what it is?

Useful SQL Server 2012 features to become familiar with. This tip from expert Roman Rehak details the four major features of SQL Server 2012, and how database administrators can use them. For example, more data types are supported for online indexing, which will allow you to do online indexing on more tables and possibly improve uptime. One downside: Online indexing still isn't available in the Standard Edition.

Six top SQL Server 2012 management tools you should know about. Basit Farooq sums up his favorite six management tools for SQL Server 2012. The right management tool can make a DBA's job much easier. Farooq examines such tools as SQL Server Management Studio, SQL Server Profiler and PowerShell.

Little-known features of Microsoft SQL Server 2012. Andrew Novick wrote this column back in January, and the two little-known features he mentioned then might possibly be the two best-known features today. Column-based indexing and in-memory processing are touted features, not just for SQL Server, but for many other database platforms as well today.

SQL Server 2014 due out in late 2013, in-memory online transaction processing a big feature. Moving on from SQL Server 2012 brings us to the next version in line: SQL Server 2014. Microsoft announced the update at its TechEd conference in New Orleans, and followed that up with a technology preview that is currently available for download. The production version of the database is expected early in 2014.

Basic SQL Server security best practices. Despite all the hype around SQL Server 2012 and SQL Server 2014, DBAs still look for the basics, and it doesn't get any more basic than making sure your database is secure. Ashish Kumar Mehta goes over some SQL Server security guidelines, such as using Windows authentication rather than SQL Server authentication, making the sysadmin's password complicated and disabling unused features.

Visit SearchSQLServer on Twitter and Facebook.

This was first published in December 2013
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Related Discussions

Mark Fontecchio asks:

What do you think is the top SQL Server story of 2013?

0  Responses So Far

Join the Discussion

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close