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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
SQL SERVER – How to Create Linked Server to SQL Azure Database?
If you take the normal approach to create a linked server to SQL Azure Database, then you would end up in below error message.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.