How do you find the busiest database on a SQL Server instance? I use sys.dm_exec_query_stats to add up logical reads and writes for each database.
A Migration Cutover Checklist
A migration cutover checklist covers final backup, logins, jobs, linked servers, DNS, validation, and an explicit go or no-go decision.
SQL SERVER – Fragmentation – Detect Fragmentation and Eliminate Fragmentation
What is fragmentation, and how do you detect fragmentation and eliminate it? I explain the internal and external types and what each one does to your pages.
SQL SERVER – The server network address “TCP://SQLServer:5023” can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)
Error 1418 in database mirroring says the server network address cannot be reached. Try my suggestions one by one, starting with a NO RECOVERY restore.
MERGE Statement Pitfalls
MERGE statement pitfalls include duplicate source keys, concurrency races, trigger surprises, and complex actions that deserve testing.
Migrating From MySQL to SQL Server: The Gotchas
Migrating from MySQL to SQL Server needs identity, collation, paging, and date rules, with SSMA assessing and converting the bulk of the work.
SQLAuthority News – Ahmedabad – Gandhinagar SQL Server User Group Meet – Dec 19, 2009
Notes from the December 2009 Ahmedabad and Gandhinagar SQL Server User Group meeting, with Tejas Shah on PIVOT cross tab queries and my talk on SQL myths.