Remove Leading Zeros in any situation T-SQL
A quick script that removes leading zeros in a numeric stored as a string.
2022-12-30 (first published: 2022-12-26)
578 reads
Venugopal Saride
Amazon RDS SQL Server - Drop Database with Mirroring
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,978 reads
SQL Server v.Next - Linux Installation Step by Step
An introduction to SQL Server for Red Hat Linux Administrators with a step by step installation.
2016-12-27
1,441 reads
Blogs
RMOUG Training Days in Denver
By Steve Jones
Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG...
Daily Coping 7 Feb 2023
By Steve Jones
Today’s coping tip is to go to bed in good time and allow yourself...
Tales From The Field Weekly Wrap Up for the Week of 01-31-2023
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Forums
What are the alternatives of S3 Object Lambda?
Hi all! AWS has a good example of how to manipulate the requested objects...
SQL Script plug-in
Is the SQL Script plug-in listed here no longer available? SQL Scripts in SSMS...
Modify RDS page missing the Storage Autoscaling option
Hi folks, I have a single Postgres instance on RDS that in the past...
Ask SSC