Browse by Tags

All Tags » SQL Server (RSS)

Using TSQL functions to split a delimited string by sthompson

Answered a recent question on the forums that I thought was worthy of a blog entry. Question Looking for a function or a method to basically take the following...
Filed under: ,

How to create a dynamic company logo for reports by sthompson

Have you ever needed to dynamically change the company logo displayed on a report? This technique will work for Visual Studio 2005 and 2008.  You...
Filed under: , ,

Presentations at MMS 2010 by sthompson

I’m pleased to have been selected to present at MMS 2010 this year.  Please attend these sessions if you have an interest in learning more about reporting...
Filed under: ,

How to add SMS 2003/ConfigMgr 2007 computers in a collection to an Active Directory security group by sthompson

Received an interesting question recently from myITForum regular Joshua Searles. Was it possible to use SQL Server stored procedure to directly add computer...

Custom Software Update Compliance Report for ConfigMgr 2007 by sthompson

Had a special request recently to create a custom compliance report based on the selection of a software update list and collection name. Besides the columns...

SSRS 2005 Installation issue encountered for ConfigMgr 2007 R2 by sthompson

Recently an interesting installation issue occurred for myITForum member Eric Morrison, while attempting to get SQL Server Reporting Services 2005 installed...

How to create SSRS Subscriptions for ConfigMgr 2007 - Part 2 by sthompson

In How to create SSRS Subscriptions for ConfigMgr - Part 1 , we discussed background information regarding SSRS subscriptions and necessary system prerequisites...

How to create SSRS Subscriptions for ConfigMgr 2007 - Part 1 by sthompson

SQL Server Reporting Services has many nice features. Perhaps one of the most powerful is the ability to create subscriptions to previously created reports...

How to back up SCCM 2007 R2 Reporting Services by sthompson

A recent post on the MVP alias got me thinking that others may not know that the standard ConfigMgr 2007 backup task does not back up the SSRS reports...

FAQ - SQL Server Reporting Services Integration with ConfigMgr 2007 R2 by sthompson

Just in case you have not seen this blog entry from Bhaskar Krishnan, member of the ConfigMgr Team. This blog is a very nice summary of the integration...
Filed under: , ,

Reporting Services Automation - enter RS.EXE by sthompson

I recently learned of a reporting services command line utility named RS.EXE . There are a number of interesting SSRS problems that can be solved with...
Filed under: , , ,

Notes from MMS 2009... SCCM.vNext unveiled! by sthompson

Another great year at MMS 2009! Bill Anderson and Josh Pointer presented the annual 'State of the Union' address. As always, it was very well done...
Filed under: , ,

Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 by sthompson

This product has been around for a few months, I first learned about this Report Builder utility while at the MVP summit in early March. I finally got...
Filed under: ,

Moving System Databases in SQL Server for ConfigMgr by sthompson

Have you ever had to move any of the following system databases: master, tempdb and/or msdb to another location? Be sure that you have a recent backup...

SCCM 2007 R2 Reporting Services Online links by sthompson

I've found the following online resource links helpful in working with ConfigMgr 2007 SQL Server Reporting Services. SQL Server 2005 http://msdn.microsoft...
Filed under: , ,
More Posts Next page »
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems