Search - Joel Lipman .Com

21. Basic Android App using Google Maps and Current Location: / AndroidOS /; Applies to: Android Studio (Beta) 0.8.6 Google Android Maps API What? I am writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely ...; Created on 10 October 2014
22. SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issue: / SQL Server Integration Services /; ... was for me: Open Start > All Programs > SQL Server 2012 (or your latest) Expand "Configuration Tools" and open "Sql Server Configuration Mnaager". Right-click on "SQL Server Integration Services 10.0" ...; Created on 09 June 2014
23. Convert to Proper Case in T-SQL: / Transact-SQL /; ... John Smith-Jones HEAD OF IT SERVICES Head of IT Services FLAT 123A Flat 123A MRS. O'CONNOR-MCDONALD Mrs. O'Connor-McDonald ORG_DEPT_STATUS Org_Dept_Status SEND.HELP.NOW Send.Help.Now PO BOX 1234 PO ...; Created on 04 June 2014
24. SSRS Display question mark when date is blank: / SQL Server Reporting Services /; Applies to: Microsoft SQL Server Reporting Services 2012 Microsoft Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. ...; Created on 15 April 2014
25. SSRS No Delay for First Report of the Day: / SQL Server Reporting Services /; ... do this: On the server, open the XML file: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\RsReportServer.config Set the recycle time to 0: 0 Restart the ...; Created on 11 April 2014
26. SSRS Stop Scrolling Behind: / SQL Server Reporting Services /; Applies to: Microsoft SQL Server Reporting Services (SSRS) 2008 R2 Microsoft Visual Studio 2012 Microsoft Business Intelligence Development Studio What? I recently revamped our standard ...; Created on 08 April 2014
27. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; What? This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. ...; Created on 07 March 2014
28. Joes Password Analyzer (JPA): / Product Documentation /; What is Joe's Password Analyzer? Joe's Password Analyzer is an online tool that quickly checks any password you might want to try using and suggests variations on this. Simply type a word or phrase ...; Created on 03 January 2014
29. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... letter in addition to the above specification. I am storing it here so that I can work on improving it: /* Microsoft SQL Server Integration Services Script Component * Write scripts using Microsoft ...; Created on 04 October 2013
30. Fix Oracle Tnsping 3511 without Windows Registry: / Oracle PL/SQL /; ... as we have different products/services and these run off various instances of Oracle 9i, 10g, and 11g. This article was written for those that need to support these kind of systems and not as an invite ...; Created on 04 March 2013
31. Free Translator API using Google: / Google /; What? So this is a quick article to get your Google Translation services working with your website. Why? At time of print, Google now charge for every 2,000,000 characters (2 million) every month. ...; Created on 08 January 2013
32. Setup a copy of your Joomla website: / Joomla /; ... on the services available to my client: Copy all files of your main website to another folder. Setup an FTP account to the new folder created in the previous step. Copy the database of your main ...; Created on 19 December 2012
33. Battery Constantly Drained on iPhone: / Apple /; ... first place: The empty arrow next to the battery indicator tells you that location services is enabled but it is attached to a reminder that needs to constantly monitor your whereabouts in order to ...; Created on 27 November 2012
34. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... result set. Furthermore I am using this stored procedure in a SQL Server Reporting Services (SSRS) environment and don't want to return any rows if there are no matches (not a blank row either) as ...; Created on 24 January 2012
35. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... Services (SSRS). Well "non-productive" more than "fun" as most of the examples on the net are either half-complete or partially documented. So here goes... Using Business Intelligence Development Studio ...; Created on 19 January 2012
36. Basic Oracle Stored Procedure Structure: / Oracle PL/SQL /; ... and aah-ing, I have written this article as a note for me to demo a working stored procedure and how to use cursors. I'm told I need to use this for SQL Server Reporting Services (SSRS) which is why I' ...; Created on 16 January 2012
37. Performance Report - Background colors based on dataset values: / SQL Server Reporting Services /; Why? I've recently written a report for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able ...; Created on 02 December 2011
38. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; How to Display Report Execution Time in SQL Server Reporting Services 2008 R2 So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular ...; Created on 17 November 2011
39. SSRS Zero Padding: / SQL Server Reporting Services /; ... have a database using Oracle 10g, and a SQL Server Reporting Services v2008 R2 environment. My use for this was when displaying an audit log displaying the oracle errors. Oracle Errors An Oracle ...; Created on 10 November 2011
40. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server Reporting Services /; What? We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is ...; Created on 04 November 2011