return a file Last Modified Date
This function takes a UNC file as a parameter and return the last modified date
2010-01-13 (first published: 2009-12-17)
2,532 reads
Scripts
Store Procedure Output in a Table
This script show a demonstration of how to interst tore Procedure Output in a Table.
2010-01-08 (first published: 2009-12-18)
2,484 reads
2010-01-07 (first published: 2009-12-18)
1,718 reads
SQL Server Agent Schedule Decoder
This script will break job schedules down into a readable format (msdb.dbo.sysschedules)
2010-01-06 (first published: 2009-12-16)
1,961 reads
Find weak login passwords in your server
Use this script to search for SQL Server logins who use weak password
2010-01-05 (first published: 2009-12-16)
4,330 reads
Script to Compress Tables and Indexes
This script creates scripts to compress all tables and indexes in a database.
2010-01-04 (first published: 2009-12-11)
15,733 reads
Searching Column Name in All Tables
Use this script to search for a specific column name in all tables in a current database.
2010-01-01 (first published: 2009-12-09)
1,952 reads
Automated SQL Job to Backup Database(s)
Automate All Database Backups with this script. handle full, diff, and log backups.
2009-12-31 (first published: 2009-12-15)
2,676 reads
2009-12-30 (first published: 2009-12-15)
1,049 reads
2009-12-23 (first published: 2009-11-26)
585 reads
Blogs
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers