Search - Joel Lipman .Com

41. T-SQL functions to convert Strings to Tables: / Transact-SQL /; Applies to: Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 What? These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let' ...; Created on 20 August 2014
42. SSIS Multiple Lookups in one: / SQL Server Integration Services /; ... convert the data and output it to the target system. For our package to decode what "M" means, it needs to look this up in a table on the original server. We had around 12 lookups to do, so you could ...; Created on 05 August 2014
43. Include a carriage return in a column heading: / SQL Server /; Applies To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). ...; Created on 07 July 2014
44. SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issue: / SQL Server Integration Services /; ... Studio 2008, 2010 and 2012. VS2008 for our old SSIS packages and VS2010 for database solutions running against SQL Server 2008 R2. We can use VS2012 for both but this requires upgrading all the packages ...; Created on 09 June 2014
45. 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
46. SSRS No Delay for First Report of the Day: / SQL Server Reporting Services /; What? This article describes a solution our reporting server administrators found to cut the loading time of the first report of the day. Why? Take any SSRS report, if one of us was the first ...; Created on 11 April 2014
47. 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
48. JComments 2.3.0 with ReCaptcha in Joomla 2.5.x: / Joomla /; ... up-to-date as some Joomla 2.5.x systems will not have updated this: Open the file \plugins\captcha\recaptcha\recaptcha.php See if you have the line const RECAPTCHA_API_SERVER = "http://api.recaptcha.net"; ...; Created on 20 March 2014
49. 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
50. Registered Users Cannot Login - Super Users Can: / Joomla /; ... Open the #__assets tablewhere #_ is the Database Tables Prefix value found by logging into your Joomla admin panel Browse to Site > Global Configuration > Server > Database Settings : Database Tables ...; Created on 26 February 2014
51. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... destination [file [file]...] [options] source :: Source Directory (drive:\path or \\server\share\path). destination :: Destination Dir (drive:\path or \\server\share\path). ...; Created on 23 February 2014
52. Joes Password Analyzer (JPA): / Product Documentation /; ... without sending or receiving data to a server. The page used to be a part of a Password Security System I wrote back in 2008 and I missed the analysis capability so I have restored it on my personal website. ...; Created on 03 January 2014