-
by David Leibowitz
| July 28, 2008
|
Adding the Query Builder tab to the Filter Page in Outlook 2007 Outlook has an undocumented feature to add a query builder from within the custom filter tab in custom views. This is very useful in generating search strings in automation (VBA, VSTO, .NET, etc). Build the filter, then copy and paste into your code. To display the Query Builder page on...
-
by David Leibowitz
| July 28, 2008
|
With the new release of the Microsoft Office Outlook Connector 12.1 beta, you can manage your Microsoft Windows Live Hotmail or Microsoft Office Live Mail accounts, including e-mail messages, contacts and calendars for free! This works for Outlook 2003 and Outlook 2007 But notice I did not say synchronize, because it really isn't a sync utility...
-
by David Leibowitz
| June 25, 2008
|
Performing demo's over the web versus a F2F meeting is becoming more prevalent. Following are a list of some tools..all free. Yugma www.yugma.com Offers free cross-platform (PC, Mac, Linux) web conference, screen control, chat, and FREE audio conferencing for up to 15 attendees (long distance charges may apply..but you already have VOIP, right?...
-
by David Leibowitz
| June 17, 2008
|
In SQL Server 2005 Reporting Services you can Increase your Model reusability and development productivity by creating Perspectives. You then limit the usage of a Model only to those Perspectives, rather than the huge monster views. In Report Model designer, (BIDS), select the top node of the model called, "Model". In Properties, click the...
-
by David Leibowitz
| June 10, 2008
|
1. Ensure Office SharePoint and Windows Search service are enabled 2. Download & install Adobe Acrobat Reader 8.1 - which includes iFilter 3. Download the PDF icon (select 'small 17 x 17') from http://www.adobe.com/misc/linking.html and copy to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Images"...
-
by David Leibowitz
| June 10, 2008
|
I have an article on DevX that compares SQL Server 2008 Reporting Services performance to SSRS in SQL Server 2005, from an execution perspective as well as development. As it is currently in CTP, these things may change. Link to the article: SQL Server 2008 (Katmai) Reporting Services Performance: Two Steps Forward, One Step Back? http://www.devx.com...
-
by David Leibowitz
| May 30, 2008
|
You may recieve the error during the deployment of a Reporting Services model: There was an exception running the extensions specified in the config file. Maximum request length exceeded. To correct, you need to increase the file size limit currently in place in the web.config on the RS Server. Find the web.config file located in the directory: [SQL...
-
by David Leibowitz
| May 09, 2008
|
SQL Server 2005 Service Pack 3 (SP3) has been officially announced for release. The good news: sometime in 2008. The bad news: it won't be released until GA of SQL Server 2008. More here: http://blogs.technet.com/dataplatforminsider/archive/2008/04/15/sql-server-2005-sp3-coming-soon.aspx
-
by David Leibowitz
| May 08, 2008
|
Receiving the following error in SQL Server Integration Services? Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: " Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT...
-
by David Leibowitz
| April 24, 2008
|
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...
-
by David Leibowitz
| April 18, 2008
|
Trying to setup RSS feeds from a SharePoint feed might result in the error message "The RSS webpart does not support authenticated feeds." If you are ok with Kerberos security, do the following to fix: 1. Open SharePoint Central Admin 2. Click Application Management. 2. Under the Application Security section, click Authentication Providers...
-
by David Leibowitz
| April 18, 2008
|
If you find SQL Reporting Services web parts missing from your MOSS SharePoint installation, try the following to fix. This assumes you have SQL Server 2005 running on the same machine as MOSS 2007. If not, simply copy the RSWebParts.cab I show in the path below to your MOSS server. Then get to a command prompt on the MOSS 2007 box and use the following...
-
by David Leibowitz
| April 16, 2008
|
If you're like me, you need a little music streamed while you work. As a Sirius satellite radio subscriber, I get access to the free web stream. But if it suddenly stops working, you might have corrupt Windows Media Player Files (WMP). Here are the symptoms: Launch the player, select a channel and the status goes from Connecting... to Ready... Then...
-
by David Leibowitz
| April 09, 2008
|
You might get this error message after some report development in BIDS (Business Intelligence Development Studio). It's actually a Visual Studio issue..something that has to do with VSS...and you may be afflicted even if you aren't using VSS. The Error Message states exactly: --------------------------- Microsoft Visual Studio -------------...
-
by David Leibowitz
| March 27, 2008
|
When using the Script Transformation Editor in SQL Integration Services, you might want to pass in more than 1 variable to your script. Properties exist for ReadOnlyVariables and ReadWriteVariables, much like the Script Task Control Flow component. But there is one BIG difference. You may be used to syntax for multiple variable listings in the Control...