Email Alerts
-
Legacy file systems, away: Dealing with an unsupported file system
When the City of Aurora, Colo. heard that its legacy file system would no longer be supported, it had to act fast. Feature
-
When to consider SQL Server Enterprise Edition
Is SQL Server Enterprise Edition the right choice for you? Expert Robert Sheldon explains the advantages to consider when making your selection. Feature
-
The pros of Windows Azure SQL Database
What are the pros of choosing Windows Azure SQL Database over more traditional infrastructure? Serdar Yegulalp shares his knowledge on the subject. Feature
-
Little-known features of Microsoft SQL Server 2012
When it comes to Microsoft SQL Server 2012, it's easy to think you've seen it all. Andrew Novick shows Microsoft still has surprises up their sleeve. Feature
-
SQL Server Standard Edition: Why it's worth the cost
Should your IT shop consider a move to SQL Server Standard Edition? Expert Robert Sheldon explains the pros and cons you should know. Feature
-
SQL Server editions: Is Microsoft SQL Server Express right for you?
Which SQL Server edition is right for your IT shop? In this article by Bob Sheldon, find out if SQL Server Express is an option. Series
-
More predictions on 2013 SQL Server trends from Denny Cherry
What can you expect from Microsoft in 2013? Find out which SQL Server trends can be anticipated this year from SQL Server expert Denny Cherry. Feature
-
Denny Cherry's 2013 predictions (and wishes) for SQL Server trends
What new developments will SQL Server users see in 2013? Expert Denny Cherry predicts SQL Server trends to expect this year. Feature
-
SQL Server 2012 security: Changes for the newest version
SQL Server 2012 is here, and many DBAs wonder what kinds of changes to expect in SQL Server security. Basit Farooq explains what we can anticipate. Series
-
SQL Server 2012 Guide
SQL Server 2012 Guide
- See more Essential Knowledge on Microsoft SQL Server Tools and Utilities
-
Microsoft previews new SQL Server in-memory database features
Microsoft plans to offer new in-memory database capabilities with the next release of SQL Server. News | 07 Nov 2012
-
Three SQL Server tips Denny Cherry wants you to know
Which SQL Server technologies are hot right now? What does a SQL expert wish you knew about SQL Server? Hint: BI and data growth have a lot to do with it. News | 26 Jun 2012
-
Microsoft gives tour of new release of SQL Server
Microsoft gave PASS Summit 2010 attendees a walk-through of its Denali SQL Server release, demoing its AlwaysOn, FileTable and expanded SQL Server Integration Services features. News | 11 Nov 2010
-
Project Houston offers cloud alternative for SSMS
Microsoft’s new Silverlight-based app provides database management from a browser, a convenience that could be extended to non-cloud databases in time. News | 01 Sep 2010
-
xVelocity Columnstore Indexes in SQL Server 2012
Curious about how xVelocity can help with your columnstore indexes? Check out this tip from Basit Farooq to find out. Tip
-
Useful SQL Server 2012 features to become familiar with
SQL Server expert Basit Farooq shares his favorite SQL Server 2012 features you might not yet know. Read this tip to learn more. Tip
-
Six top SQL Server 2012 management tools you should know about
Read this tip from Basit Farooq to learn which time-saving and job-improving SQL Server 2012 management tools you need to know about. Tip
-
BI as a Service: Tips for scaling your BI system...in human terms
BI systems are great...if you can get your employees to use them. How do you make your system scalable? Read this tip from Don Jones to find out. Tip
-
Scale out with Windows Azure SQL Database
Scaling out Azure SQL doesn't have to be a painful process. Microsoft Windows expert Bob Sheldon shows you an easier way with Azure SQL federations. Tip
-
Introduction to SQL Server 2012 Express LocalDB
SQL Server 2012 Express LocalDB is a good way for developers to be able to play around with SQL Server 2012. Learn how to install and get started with it. Tip
-
What's new in SQL Server Reporting Services 2012
What's different about SQL Server Reporting Services 2012? What are the new features? Read this tip by expert Roman Rehak to find out. Tip
-
SQL Server training benefits for non-DBAs
DBAs know the value of SQL Server training. But what are the benefits for non-DBAs? This tip by Serdar Yegulalp examines who should learn more about SQL Server. Tip
-
Compare and synchronize databases with SQL Compare
Do you frequently need to compare or synchronize your databases? Read this tip by SQL Server expert Roman Rehak to learn the secrets of effective database synchronization using SQL Compare. Tip
-
Fault tolerance and backups and snapshots, oh, yes
They are vital tools all DBAs depend on. But what are the best products on the market these days? Expert Don Jones lets us know some of his favorites. Tip
- See more Tips on Microsoft SQL Server Tools and Utilities
-
Top SQL Server resources
Ask the Expert
-
SQL Server 2012
Microsoft SQL Server 2012 is a relational database management system (RDBMS) designed for the enterprise environment. Like its predecessors, SQL Server 2012 comprises a set of programming extensions to enhance the Structured Query Language (SQL), a s... Definition
-
ACID (atomicity, consistency, isolation, and durability)
ACID (atomicity, consistency, isolation, and durability) is an acronym and mnemonic device for learning and remembering the four primary attributes ensured to any transaction by a transaction manager (which is also called a transaction monitor). Definition
-
data aggregation
Data aggregation is any process in which information is gathered and expressed in a summary form, for purposes such as statistical analysis. Definition
-
Microsoft SQL Server 2012: A dozen features you might have missed
With Microsoft SQL Server 2012 we're seeing some changes, new features and a few old features going away. Learn about the biggest changes here. Photo Story
-
xVelocity Columnstore Indexes in SQL Server 2012
Curious about how xVelocity can help with your columnstore indexes? Check out this tip from Basit Farooq to find out. Tip
-
Useful SQL Server 2012 features to become familiar with
SQL Server expert Basit Farooq shares his favorite SQL Server 2012 features you might not yet know. Read this tip to learn more. Tip
-
Six top SQL Server 2012 management tools you should know about
Read this tip from Basit Farooq to learn which time-saving and job-improving SQL Server 2012 management tools you need to know about. Tip
-
Legacy file systems, away: Dealing with an unsupported file system
When the City of Aurora, Colo. heard that its legacy file system would no longer be supported, it had to act fast. Feature
-
Microsoft SQL Server 2012: A dozen features you might have missed
With Microsoft SQL Server 2012 we're seeing some changes, new features and a few old features going away. Learn about the biggest changes here. Photo Story
-
When to consider SQL Server Enterprise Edition
Is SQL Server Enterprise Edition the right choice for you? Expert Robert Sheldon explains the advantages to consider when making your selection. Feature
-
The pros of Windows Azure SQL Database
What are the pros of choosing Windows Azure SQL Database over more traditional infrastructure? Serdar Yegulalp shares his knowledge on the subject. Feature
-
Little-known features of Microsoft SQL Server 2012
When it comes to Microsoft SQL Server 2012, it's easy to think you've seen it all. Andrew Novick shows Microsoft still has surprises up their sleeve. Feature
-
SQL Server Standard Edition: Why it's worth the cost
Should your IT shop consider a move to SQL Server Standard Edition? Expert Robert Sheldon explains the pros and cons you should know. Feature
-
SQL Server editions: Is Microsoft SQL Server Express right for you?
Which SQL Server edition is right for your IT shop? In this article by Bob Sheldon, find out if SQL Server Express is an option. Series
- See more All on Microsoft SQL Server Tools and Utilities
About Microsoft SQL Server Tools and Utilities
Having the right tools at your disposal means everything to the SQL Server DBA. This Microsoft SQL Server tools and utilities topic page features information on a variety of free tools for database admins designed to make their lives easier while at the same time improving SQL Server performance. Here you'll find details on free downloads and utilities for Microsoft SQL Server environments, as well as advice from fellow database administrators and developers on an array of useful T-SQL functions.