Houston, you have a problem. Quickly backup your Windows Event logs with the following commands – this example will export the Application and System event logs to two seperate files into the C:\logs folder using the built in wevtutil Windows tool.
You have made changes to your backend reporting database, rerun your Report Preview but the values havn’t changed ! One of best recommendations I can make to SQL 2012 Reporting Services developers is to disable preview caching on the development machine. Of course you won’t want to change this in production, however in your dev […]
The following example demonstrates how to gather the database id along with sysfiles metadata using the procedure sp_msforeachdb. This could be useful to collect both a detail and a summary view of database file footprint. This will allow you build a view of the total database size by doing a sum of the file sizes […]
You need to convert an incoming string formatted date from a flat file into a date datatype in SSIS. The following example demonstrates how to convert a flat file date in the format “DD/MM/YYYY” into the ISO format YYYY-MM-DD, where it can be converted to a Datetime data type by DT_DBTIMESTAMP. Nulls and partially populated strings (e.g. a date without leading […]
You have a SSIS .DTSCONFIG file you want to edit however the xml displays as one long formatted line. Open the .DTSCONFIG file in Visual Studio, do a Ctrl + K then a Ctrl + D. This will format the xml nicely without the requirement for third party tools.
After living in virtual machines more recently someone cool reminded me about this trick to enable Sharepoint 2010 install on a Windows desktop. The full McCoy is here … http://msdn.microsoft.com/en-us/library/ee554869.aspx but essentially extract the sharepoint install pack to your local file system, locate the config.xml file in the ..\files\Setup\ folder of the Sharepoint install. Add […]
This is a quick snippet showing how to convert a string to sentence case (first letter capitals and the rest lower case). Execute function like this … A good post here from PinalDave showing how to convert to Title case http://blog.sqlauthority.com/2007/02/01/sql-server-udf-function-to-convert-text-string-to-title-case-proper-case/.
You would like to reverse the sort order of a particular filter in Performance Point – lets just call it “Year”. When Performance Point 2010 was released it brought with it new sort and filter features – however these do not extend to Performance Point filters – sob http://blog.gnetgroup.com/bi/2010/12/16/new-sort-and-filter-features-in-performancepoint-2010-dashboard-designer/. Neat post from SQLChick describing how […]
Tracked this post http://www.olomon.com/wp/2012/06/27/ssrs-solution-to-size-necessary-to-buffer-the-xml-content-exceeded-the-buffer-quota-error/ down when looking into what looks to be a newish error in SQL Server 2012 Reporting Services. You select Preview on the report and get the error “size necessary to buffer the XML content exceeded the buffer quota”. The blog discuss a good workaround approach. In my case, fields referenced within an […]
Add a secondary Y Axis to your Reporting Services Chart quickly and easily as follows…. First, add the 2nd value to your chart as another series. Now right click on the new series in the chart area, and select Series properties. In the Axes and Chart Area tab, under Vertical Axis select “Secondary”. Reference http://technet.microsoft.com/en-us/library/dd207018.aspx.