Author Archive
-
FIX: File Not Found on NewDwp.aspx in SharePoint when adding a web part
Receiving the following error in SharePoint or MOSS when you try to add a web part? File Not Found. at System.Signature._GetSignature(SignatureStruct& signature, Void* pCorSig, Int32 cCorSig, IntPtr fieldHandle, IntPtr methodHandle, IntPtr declaringTypeHandle) at System.Signature.GetSignature(SignatureStruct& signature, Void* pCorSig, Int32 cCorSig, RuntimeFieldHandle fieldHandle, RuntimeMethodHandle methodHandle, RuntimeTypeHandle declaringTypeHandle) -
T-SQL Tuesday (Date/Time Tricks) – Project Time Reporting Hack in SSRS
A HOW TO illustrating a method to display project time data in SQL Reporting Services. While there is no native GANTT chart control in SSRS 2005/2008, you can still do this with a little creativity and determination. -
Suppress Auto Update of MDX Parameter Datasets in Reporting Services 2008
With the MDX Query Designer in Reporting Services SSRS 2008 Report Designer and Report Builder 2.0, changing the main dataset overwrites the parameter datasets, which will kill any manual adjustments you've made. Bummer. But you can fix that. -
FIX: Quick Launch Bar Navigation Missing From Web Part Pages in SharePoint
It's rather disturbing that the Left Side Navigation (Quick Launch) by default, does not display on new web part pages created in SharePoint. There are a number of workarounds on the web which include hacking each newly created page, or hacking an existing document template. -
FIX: Cannot connect to MICROSOFT##SSEE database
If you can’t connect to the MICROSOFT\SS… Read the rest
-
FIX: SQL Server Stuck in Single User Mode – And You Can’t Get In
Ever get a SQL Server 2008 database stuck in SINGLE_USER_MODE, then find you can't maintenance it, access it, and even SP_WHO2 fails? Maybe you dropped it into SINGLE_USER_MODE to perform a DBCC CHECKDB type of repair, then tried to access it again and voila...you're not the only one in the database. This could happen in a number of scenarios, but a typical one in a SharePoint environment is the SEARCH database. -
Advanced String Building Expressions in SharePoint Workflows with SQL
Building a Dynamic String in a SharePoint workflow is severely limiting. You can only use placeholders, and forget about expressions like LEFT(), RIGHT(), REPLACE() or SUBSTRING(). It’s almost worthless. Not anymore. Not only can we do that now, but we can apply any T-SQL script or procedure in a SharePoint workflow. -
FIX: An unexpected error has occurred, Web Parts Maintenance Page
Fix for the following error: An unexpected error has occurred. Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator. -
HOW TO: Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode)
Reporting Services provides predefined content types that are used to manage shared data source (.rsds) files, report models (.smdl), and Report Builder report definition (.rdl) files. Adding a Report Builder Report, Report Model, and Report Data Source content type to a library enables the New command so that you can create new documents of that type. -
Monitor and Analyze Multiple SSRS Instances with SQLScrubs
The following article details how to analyze and monitor multiple SQL Reporting Services instances with SQLScrubs. SQLScrubs Community Edition is available for free and can be found on CodePlex. All extraction for instance related data is managed by the SSIS package and stored in the datawarehouse provided. You can analyze in your own reports, enhance some of the free reports to do this for you, or simply upgrade to the Premium Edition of SCRUBS for SQL Server 2008 which provides over 15 additional reports with built-in analysis by instance.
