Search - Joel Lipman .Com

1. Room Availability Calendar in Business Intelligence Development Studio: / SQL Server Reporting Services /; Well I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing ...; Created on 23 March 2011
2. SQL Calendar in Business Intelligence Development Studio: / Transact-SQL /; So I find myself searching the web for a way of producing an outlook-style calendar within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally ...; Created on 14 January 2011
3. Accessing a MySQL Database with Business Intelligence Development Studio: / MySQL /; Well I tried the SQL Server Management Studio solution to connect to a MySQL database then lost my way wondering what was I trying to achieve? I've written this article because this is how I connected ...; Created on 05 January 2011
4. Mediawiki Extension for Camtasia Studio SWF videos: / MediaWiki /; ... :c) This article shows you how to get your MediaWiki system to display your Camtasia Studio SWF files in it's articles. Why Camtasia when there are other free options? We tried lots of FLV players ...; Created on 08 October 2009
5. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Global Illumination Silhouette Sketched Soft Lighting Studio Lighting Sunbeams X-Ray Volumetric Lighting Famous Artist Styles I've tried to list artists here who have styles that I could not ...; Created on 11 February 2023
6. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... is required - includes Zoho One) macOS Catalina v10.15.7 Safari v14.0 MS Visual Studio Code v1.48.2 Prerequisites Download nodejs source code from https://nodejs.org/en/download/. Don' ...; Created on 24 October 2020
7. Android OS: Add GoogleMap as fragment: / AndroidOS /; Applies to: Android Studio (Beta) 0.8.9 Android Google Maps v2 What? A sequel to my article "Basic Android App using Google Maps and Current Location", this article suggests how to add Map as ...; Created on 25 November 2014
8. Android: Function to let user take photo or choose existing: / AndroidOS /; What? A quick article on a function to allow the user to take a photo using their built-in camera or to choose an existing photo from their gallery. Why? I wanted both options to be available ...; Created on 04 November 2014
9. Android: Keytool and Google Maps displaying grey: / AndroidOS /; Applies To: Microsoft Windows 7 Pro Android Studio v0.8.6 beta Java Development Kit v1.8.0_20 What? The article below serves as a checklist to ensure I don't release an app that only displays ...; Created on 31 October 2014
10. 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
11. Include a carriage return in a column heading: / SQL Server /; ... you refresh the data, it will retain the carriage return in the column headings. Additional: Only appears obvious in SQL Server Management Studio resultset. Remember to format the cells (column ...; Created on 07 July 2014
12. 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
13. 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
14. 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
15. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... world. Where do the extra 9 minutes come from? Not the SQL as this runs in 00:00 seconds in SQL Server Management Studio. Not the internal processing and rendering as the report server says it did this ...; Created on 07 March 2014
16. 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
17. 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
18. 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
19. SSIS Convert a string into a date: / SQL Server Integration Services /; ... + " 00:00:00") So although your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833) ...; Created on 14 March 2013
20. Restore MSSQL Error: Database is in use: / Databases /; ... warrant its own article but for those of us who merely use SQL Server Management Studio (SSMS) and Microsoft's SQL Server 2008 R2 for development purposes, the once-in-a-blue-moon restore from backup process ...; Created on 08 March 2013