Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 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 to a MySQL database from within the Business Intelligence...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Mediawiki Extension for Camtasia Studio SWF videoshttps://joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 easier to write than Joomla CMS ones :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 that were usually...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB

SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 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 we would like this linked to events in a database. I'm...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 Low Key Light Moody Lighting Moon Light Natural Lighting Ray Tracing 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...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 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 1 day with the hours on the top. Working hours...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Administrator Program Shortcut without Prompthttps://joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 with Local Administrator Privileges (required for setup) Why? Our work has group policies and two of our programs, Visual Studio 2010 Ultimate (VS2010) and Business Intelligence Development Studio (BIDS), require elevated or administator...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 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 people on the net, I've been given a datasource with names and addresses all...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Basic Android App using Google Maps and Current Locationhttps://joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 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 on creating an app which opens Google Maps at your current location....

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 Zoho Creator v5 (Plan Premium or greater 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't worry about knowing...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Joes DNS Correction (JDC)https://joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 to access and your usual solution is a reboot, then this tool may be for you. In my environment, I am working with a Visual Studio 2008 IDE (Business Intelligence Development Studio - BIDS) along with Microsoft's Team Foundation Server (TFS). Sometimes...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Restore MSSQL Error: Database is in usehttps://joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 For every DBA this is a doddle and doesn't 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 is...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Compare two databases using T-SQLhttps://joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 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 having to download any third-party products. Why? I googled and...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 the real 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 in 0.4 seconds. So where's the problem?...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSRS Stop Scrolling Behindhttps://joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 to: Microsoft SQL Server Reporting Services (SSRS) 2008 R2 Microsoft Visual Studio 2012 Microsoft Business Intelligence Development Studio What? I recently revamped our standard report with a new template comprising of a single Tablix which contained...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Android: Keytool and Google Maps displaying greyhttps://joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 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 maps to myself (again). Why? This took me a while to figure out so...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Error during processing - Converting Date/Timehttps://joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 would happen in Report Builder 2.0 which I've stopped using as my day job wants us to use Business Intelligence Development Studio for all our SQL Server Analysis Service (SSAS) and Reporting Service (SSRS) projects/solutions. The features and interface...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Create Read-Only Database User in SQL Serverhttps://joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 describes how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security > Logins. Right-click on the user who will be set as having read-only...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

Returned a data type that is not validhttps://joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 to t1.Date AS Month This will return the SQL date but using your report builder or business intelligence development studio, you can specify in the report designer how to format the returned value to a more user-friendly date format (such as Month name...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 wrong direction with a convincing SQL script. This article is just a note on when using Business Intelligence Development Studio (BIDS) or Report Builder 2.0 and when previewing the report, the parameters are not accounted for (ie. the SQL query...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

URL passed settings in Reporting Serviceshttps://joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 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 button next to it to edit. Visit http://odetocode.com/code/128.aspx Issues encountered...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB