-
Demystifying the Microsoft Distributed Transaction Coordinator
Microsoft Distributed Transaction Coordinator is crucial for transactional consistency across multiple instances of SQL Server. Learn how to monitor MSDTC and troubleshoot issues, and get tips on h...23 Dec 2010
-
Q&A;: Microsoft surveys horizon as cloud computing providers mount
Salesforce.com’s upcoming cloud offering Database.com will widen the pantheon of cloud computing providers, but Microsoft's Mark Kromer says SQL Azure can handle the competition. Read on for Kromer...21 Dec 2010
-
SQL Azure migration: To the cloud and back again
With SQL Azure gaining in popularity, there is greater need for moving data back and forth from the cloud. Several tools are available for SQL Azure migration, and the first of this two-part series...15 Dec 2010
-
SQL Server command-line utilities: sqlcmd
SQL Server command-line utilities give database administrators a new way to access the database engine and its components. Learn about each utility and its command syntax, starting with the sqlcmd ...09 Dec 2010
-
Using bcp utility for data moving, sqldiag for troubleshooting
Learn about three more command-line utilities. The bcp utility for data moving directs data into and out of SQL Server; sqldiag gathers diagnostic information and can be used in troubleshooting a p...09 Dec 2010
-
Command-line utilities for SQL Server database tuning, comparing tables
Get an inside look at a command line utility for SQL Server database tuning. See how the dta utility does an analysis on its given workload and provides performance recommendations. And read about...09 Dec 2010
-
Warned about table changes in SSMS? Here’s a workaround
Editing tables in SQL Server Management Studio and getting this warning, “Saving changes is not permitted”? It happens when the table needs to be re-created. But don’t fret. This change in SQL Serv...07 Dec 2010
-
Reading a SQL Server query execution plan
Query Optimizer is responsible for carrying out one of SQL Server’s biggest day-to-day duties: analyzing queries and executing them. It does this by producing a query execution plan, which can be i...02 Dec 2010