Category Archives: SQL

Performance Tuning from a High Level

We had a report which ran “forever”. Seriously it was a long time. After restoring production backups on to a test instance, I ran the same sql. Not good. I could have grown the coconuts whose water I was drinking. … Continue reading

Posted in DBA, SQL | Leave a comment

Searching for Emails in Tidal Scheduler

TES stores emails used in email actions in the table dbo.tskmail. If you want to find a particular email, then, you’d use a query like this: select * from dbo.tskmail where tskmail_to_ext like ‘%your_email@somewhere.com%’

Posted in SQL, Tidal Enterprise Scheduler | Leave a comment

SSRS Subscription Owners

We have to be sure subscription owners are not going to leave and make the subscriptions they own fail. Here is a way to make this information visible easily. For the reporting group I made a stored procedure which takes … Continue reading

Posted in SQL, SSRS | 2 Comments

What is Tidal Enterprise Scheduler?

Tidal Enterprise Scheduler is a Cisco product which allows for many things SQL Agent can’t easily do, such as allowing for cross server job dependencies; removal of a single job execution without cancelling the entire schedule; file triggered events; passing parameters from one job to another; … Continue reading

Posted in SQL, Tidal Enterprise Scheduler | Leave a comment

Concatenating rows

We decided to use the data driven subscriptions for SSRS. This means storing all kinds of info in a database and then having to present it to the report server as subscription parameters. Specifically we have to concatenate a bunch … Continue reading

Posted in SQL, SSRS | Tagged | Leave a comment