A reader’s ALTER PROCEDURE worked alone but failed inside an IF EXISTS block with incorrect syntax near the keyword ‘PROCEDURE’. Here is why and the fix.
SQL SERVER – How to Get List of SQL Server Instances Installed on a Machine?
There are multiple ways by which we can find a list of SQL Server instances name instances on a machine. In this blog, I would show a few ways to do it.
Understanding Database Scalability – Horizontal and Vertical Scalability Better Together
Horizontal and vertical scalability are not an either-or choice. Here is how scale-up and scale-out can work better together in one application.
SQL SERVER – Unable to bring resource online. Error – Data source name not found and no default driver specified
A clustered SQL Server resource would not come online on one node. The cluster log said: data source name not found and no default driver specified.
Cloud Consulting Pre-Engagement Questionnaire – A Bookmark
Thinking of moving an app to the cloud? The Cloud Consulting pre-engagement questionnaire I use with customers, worth bookmarking before your first call.
SQL SERVER – Added New Node in Windows Cluster and AlwaysOn Availability Databases Stopped Working
A client added a new node to the Windows Cluster and their AlwaysOn databases stopped synchronizing. The culprit was a wizard default, and here is the fix.
SQL SERVER – Fix Error Msg 10794, Level 16 – The operation ‘CREATE INDEX’ is not supported with memory optimized tables.
A reader tried my ColumnStore on InMemory OLTP example and got Msg 10794: CREATE INDEX is not supported with memory optimized tables. Here is the fix.