Here’s some sql logic to get the SQL Server Collation ( Instance Collation ), and the Database Collation. Here’s a quick screenshot.
Here’s a short piece of SQL Logic that will give you a list of folders, or files from any directory. All you need is access rights to those folders either from the […]
Adding Drive Space – Extending Disks From OS ( Spanned Volume ) on SQL Server Datacenter Server in AWS.
We used this method after the space was added via AWS. Once a drive was added to the OS, we first Initialized the Disk, and while the disk was still ‘unallocated’; go […]