Script to remove Backup Files except Recent One for Same Day
This script is useful to remove SQL backup files except latest one for same day from Backup Path.
2015-01-26 (first published: 2014-12-12)
1,099 reads
Scripts
Calculate Power - Most Advanced UOC
This function is used to calculate the actual unit of conversion for power.
2015-01-23 (first published: 2014-12-16)
838 reads
Calculate Time - Most Advanced UOC
This function is used to calculate the actual unit of conversion for time.
2015-01-19 (first published: 2014-12-15)
1,015 reads
Function for String Occurences Count
This function is used to get the particular string occurences count from the given input string.
2015-01-16 (first published: 2014-12-16)
1,128 reads
Find Deny permissions on database objects
This script allows the DBA to quickly determine if a deny statement is stopping a user from accessing db objects.
2015-01-14 (first published: 2014-12-17)
6,596 reads
Calculate Temperature - Most Advanced UOC
This function is used to calculate the actual unit of conversion for temperature.
2015-01-09 (first published: 2014-12-11)
1,005 reads
Calculate Angle - Most Advanced UOC
This function is used to calculate the actual unit of conversion for angle.
2015-01-06 (first published: 2014-12-10)
641 reads
Calculate Area - Most Advanced UOC
This function is used to calculate the actual unit of conversion for area.
2015-01-02 (first published: 2014-12-10)
689 reads
Calculate Mass/Weight - Most Advanced UOC
This function is used to calculate the actual unit of conversion for mass.
2015-01-01 (first published: 2014-12-10)
536 reads
Dynamic Script to Generate Backup Script
Use this script to generate BACKUP DATABASE scripts for selective or all databases during Instance or Database migration.
2014-12-31 (first published: 2014-12-10)
1,292 reads
Blogs
A Couple Quick GENERATE_SERIES Tests
By Steve Jones
I had someone reach out about generate_series() recently, saying they hadn’t realized this was...
How I passed the DP-700 Exam
I recently took and passed the DP-700 exam, which is required for the Microsoft...
Which approach to take: Build it, buy it, cloud it?
As a Consultant, I would typically answer with – it depends! Then a typical...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
How to Download and Restore AdventureWorks 2019 Database
Comments posted to this topic are about the item How to Download and Restore...
Tracking Table Sizes
Comments posted to this topic are about the item Tracking Table Sizes
Question of the Day
Counting Bits IV
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers