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
1,614 reads
An introduction to SQL Server for Red Hat Linux Administrators with a step by step installation.
2016-12-27
1,434 reads
By Steve Jones
Today’s coping tip is to notice what you are feeling without any judgment. Today...
By Arun Sirpal
Whatever your database background is you will have heard of an execution / explain...
By Steve Jones
Today’s coping tip is to ask a trusted friend to tell you what strengths...
I working on sql server 2019 . i read more about sql graph but...
Dear Helpers, Below query is working fine giving me what i needed but if...
Hi, We have a database. We received the alert Could not allocate new page...
Ask SSC