Custom Schedule for an Agent Job

When you have a need to run an agent job on a quarterly schedule, you will find out that there is not an available template you can choose from the UI.

One way you can reach this goal is to add a first step to check month before the normal job step(s).

You can modify your existing job to add a step as start step and use the following T-SQL command to generate error by design.

If the schedule is not what you need, generate an error  in the code.

Configure the step to continue to next step if success; quit and report success if it fails.

Your other steps in your job will not run if it is not on schedule.

Here is the T-SQL code for step one to check quarter start months.

Use JSON to Simulate String_Agg in SQL Server 2016

SUM SUM OVER Sample Code

How to Delete Folder with Files from Bitbucket

From Bitbucket repository on the left, select Source<>.
On the right, select the Folder and expand the folder to see files;

Select a file and from arrow beside Edit and select Delete>> Commit.
REPEAT this process to delete each file;

From Bitbucket repository on the left, select Source<> again;

Observe that an empty folder is automatically removed from a git repository!

Parse Data with JSON

https://social.msdn.microsoft.com/Forums/en-US/040c64dc-87eb-4d51-abbb-6ecf2c8f23c0/parse-data-from-a-table-row-and-output-the-values-formatted?forum=transactsql

Custom Reports from SSMS for SQL Server Assessment

It is our pleasure from Iowa SQL Server Users Group (IASSUG) to have Dave Bland as speaker for Des Moines PASS August 10 Meeting:

“How to do a Complete Server Assessment”

He created a series of custom SSRS reports and offered to use them from SSMS with a few clicks to access bunch of information about your server and database.

You can download the source reports from a zipped folder at Dave Bland’s blog site:

SQL Server Assessment Using SSMS and SSRS

After you download the file and unzip it a your local drive to the SSMS file folder for easy access.

Launch your SSMS and connect to an Instance(Server). Right click on Instance name(or database name) and choose the Reports>Custom Reports… and browser to the files you unzipped.

Click on the first report _LaunchingPage.rdl and you are launching the Main report page.

Your journey starts here.

I will run this report on a few new 2019 servers I set up recently to view lot of useful information in a very short time.

During the presentation, Dave walked through some interested reports and their use cases. I have come across many of them from my DBA career and I know Dave did a great favor for SQL Server community with this handy report tool.

Thanks Dave!

Split with JSON in One Column

WinSCP Send File with New Name

SP to Scripting out SSIS Environments Variables

Scripting Environments in SSIS

You may need to modify  ev.base_data_type to sysname type to replace string type nvarchar type without size in the script below.


SELECT [env_var] = @tab + @tab + ', @' + ev.name + ' '  + ev.base_data_type  + '= N''' + ISNULL(CONVERT(varchar(max), ev.value), '<REPLACE_ME>') + ''''
                        , [name] = ev.name
        INTO #env_var
        FROM [SSISDB].[catalog].[folders] f        
        INNER JOIN [SSISDB].[catalog].[environments] e ON f.folder_id =  e.folder_id        
        INNER JOIN [SSISDB].[internal].[environment_variables] ev ON e.environment_id = ev.environment_id    
        WHERE (f.name = @folder) AND (e.name = @env);

Create Views From All Tables In a DB