Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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
5. 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
6. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... working!?) and eventually would display circa 3000 matching results. If I attempted to check this in "preview" mode using Business Intelligence Development Studio (BIDS / VS2008), the IDE would crash and ...; Created on 07 March 2014
7. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... files would speed things up). Applies to: Microsoft Windows XP Microsoft Windows 7 Microsoft Windows 8 for Vista and Windows 2008 without XCOPY, try ROBOCOPY. How? We're going to use ...; Created on 23 February 2014
8. 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
9. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; Applies to: Microsoft Business Intelligence Development Studio 2008 (BIDS) Microsoft SQL Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created ...; Created on 22 November 2013
10. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; Applies to: Microsoft Business Intelligence Development Studio (BIDS) Visual Studio 2008 Microsoft Windows 7 Microsoft .NET Framework 3.5 Microsoft Visual C# 2008 What? So like lots of ...; Created on 04 October 2013
11. Compare two databases using T-SQL: / Transact-SQL /; Applies to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without ...; Created on 24 September 2013
12. Restore MSSQL Error: Database is in use: / Databases /; ... in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL connected processes as well. Why? For every DBA this is a doddle and doesn' ...; Created on 08 March 2013
13. Administrator Program Shortcut without Prompt: / Windows OS /; ... checkbox Run with highest privileges. set "Configure For" to Windows 7, Windows Server 2008 R2 Under the Actions tab, Click on New... Leave "Action" as Start a program for Program/Script, ...; Created on 25 February 2013
14. Generate Academic Calendar using MySQL: / MySQL /; ... (SQL Server 2008 R2) for CMIS Facility SELECT calendar.WeekNumber AS AcademicWeek, CAST(DATEPART(dd, calendar.StartDate) AS VARCHAR(2)) + '-' + SUBSTRING(DATENAME(mm, calendar.StartDate), ...; Created on 27 November 2012
15. Search a database with SOUNDEX: / Databases /; ... containing strings in the database and we are somewhat limited in Sql Server 2008 R2 by 4000 characters in a variable (so I couldn't store it in a local variable). So the idea here is to run the below ...; Created on 11 October 2012
16. 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
17. 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
18. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... v2008 (BIDS) SQL Server Reporting Services v2008 R2 (SSRS) Oracle SQL Developer v3 (you can use any equivalent, eg. SQL*Plus) Why? I think this is one of those very rare occasions that Microsoft ...; Created on 19 January 2012
19. Basic Oracle Stored Procedure Structure: / Oracle PL/SQL /; Previously For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in ...; Created on 16 January 2012
20. 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