Well yes, actually I do. This happens when you rename a dtsx file outside of the project (ie, in the file system) and then load the package in a project. The project will not complain because it has the right file name but … the package itself knows it’s not the same. So open the […]
Author: Kristof
I need a script to shrink all the log files on my database server
Ah, I can help with that. The script below will generate a script (scriptception!). So make sure to press ctrl-t before executing the script, so you can get the results in text format. Then, you can copy and paste the result text into a new window and run the script. It will shrink and then […]
How do I get a report on the execution of an SSIS Package
If you want an execution report of an SSIS package, you can use the code below. It will generate a dataset for the last execution report of the SSIS package you want. I think the toggles speak for themselves but just in case, here’s a little overview. PackageName: Yes, this is the name of the […]
Can you show me how to kill whomever is hogging my SQL Server?
Yes. This script will find the process that is burning the most IO and CPU time. The first column will contain a KILL ??? command. If you copy that value and paste it into a new query window and run it, it will kill the command with the highest CPU and IO time. Carefully! This […]
How do I make a countdown timer in DaVinci Resolve?
Well, you will need a Fusion component and an expression. Go to Edit mode Find the Effects window to the left, open Toolbox and click effects Drag the Fusion Composition to an empty track Right-click the Fusion Composition and choose “Open in Fusion Page” Drag a text block (T) onto the canvas. Select the text […]