Determine if BACKUP COMPRESSION is available
This script will determine the SQL Server version and edition in order to find out if BACKUP COMPRESSION is available.
2014-04-02 (first published: 2013-09-10)
915 reads
Scripts
Get the all user and their server role
The script give you the list of all users and their respective Server roles
2014-04-02 (first published: 2014-03-11)
1,570 reads
2014-03-31 (first published: 2014-03-03)
1,242 reads
DBCC,Backup, Verify and create Agent Job to restore
Script to Automatically Backup, Drop and create Agent Job to restore from that backup.
2014-03-25 (first published: 2014-03-03)
1,070 reads
Using Seqence Container instead of Identity
This script is an example of how to use Sequence, similar to Identity.
2014-03-24 (first published: 2014-02-25)
1,353 reads
Script to Check the Database Backup duration
Script to Check the Database Backup duration of entire instances
2014-03-19 (first published: 2014-02-25)
2,134 reads
Script to Get the Database Restore history
Script to get the Database restore history details including with the files by which the database is restored.
2014-03-17 (first published: 2014-02-25)
1,311 reads
Script to Get the Backup History
Script to get the database backup history on SQL Server 2000/2005/2008
2014-03-14 (first published: 2014-02-25)
1,538 reads
2014-03-13 (first published: 2014-02-25)
1,106 reads
Calendar Table by Year
Populate a calendar table with user set interval start and end datetime values.
2014-03-11 (first published: 2014-02-21)
2,113 reads
Blogs
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
Forums
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers