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,847 reads
Scripts
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,129 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)
628 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)
912 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,137 reads
Part 2 -- Restore a database to another instance...
This script should be created in the source instance of the database to be backed up and then restored in conjunction with that on the destination in Step 1.
2016-03-15 (first published: 2016-02-25)
1,672 reads
Part 1 -- Restore a database to another instance...
A great script that I wrote some time ago to allow the last database backup to be restored across a linked server to another server, after running a remote sproc on the destination to kill off any users on the receiving side.
2016-03-14 (first published: 2016-02-25)
876 reads
2016-03-11 (first published: 2014-09-11)
2,779 reads
Get file sizes of database files and free space on disk
Reports on the data and log file sizes and space used within files for each database on a servers. It also includes the free space on the drive where the file is located.
2016-03-10 (first published: 2015-07-23)
5,520 reads
Last Accessed Datetime for table - Easiest way
This function is used to get the complete table lists are particular table and its last access datetime.
2016-03-07 (first published: 2014-11-03)
3,235 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers