The Curious Engineer

All blogs / Databases

Standard solutions to random problems

learn.microsoft.com/en-us/archive/blogs/john_daskalakis

by John Daskalakis

DatabasesDevOps / SRE / infrastructureMicrosoft blogsMSDN archive

’15’20’25
Posts
29 from 2 Sep 2013 to 8 Dec 2014
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/john_daskalakis/feed.xml

2014 14

  1. Server TCP provider failed to listen on [IP Address]. Tcp port is already in use.
  2. Is it safe or supported to remove the local security groups that the SQL Server setup creates (SQLServer2005MSSQLUser$<computer name>$MSSQLSERVER) ?
  3. TEMPDB files fail to be created with error: "CREATE FILE encountered operating system error 32"
  4. Does the CRM database and application support the SNAPSHOT isolation level?
  5. Script to export the configuration of SQL Server
  6. The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x8009030d. Check certificates to make sure they are valid.
  7. Msg 2547, Sev 16, State 1 - Unable to process object ID X (object "Y") because it is a synonym
  8. How to install a Service Pack at a SQL Server 2012 Failover Instance - Best Practices
  9. How to troubleshoot Scheduled Tasks that fail to run
  10. The OpenSSL "Heartbleed" vulnerability and SQL Server
  11. Some misconceptions about uninstalling SQL Server 2008 (and SQL Server 2008 R2)
  12. Windows Server 2012 stop error: BugCheck 3B, {c0000005, fffff88000e11d4b, fffff8800883d5b0, 0}
  13. What data to collect from a SQL Server failover instance after a problem occurs
  14. Information you need to know before setting up GeoClustering at SQL Server 2008 or SQL Server 2012

2013 15

  1. The strangest SQL Server Agent problem you will ever meet!
  2. How to do a quick SQL Server healthcheck
  3. How to use Extended Events to proactively monitor your SQL Server for Deadlock issues
  4. SQL Server default settings that you might want to change
  5. Specialized Performance Troubleshooting (Part 3: How to identify storage issues at a SQL Server box)
  6. Specialized Performance Troubleshooting (Part 2: How to troubleshoot Memory problems in SQL Server)
  7. Specialized Performance Troubleshooting (Part 1: How to troubleshoot Forwarded Records)
  8. How to troubleshoot SQL Server performance issues with simple tools (Part 2: How to analyze the Perfmon trace and detect SQL Server performance issues)
  9. How to troubleshoot SQL Server performance issues with simple tools (Part 1: How to analyze the Perfmon trace and detect IO bottlenecks)
  10. How to troubleshoot SQL Server performance issues with simple tools (Part 1: How to collect a detailed Perfmon trace)
  11. Database maintenance and when is it needed (Part 5: Back Up Database)
  12. Database maintenance and when is it needed (Part 4: Update Statistics)
  13. Database maintenance and when is it needed (Part 3: “Reorganize Index” and “Rebuild Index”)
  14. Database maintenance and when is it needed (Part 2: SHRINK operations)
  15. Database maintenance and when is it needed (Part 1: Integrity Checks)