Blogs

Over the (relatively) long history of T-SQL and SQL Server, when we (as programmers) needed to format a date or a number inside our SQL we primarily had access to two commands: CONVERT() CAST() Of these, CAST() is intended primarily for converting data field from one type…

In the course of working with the DR, you’re going to wind up setting up scheduled jobs through SQL Agent, and–inevitably–you’re going to want to calculate job durations to see what is running long, perhaps unexpectedly so. This leads you to the msdb.dbo.sysjobhistory table, which tracks the…

In certain situations, it may be desirable to make additional documentation available to the user at runtime. SSRS parameters can be leveraged for this purpose. In our example we use a report with two uncommon features: (1) use of wildcards in the name parameters, (2) use of…

On occasion there is a need for rows on a report to be conditionally hidden or visible based upon an expression that is determined when the report is run. One example of this type of functionality can be shown within a report displaying the assessments for a…