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
A quick script that removes leading zeros in a numeric stored as a string.
2022-12-30 (first published: 2022-12-26)
578 reads
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
An introduction to SQL Server for Red Hat Linux Administrators with a step by step installation.
2016-12-27
1,441 reads
By Steve Jones
Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG...
By Steve Jones
Today’s coping tip is to go to bed in good time and allow yourself...
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Hi all! AWS has a good example of how to manipulate the requested objects...
Is the SQL Script plug-in listed here no longer available? SQL Scripts in SSMS...
Hi folks, I have a single Postgres instance on RDS that in the past...