Build restore scripts dynamically
This script will build restore scripts with the most recent full backup and all t-log backups since, for each user database in the SQL instance.
2016-11-09 (first published: 2016-11-01)
1,376 reads
Scripts
Monitor your website or any URL from SQL Server
You can monitor your web application by given its url and by creating the job in sql server 2005 which will send you the mail when ever your website is down.
2016-11-07 (first published: 2009-06-17)
11,953 reads
2016-11-03 (first published: 2014-10-07)
2,619 reads
Script All Logins / Users / and Roles
This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.
2016-11-02 (first published: 2013-10-31)
33,342 reads
View for Ola Hallengren CommandLog
Add 3 columns, duration in seconds,Pagecount and fragmentation. For people like me who don't enjoy querying XML.
2016-10-31 (first published: 2015-11-12)
3,399 reads
2016-10-28 (first published: 2016-10-05)
23,056 reads
Getting top ranked employee detail for each department
Using OVER clause with ROW_NUMBER() function to get top ranked employee detail as per each department.
2016-10-25 (first published: 2016-10-03)
811 reads
Extracting only Deadlock details from ErrorLog
If you want to extract only deadlock details, use the script.
2016-10-24 (first published: 2014-12-03)
3,907 reads
2016-10-21 (first published: 2015-05-12)
2,426 reads
2016-10-20 (first published: 2015-05-15)
1,633 reads
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Getting Database MaiL Profiles
Comments posted to this topic are about the item Getting Database MaiL Profiles
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers