2015-02-12 (first published: 2010-03-12)
4,930 reads
Scripts
Calculate Length - Most Advanced UOC
This function is used to calculate the actual unit of conversion for length.
2015-02-06 (first published: 2014-12-15)
828 reads
2015-02-05 (first published: 2013-03-22)
4,459 reads
Users , Roles and Logins
Useful script in cases where auditors would like to know roles for each user in each database of an instance as well as the status of associated logins.
2015-02-03 (first published: 2015-01-25)
2,946 reads
Calculate Volume - Most Advanced UOC
This function is used to calculate the actual unit of conversion for volume.
2015-01-30 (first published: 2014-12-16)
821 reads
Copy Latest Backups from Backup Path
This script is useful to copying latest backup files from job Backup path during Instance/Database Migration
2015-01-29 (first published: 2014-12-15)
957 reads
Update Statistics for databases where you have access
Run this stored procudure to update statistics for those SQL Server databases where you have permission
2015-01-27 (first published: 2015-01-08)
1,242 reads
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,096 reads
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
Blogs
A New Word: Querinous
By Steve Jones
querinous – adj. longing for a sense of certainty in a relationship; wishing there...
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Forums
MDX SSAS Calculated measure for last totals + turnovers
I have a measure with totals for specific dates with the LastNonEmpty aggregation, and...
display bytea image
I moved a table from MsSql to Postgresql that had a field defined as...
When trying to use a LocalDB, I get an error
I tried to find an appropriate forum to post the question. This one seems...
Question of the Day
SQL in an Azure VM Backup
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers