Email Alerts
-
Guide to SQL Server data management and data quality
This Essential Guide offers expert advice for improving enterprise data management and quality with SQL Server tools and services. Essential Guide
-
SQL Server Data Tools 2012 makes developing DB projects easier
SQL Server Data Tools 2012 can now do many of the tasks formerly reserved for SQL Server Management Studio. Find out more. Feature
-
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
- 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
-
SQL Server views: Creating indexes and adding base data
SQL Server views allow you to give information to users without compromising security. Find out how to create indexes on them and add base data. Tip
-
SQL Server views: What they are and how to create them
SQL Server views can help DBAs provide information to users while still controlling data access. Find out how. Tip
-
Set database constraints using SQL Server Management Studio Table Designer
In addition to creating tables and adding columns, SQL Server Management Studio Table Designer can also set constraints. Tip
-
Using SQL Server Management Studio Table Designer to create a table
Creating a table correctly in SQL Server can be pretty tricky, but using SQL Server Management Studio Table Designer makes it easier. Tip
-
Manage your SQL Server databases with SQL DMVs
SQL DMVs (dynamic management views) can help simplify administration of SQL Server databases. Find out how with detailed examples. Tip
-
Six SQL Server management tools you can't live without
Expert Ashish Kumar Mehta lists six important SQL Server management tools, including BIDS, SSMS and SSDT. Tip
-
How to start and set up SQL Server Audit
Get an overview of the SQL Server Audit process, and check out the details for defining a target, setting up specifications and reading logged events. Tip
-
The lowdown on SQL Server auditing tools
Learn about the various components of SQL Server auditing tools such as server and database audit specifications as well as action groups. Tip
-
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 Roman Rehak shares his favorite SQL Server 2012 features you might not yet know. Read this tip to learn more. Tip
- See more Tips on Microsoft SQL Server Tools and Utilities
-
Top SQL Server resources
Ask the Expert
-
spatial data
Spatial data, also known as geospatial data, is information about a physical object that can be represented by numerical values in a geographic coordinate system. Definition
-
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
-
Five third-party SQL Server schema comparison tools
Schema comparison tools let you compare object definitions in two databases. Read why they're important, and learn about five popular ones out there. Schema comparison tools
-
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
-
SQL Server views: Creating indexes and adding base data
SQL Server views allow you to give information to users without compromising security. Find out how to create indexes on them and add base data. Tip
-
SQL Server views: What they are and how to create them
SQL Server views can help DBAs provide information to users while still controlling data access. Find out how. Tip
-
Set database constraints using SQL Server Management Studio Table Designer
In addition to creating tables and adding columns, SQL Server Management Studio Table Designer can also set constraints. Tip
-
Using SQL Server Management Studio Table Designer to create a table
Creating a table correctly in SQL Server can be pretty tricky, but using SQL Server Management Studio Table Designer makes it easier. Tip
-
Guide to SQL Server data management and data quality
This Essential Guide offers expert advice for improving enterprise data management and quality with SQL Server tools and services. Essential Guide
-
SQL Server Data Tools 2012 makes developing DB projects easier
SQL Server Data Tools 2012 can now do many of the tasks formerly reserved for SQL Server Management Studio. Find out more. Feature
-
Five third-party SQL Server schema comparison tools
Schema comparison tools let you compare object definitions in two databases. Read why they're important, and learn about five popular ones out there. Schema comparison tools
-
Manage your SQL Server databases with SQL DMVs
SQL DMVs (dynamic management views) can help simplify administration of SQL Server databases. Find out how with detailed examples. Tip
-
Six SQL Server management tools you can't live without
Expert Ashish Kumar Mehta lists six important SQL Server management tools, including BIDS, SSMS and SSDT. Tip
-
spatial data
Spatial data, also known as geospatial data, is information about a physical object that can be represented by numerical values in a geographic coordinate system. Definition
- 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.