Dropping database in RDS follows different method than dropping the database in local SQL Server. Below is the command to DROP the database in Amazon RDS EXECUTE msdb.dbo.rds_drop_database N'demodb' GO However when the SQL Server is configured with Multi-zone mirroring, then you need to set the partner to OFF and drop all active connections and […]
2020-01-17
540 reads
An introduction to SQL Server for Red Hat Linux Administrators with a step by step installation.
2016-12-27
1,407 reads
By Steve Jones
It’s actually my month to host T-SQL Tuesday, and I came up with the...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...
Instead of SQL Server name I am thinking to use dns cname for connection...
Comments posted to this topic are about the item Sorting in R
Comments posted to this topic are about the item Oracle sequences: The basics
Ask SSC