2016-04-01 (first published: 2016-03-23)
859 reads
Scripts
Accurate Time between Two Dates in Year, Month,Day Format
This script shows the total time between two dates.
2016-03-29 (first published: 2014-07-09)
3,077 reads
Find missing index in the whole instance
This script scans all DB-s in the instance & send result to the email. I use sp_MSforechdb function & missing index finding script what i found here https://technet.microsoft.com/en-us/magazine/jj128029.aspx
2016-03-28 (first published: 2016-03-23)
1,065 reads
2016-03-25 (first published: 2015-01-30)
2,692 reads
AD HOC Queries with Excel Output (Multiple Instances)
From a plain text containing multiple instance names you can deploy EXCEL files to report just changing your query text
2016-03-24 (first published: 2016-03-08)
1,212 reads
Parse list of names from Outlook
This script will parse a list of names copied from the To box of an Outlook email.
2016-03-23 (first published: 2015-07-20)
1,835 reads
Resolving merge replication conflicts type 5 & 6
Merge replication conflicts 'upload insert failed' and 'download insert failed' cannot be resolved using Conflict Viewer alone. Here's a script that will semi-automate the process for most conflicts
2016-03-21 (first published: 2016-03-03)
1,097 reads
Post-Deployment - Scan for RefreshView/Recompile
A script I can run after deployment to refresh views and force a recompile due to modified DDL.
2016-03-18 (first published: 2016-03-03)
591 reads
Transaction Log VLF Alarm
This was used to alert on VLF counts to high due to replication log reader having issue reading the transaction log.
2016-03-17 (first published: 2016-03-02)
904 reads
End to End Server Disk Space reporting within SQL Server
This procedure using OLE object calls to obtain server disk space values and writes them to a table. It then creates an HTML report based on the contents of the table and then , via a SQL Agent job, sends out colour coded emails relating to how much drive space is left... this is very handy!!!!
2016-03-16 (first published: 2016-02-25)
1,123 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers