2012-01-05 (first published: 2011-12-09)
2,561 reads
Scripts
Restore database from a device containing multiple backups
Script to restore the LATEST full and differential backups from a SQL Server 2008 R2 backup device.
2012-01-04 (first published: 2011-12-13)
2,193 reads
Quick check SQL connection and process details with current SQL text
This script will be useful to quickly check incase of any blocking or log wait occurs
2011-12-30 (first published: 2011-12-05)
1,531 reads
SQL Agent Jobs Summary
The following script can be used to determine the list of enabled SQL Agent Jobs, their start time, average run duration and next run date.
2011-12-29 (first published: 2011-11-30)
2,177 reads
DBUser Roles Script
This script will be used to script out the users and their permissions at the database level. We can use this when we are replacing /overrighting the existing database.
2011-12-28 (first published: 2011-11-22)
1,813 reads
Generate script to change column length of string datatypes in a DB
This script can be used to generate alter column length of any string data type column(s) in a database.
2011-12-27 (first published: 2011-11-22)
1,261 reads
Return CSV column in separate rows
This script can be used to return a csv column such emails in separate rows
2011-12-26 (first published: 2011-09-14)
1,545 reads
Logins created in the last X Days
These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.
2011-12-23 (first published: 2008-06-08)
2,345 reads
Comprehensive Backup Script
These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.
2011-12-22 (first published: 2008-01-29)
3,453 reads
A Sudoku solution with set based T-SQL utilizing binary operators
A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.
2011-12-21 (first published: 2008-04-30)
4,175 reads
Blogs
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...
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Forums
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
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
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