The Curious Engineer

All blogs / Databases

SQL Journey

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

A blog about real-life SQL Server Troubleshooting, providing solutions that actually work. By a SQL Server Enthusiast.

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’15’20’25
Posts
37 from 15 Mar 2012 to 27 Apr 2015
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/sqljourney/feed.xml

2015 1

  1. An In-depth look at memory - SQL Server 2012/2014

2013 10

  1. An interesting issue with Peer to Peer Replication
  2. Something to watch out for when using IS_MEMBER() in TSQL
  3. When using SSL, SQL Failover Cluster Instance fails to start with error 17182
  4. SQL 2012 Availability Group does not come up on one instance
  5. SQL Server patch fails with "Could not find any resources appropriate for the specified culture or the neutral culture"
  6. How To: Troubleshooting SQL Server I/O bottlenecks
  7. An interesting issue with SQL Server Script upgrade mode
  8. Why the service account format matters for upgrades
  9. An in-depth look at SQL Server Memory–Part 3
  10. An in-depth look at SQL Server Memory–Part 2

2012 26

  1. An in-depth look at SQL Server Memory–Part 1
  2. How To : SQL 2012 Filetable Setup and Usage
  3. Why the registry size can cause problems with your SQL 2012 AlwaysOn/Failover Cluster setup
  4. SQL 2008–Service fails to come online with “a valid certificate could not be found, and it is not possible to create a self-signed certificate”
  5. Migrating TFS from SQL Server Enterprise to Standard can cause problems due to compression
  6. When DBMail started complaining about the servername being NULL
  7. An in-depth look at Ghost Records in SQL Server
  8. The most interesting issue in DB Mirroring you will ever see
  9. Backup database results in error “Could not clear 'DIFFERENTIAL' bitmap in database”
  10. How a tiny little whitespace can make life difficult for your SQL Cluster
  11. SQL 2008/2008 R2/2012/2014 setup disappears/fails when installing Setup Support files
  12. The ‘NULL’ Debate, and a few other interesting facts
  13. SQL Server Resource database corruption–yes, it’s possible
  14. SQL, Sharepoint and the Windows Internal Database – an interesting saga
  15. How to replace/restore start menu shortcuts for any program
  16. SQL 2005 patch fails with 1642 “Unable to install Windows Installer MSP file”
  17. SQL 2005 Patch on cluster might fail with “No Passive nodes were successfully patched”
  18. Access Violation dumps and metadata corruption
  19. VSS backups might cause SQL to generate Non-Yielding Scheduler dumps if Backup verification is turned on
  20. An interesting “Issue” with adding Windows Logins in SQL Server
  21. Windows Server 2003 - KB 2463332 for Windows Internal Database fails to install
  22. SQL Server Patch installation fails with error 1603
  23. SQL 2008/R2 setup fails with "Wait on the database engine recovery handle failed"
  24. An interesting find about Temp tables in SQL Server
  25. Implementing SSL encryption for SQL Server in a DNS forwarding environment
  26. SQL Server Service Pack installation may fail if your instance name is a Windows reserved word