-
Recent Posts
Recent Comments
- paulwinans on Hard Coded Values
- Dejan on Hard Coded Values
- paulwinans on SQL Licensing and the Cluster
- paulwinans on Leadership
- paulwinans on Where Are All The People Who Want to be a DBA?
Archives
- February 2018
- July 2017
- July 2016
- May 2016
- October 2015
- September 2015
- August 2015
- July 2015
- May 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
- June 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- April 2013
- March 2013
- October 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- February 2012
- January 2012
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- May 2009
Categories
Meta
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