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,091 reads
Scripts
A varchar(MAX) STRING_SPLIT function for SQL 2012 and above
An alternative for Microsoft's STRING_SPLIT function that will work on SQL Server 2012 and higher.
2022-12-19 (first published: 2021-03-05)
334 reads
Convert Lat/Lon Decimal Degrees to Trigesimal Codes
Simplified latitude / longitude in 10 fixed bytes.
2022-10-26 (first published: 2022-10-21)
526 reads
2022-09-02 (first published: 2022-08-23)
6,748 reads
Excel LET Formula for creating small values tables from a table or range
The Excel (365) "LET" formula below will return a formatted SQL Values Table "T1" that can be pasted into SSMS.
2022-04-06 (first published: 2022-03-29)
911 reads
Search Database Objects
A stored procedure to search database objects (triggers, scalar functions, table valued functions, views and stored procedures) for a user defined string.
2022-04-04 (first published: 2022-03-28)
925 reads
MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases
This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.
2022-02-22 (first published: 2022-01-25)
7,224 reads
Script DB Level Permissions v4.6
Script database and object level permissions for all database users
2022-01-12 (first published: 2021-06-11)
13,906 reads
SQL Server instance startup type check by SQL script
I have developed the script to check SQL Server instances startup type, sometimes we didn't know all our SQL instances startup type correctly configurated, especially we cannot distinguish the Automatic and Automatic(Delayed Start) from the direct query, the only way is querying from the registry, you can use this script in your environment to bulk […]
2021-12-24
1,394 reads
Get backup folder sizes from shared Location
Got a message from the Operation team as below Hi Harsha, I'm seeing a larger than normal rate of change for a week day on the backups for the SQL2000 servers. Did anything run differently yesterday compared to Monday? I have 22 sql servers and all the Weekend and Monthly backups goes to the location […]
2021-12-03
496 reads
Blogs
Master Advanced SQL: 2 Essential Courses for Every Data Analyst
If you're a data analyst, you already know that SQL isn't just a nice-to-have...
Friday Flyway Tips–State-based Deployments
By Steve Jones
Recently the Flyway Desktop (FWD) team release support for state-based deployments. These are similar...
A New Word: Insoucism
By Steve Jones
insoucism – n. the inability to decide how much sympathy your situation really deserves,...
Forums
The Costs and Rewards of Speaking
Comments posted to this topic are about the item The Costs and Rewards of...
Manage Elastic jobs in Azure using Azure Elastic Jobs Manager
Comments posted to this topic are about the item Manage Elastic jobs in Azure...
Takeaways from Data Grillen 2024
Comments posted to this topic are about the item Takeaways from Data Grillen 2024
Question of the Day
Inserting Transaction Marks
When is a transaction mark first inserted into the msdb.dbo.logmarkhistory table?
See possible answers