Search - Joel Lipman .Com

21. Administrator Program Shortcut without Prompt: / Windows OS /; Applies to: - Microsoft Windows 7 Enterprise - User with Local Administrator Privileges (required for setup) Why? Our work has group policies and two of our programs, Visual Studio 2010 ...; Created on 25 February 2013
22. Access MySQL databases using Oracle SQL Developer: / MySQL /; ... I also need to use Oracle databases in my day job so the Oracle SQL developer is already a pre-approved software for our work computers. We have SQL Server Management Studio (SSMS) as well for our ...; Created on 01 February 2013
23. Deserialization and cannot checkout files in TFS: / Team Foundation Server /; Why? So I get back from annual leave and I can't check-out / check-in any files in a Visual Studio 2010 project. All my colleagues can. What? Rather silly I know and the solution is one of those ...; Created on 03 January 2013
24. Drop If Object Exists: / Transact-SQL /; What? Some people have been suggesting you can use "CREATE OR REPLACE ... VIEW ... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. ...; Created on 03 August 2012
25. How to change local folder for TFS: / Team Foundation Server /; What? I installed Business Intelligence Development Studio 2008 (BIDS) and connected it to a Team Foundation Server 2010 (TFS) instance and set my working local folder to my home directory. When the ...; Created on 08 March 2012
26. 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
27. Joes DNS Correction (JDC): / Product Documentation /; ... Studio 2008 IDE (Business Intelligence Development Studio - BIDS) along with Microsoft's Team Foundation Server (TFS). Sometimes I'll check out an item from TFS and before I get to update it, my ...; Created on 25 November 2011
28. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... here to the name of your report ORDER BY e.TimeStart DESC Deploy the report to the SSRS Run the report from MS Internet Explorer Check results using Microsoft SQL Server Management Studio (SSMS) ...; Created on 17 November 2011
29. Reminder on SSRS row separator: / SQL Server Reporting Services /; My Setup XP SP3 Workstation Business Intelligence Development Studio 2008 (BIDS) SQL Server Reporting Services 2008 R2 (SSRS) What do I want? I have a report displaying room bookings. Each ...; Created on 26 October 2011
30. SSRS Repeat Headers in PDF Report: / SQL Server Reporting Services /; ... - Business Intelligence Development Studio 2008 (BIDS) - SQL Server Reporting Services 2008 R2 (SSRS) - PDF generated to a Windows File Share The Fix Click on the down arrow icon near the ...; Created on 26 October 2011
31. SSRS External Images don't displa: / SQL Server Reporting Services /; ... Development Studio 2008 (BIDS) SQL Server 2008 R2 Reporting Server (SSRS) running on Windows Server 2003 Team Foundation Server 2010 (TFS) Problem #1: Image does not appear within SSRS When ...; Created on 19 September 2011
32. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... ORA-06512: at line 1 (System.Data.OracleClient) The Situation I'm using Business Intelligence Development Studio 2008 to develop a Reporting solution on a Windows XP workstation. We are connecting ...; Created on 02 September 2011
33. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; The situation is that we are replacing a website-application with a single SQL Server Reporting Services (SSRS 2008 R2) report. We're using Business Intelligence Development Studio (BIDS VS2008) with Team ...; Created on 19 July 2011
34. F_ck You. Pay Me.: / Web-Development /; ... of this. March 2011 San Francisco, CreativeMornings (creativemornings.com) was Mike Monteiro, Design Director, and co-founder of Mule Design Studio (muledesign.com). This event took place on March ...; Created on 14 April 2011
35. SSRS Templates in BIDS 2008: / SQL Server Reporting Services /; Open a Windows Explorer and make a duplicate of the report that you want to use as a template. Rename the copy (suffix with template?) Remove objects unique to the report and leave elements for all ...; Created on 01 April 2011
36. SSRS Hide results table if empty: / SQL Server Reporting Services /; ... this I would have called this article "Iteration within SQL Server Reporting Services Business Intelligence Development Studio (BIDS) version 2008 through combining Transact-SQL and MDX expressions" but ...; Created on 29 March 2011
37. SSRS - Lost window with datasets: / SQL Server Reporting Services /; Re: Business Intelligence Development Studio 2008 Often happens to me and not sure why. You open the project and the window panel for the Report Data containing the parameters and datasets isn't there. ...; Created on 25 March 2011
38. T-SQL DateTimestamps: / Transact-SQL /; My setup Windows XP SP3 MS SQL Server Management Studio 2008 SQL Server 2008 R2 Regional Setting: London BST (British Summer Time) Tuesday the 11th of October 2011 at 06:00am: CONVERT(CHAR(19), ...; Created on 23 March 2011
39. SSRS Expand specific drilldown by default: / SQL Server Reporting Services /; ... is how to do it in SQL Server 2008 and creating a report in Business Intelligence Development Studio (BIDS) or MS Report Builder. Scenario I have a report that specifies some room bookings for a ...; Created on 23 February 2011
40. URL passed settings in Reporting Services: / SQL Server Reporting Services /; ... the Toolbar (Advanced) To enter custom code for a report, view the report properties, the first field in Report Builder or Business Intelligence Development Studio (BIDS) is "Code". Click on the browse ...; Created on 11 February 2011