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)
2,422 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
3,440 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,510 reads
Blogs
SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow
Want to build a data analytics foundation that transforms raw data into valuable business...
Using SQL Compare in Read-Only Databases
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
T-SQL Tuesday #179 Roundup: The Data Detective Toolkit
By Tim Mitchell
Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked,...
Forums
Date Type ETL Question
I'm not sure that I'm posting this in the right section, so please mods...
Possible oddity in msdb.dbo.backupset
Hi all I've written a script to keep track of how long backups...
Operand data type varchar is invalid for sum operator
I have this view [dbo].[Asset Metrics - Client(Rama -Client-Test)], which makes use of multiple...
Question of the Day
Data Migration Assistant Sources
In the current (Sep 2024) Data Migration Assistant, what are the possible sources for on-premises SQL Server instances?
See possible answers