Recent Posts

0
Comments

Configuration Manager now supports SQL Server 2012 by sthompson

A lot of folks have been asking when will ConfigMgr support SQL Server 2012. Here is the update on that, it is only supported if ConfigMgr 2007 SP2 and...
0
Comments

ConfigMgr 2012 Database Collation clarification by sthompson

As a point of clarification, database collation as stated in the current documentation http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig...
0
Comments

Editing CM12 reports in the ConfigMgr console with SQL Server 2008 R2 by sthompson

Presently, if you have installed ConfigMgr 2012 with SQL Server 2008 R2, and attempt to edit a report from the console, you will get an error message that...
0
Comments

MMS 2012 – Content Survey by sthompson

From a recent email, please take the time to respond and let this group know what you content you want to see for sessions. Anything SQL related like custom...
Filed under: , ,
0
Comments

Generate a list of Configuration Manager reports from Reporting Server by sthompson

Have you ever needed to product a list of reports and report descriptions from Reporting Services? Use the following SQL to retrieve this information from...
0
Comments

ConfigMgr 2012 Release Candidate is here by sthompson

The release candidate is now here for download . Note the official name is now; System Center 2012 Configuration Manager. You can read more about it here...
0
Comments

What is old, then new again? ODBC by sthompson

Read the following blog entry, found this to be very fascinating. http://blogs.msdn.com/b/sqlnativeclient/archive/2011/08/29/microsoft-is-aligning-with...
2
Comments

2011 Microsoft MVP Award by sthompson

Received my 2011 MVP award today. It is both an honor and a privilege to be awarded MVP in ConfigMgr for another year. This is a great community and I...
Filed under:
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: , ,
More Posts Next page »
Powered by Community Server (Commercial Edition), by Telligent Systems