July 2011 - Posts

0
Comments

How to display Weekday in an SSRS report by sthompson

Recently, I needed to display the weekday in a column heading.  It turns out is was a little more complicated than specifying a function to extract...
Filed under: ,
0
Comments

SQL Query - Show Server Up time in ConfigMgr by sthompson

Here is a fairly common request, show me the uptime for for servers.  This is handy to determine whether or not a server or servers has rebooted since...
Filed under: ,
0
Comments

Microsoft Assessment and Planning Toolkit 6.0 Released! by sthompson

Overview The Microsoft Assessment and Planning Toolkit (MAP) is an agentless, automated, multi-product planning and assessment tool for quicker and easier...
Filed under:
0
Comments

SQL Server 2008 R2 Service Pack 1 Released by sthompson

Note: This release is not yet officially supported for ConfigMgr 2007, once the product team completes their compatibility testing they will announce support...
0
Comments

SQL Server memory and performance tuning for ConfigMgr by sthompson

A few years ago I wrote a blog on tuning SQL Server memory to work with ConfigMgr and SQL Server. How do I tune SQL Server memory for optimal performance...
0
Comments

Using Custom code in Report Builder by sthompson

As mentioned in an earlier post , it is possible to add custom code to Report Builder and BIDS (Business Intelligence Developer Studio).  There are...
0
Comments

Cumulative Update package 7 for SQL Server 2008 R2 by sthompson

In case you missed it, Cumulative Update package 7 for SQL Server 2008 R2 was released on June 16, 2011. We ran into a few SSRS 2008 R2 performance issues...
Filed under: , ,
Powered by Community Server (Commercial Edition), by Telligent Systems