SSRS SSL Certificate Nightmare
I write this post after a hellish experience that lasted a couple of hours trying to sort out the SSL certificate for SSRS.
Read more →
Archive for month: June, 2011
SQL Server Graphical Execution Plan Icons Walkthrough Part 1 – Lookup Operations
SQL Server’s Graphical Execution Plan contains a wealth of information that could be used to diagnose performance and maintenance (such as out of date statistics) issues.
Klout’s Social-Media Influence API
Klout has developed a really cool API that gauges a user’s “Social Influence” by aggregating the user’s activities and interactions within the social realm, The API is currently free access (up to a certain limit of usage), and still in Beta stage.
List of all SQL Server DMVs & System Objects
As you probably already know, SQL Server has many DMVs (Dynamic Management Views) and System Objects that helps DBAs, these include performance counters, index statistics, resource locking information, user object IDs and many more.
Query SSRS Report Schedules
A few months back I needed to grab SSRS schedule information through T-SQL, essentially in a query so I can publish the data through an EXCEL sheet (with a data connection to the database).
