I want to configure HA for one application that is using an SQL database . I created my cluster every thing is OK .
My idea is to create an Hyper-V VM in the cluster env and install SQL on it (Non Clustered) and put the databases files in a Shared disk . so that when one node fails the VM can continue to the other Node
Would it work?
I saw that there is an option to install SQL for cluster but not being an expert of SQL I'm a bit reluctant to go that way
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…