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
119 reads
An introduction to SQL Server for Red Hat Linux Administrators with a step by step installation.
2016-12-27
1,360 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Sometimes in life you have to do things you really don’t like to do....
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
Hi, I need to include a very simple schema in all of my database...
This is my first time dealing with CLR assemblies and we have setup some...
Hi, I have a requirement to convert a date value like '7th March 2020' ...
Ask SSC