Browse by Tags

All Tags » SQL (RSS)

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: , ,

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 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: ,

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: , ,

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

Count all instances of software registered in Add/remove programs while excluding publishers by sthompson

Received the following question: I want to make a report that list everything from add/remove programs and do a count like the report : “Count of all instances...
Filed under: , , ,

How to show ALL in a report dropdown list by sthompson

Wrote a report recently where I needed an ‘ALL’ selection included for a report parameter with a standard list of items from a query.  This technique...
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...

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: ,

Need a text editor... try ConTEXT by sthompson

There are a lot of text editors out there, in case you were looking for a good, free editor - my favorite text editor by far is conTEXT. Did I mention...
Filed under: ,

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

How to list static values in a query by sthompson

Received an interesting question recently from a friend: ~~~ Currently this query does not work. Basically all I want is this query to return all of the...
Filed under:

SQL Views documentation is Live! by sthompson

A while back, I was able to provide some assistance to Garth Jones in documenting the existing SMS/SCCM SQL Server views. Doug Eby, a Senior Technical...
More Posts Next page »
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems