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
12 reads
An introduction to SQL Server for Red Hat Linux Administrators with a step by step installation.
2016-12-27
1,343 reads
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
As always, the scripts in this post can also be found on our Git...
I ran into a rather obscure permissions problem the other day. Since I wasn’t...
Comments posted to this topic are about the item On Looking and Acting the...
problem How to make group by Revision_ID and when repeated display last check date...
Comments posted to this topic are about the item Why Getting Data Right Matters,...
Ask SSC