2016-04-01 (first published: 2016-03-23)
860 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,084 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,068 reads
2016-03-25 (first published: 2015-01-30)
2,714 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,217 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,839 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,107 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)
600 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)
905 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,125 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers