Error 18456 State 38: failed to open the explicitly specified database. The login worked and the database did not. The four usual causes.
SQL SERVER – The Cluster Resource ‘SQL Server’ Could Not be Brought Online Due to an Error Bringing the Dependency Resource
Installing a second SQL Server 2012 instance on my Windows cluster failed: the cluster resource ‘SQL Server’ could not be brought online. Here is the fix.
How to Create Temp Table From Stored Procedure? – Interview Question of the Week #140
How do you create a Temp Table from a stored procedure when you do not know its result set? Here is the OPENROWSET approach I use, and its drawbacks.
SQL SERVER – Changing Cluster Domains with WSFC and SQL FCI Support Limits
To Move SQL Server Cluster installations between domains, I plan an application-specific migration. The Windows cluster capability alone does not establish SQL support.
SQL SERVER – AlwaysOn Availability Group Listener – This TCP Port is Already in Use
Creating an AlwaysOn availability group listener in SSMS failed with error 19486: this TCP port is already in use. Here is what the ERRORLOG showed.
Spreading Rows Into Hash Buckets With CHECKSUM and Modulo
Equal row counts do not mean equal work, and patterned keys can pile into one bucket. Here is how to test your buckets before adding workers.
SQL SERVER – Convert Decimal to Time Format in String
A very strange question I received the other day in an email about how to convert decimal to time format string.