Browse by Tags

All Tags » SQL Server (RSS)

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...

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...

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...

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...

SSRS 2005 to 2008 migration issue by sthompson

Just found an issue with an SSRS project migration from SQL Server 2005 to SQL Server 2008 R2.  First the report, newly converted to SSRS 2008 failed...

Report Server Explorer at Codeplex by sthompson

If you have not seen this utility for SQL Server Reporting Services , it is an excellent edition to any tools you may have to manage your SSRS environment...

Troubleshooting SQL Server 2008 R2 installation errors by sthompson

While installing a copy of SQL Server 2008 R2 developer edition today, I received a failure during install.      > Error 1935 <...

ConfigMgr 2007 R2 Report Wizard fails to convert certain reports by sthompson

Question from an myITForum community member: I've been trying to get the software 06A reporting functioning correctly in SRS. It works in the old asp...

Microsoft SQL Server 2008 Service Pack 2 - available by sthompson

Microsoft SQL Server 2008 Service Pack 2 is now available for download. Download Here Overview Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available...

How do I limit software in Add Remove Programs to specified subnets? by sthompson

Here is one solution to a recent question.  How do I limit the list of computers with specified software listed in add/remove programs to specific...

Office Migration Planning Manager (OMPM) 2010 is released! by sthompson

OMPM 2010 includes the following new features and improvements: Bulk Macro Compatibility Scanning – incorporates logic from the Office Code Compatibility...

How to backup SQL Server system databases by sthompson

Most SMS/ConfigMgr administrators are aware of the importance of backing up the ConfigMgr database itself.  The recommended approach, is configuring...

MMS 2010 – BA35 Using SQL Server BI to Compliment ConfigMgr 2007 Reporting by sthompson

As promised during the MMS 2010 presentation, here are the sample files and solution created during the presentation.  It was a pleasure presenting...
Filed under: , ,

MMS 2010 – BA33 Advanced Configuration Manager 2007 SQL Server Reporting and BI Overview by sthompson

As promised during the MMS 2010 presentation, here are the sample files and solution created during the BA33 presentation. If you create interesting reporting...
Filed under: , ,

How to change SQL Server date time fields for report display by sthompson

A recent question on myITForum regarding a report query for ConfigMgr 2007: In a SQL query how do I convert the data/time that is returned in 2010-04-11...
More Posts Next page »
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems