Connection Strings for SQL Serverhttp://mail.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 Data Provider for OLE DB Type: .NET Framework Wrapper Class Library Usage: System.Data.OleDb.OleDbConnection Manufacturer: Microsoft Bridging to MySQL OLEDB This is just one connection string sample for the wrapping OleDbConnection class that calls the...

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

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

05 January 2011 this is how I connected to a MySQL database from within the Business Intelligence Development Studio (BIDS) IDE from Microsoft. Required: Windows XP (ODBC Data Source Administrator) MS Business Intelligence Development Studio 2008 Test/Sample MySQL...

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

Formatting a date in an MDX queryhttp://mail.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 yyyy HH:mm:ss") =Format(now(), "dd/MM/yyyy") The reserved expression letters used are on the MSDN website at http://msdn.microsoft.com/en-us/library/ms146084.aspx NOW() vs TODAY() Noticed this when setting date as the parameter and trying to specify...

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

CSS Background Without Causing Scrollbarshttp://mail.joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 255); /* RGBa with 0.6 opacity */ background: rgba(255, 255, 255, 0.6); /* For IE 5.5 - 7*/ filter:progid:DXImageTransform.Microsoft.gradient(startColorstr=#ff000000, endColorstr=#ff000000); /* For IE 8*/ -ms-filter:...

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

Basic Webpage Controls with JavaScript / COMhttp://mail.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 if no parameter Name := ( Name="New Tab - Windows Internet Explorer" ) ? "about:Tabs" : RegExReplace( Name, " - (Windows|Microsoft) Internet Explorer" ) For pwb in ComObjCreate( "Shell.Application" ).Windows If ( pwb.LocationName = Name ) && InStr(...

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

SSRS External Images don't displayhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 image. Solution #1: Image does not appear within SSRS Configure the Unattended Execution Account: According to Microsoft and Stack Overflow, your reporting server needs to have the "unattended execution account" configured. Some sources are specific...

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

Proposed Budget i3 PC under £200http://mail.joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 we'll skip Windows 8 and wait for Windows 9, but in the meantime we need something that flows as smooth as any other Microsoft product with Windows 7 as its Operating System: Proposed for January 2013 (5 suppliers) Processor Intel Core i3 3220 Dual Core...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Cheat Sheet for mySQL vs t-SQLhttp://mail.joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 AS Rownum LIMIT from_index, number_of_rows ROW_NUMBER() OVER(ORDER BY column_name ASC) AS Rownum Source(s): MSDN Microsoft Library (DATEPART (Transact-SQL)) MSDN Microsoft Library (DATENAME (Transact-SQL)) MySQL Documentation - String Functions MySQL...

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

SSIS Skip Rows in Excel Source filehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 are not blank/null. Browsing the net, I found this is sometimes also used for inserting blank rows to act as dividers. Microsoft Certified Responses: "In the Excel connection you cannot skip Nth rows." "It is not possible." I am shocked at how responses...

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

MS Excel - Sort pivottable column headings by datehttp://mail.joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The excel...

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

SSIS Skip Blank Rows in Flat File Sourcehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code...

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

Compare two databases using T-SQLhttp://mail.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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttp://mail.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 to: Apple iOS 7 Apple iTunes 11.1.3.8 Microsoft Windows 7 Professional What? Just so many articles out there that did not help me. This article is how I finally did mine. Why? I had paid for some apps on my old phone and realized that if I didn't do a...

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

T-SQL functions to convert Strings to Tableshttp://mail.joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

20 August 2014 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's start with a function that just converts a string of words delimited by...

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

A quick run through of setting up an export process in SITShttp://mail.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 to SITS:Vision v8.7.0 Uniface v9.6.03 Microsoft Windows 7 Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 What? "Quick" may not be the right word, so this is a somewhat summarized article on how to get data out of SITS, up to running the monitors and...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

AutoHotkey: App GUI Listview to Rename Fileshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 to: Microsoft Windows 7 Professional - Service Pack 1 AutoHotkey v1.1.33.02 What? So this is the documentation for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to rename...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttp://mail.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 PSU Cooler Master V750 SFX Gold White Edition 1 £120.00 AIO ID-Cooling Zoomflow 240X Snow CPU Water Cooler 1 £74.99 O/S Microsoft Windows 11 Pro 64-bit 1 £219.99 Case Fans CoolMoon 3 Pack 120mm Crystal 3 @£28.99 Monitor Cable KabelDirekt - DisplayPort...

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

Add "Command prompt from here" to right-click context menuhttp://mail.joellipman.com/articles/microsoft/windows-os/add-command-prompt-from-here-to-right-click-context-menu.html

27 January 2010 to: Microsoft Windows XP How? I keep having to do this every year as I reghost all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I...

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

SSRS No Delay for First Report of the Dayhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-no-delay-for-first-report-of-the-day.html

11 April 2014 server that requires it. Let your report server administrators do this: On the server, open the XML file: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\RsReportServer.config Set the recycle time to 0: 0 Restart...

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

Windows 7: System Clock is constantly going out of synchttp://mail.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 it doesn't display the right date/time. The Quick Fix First off, check there aren't any Update for Windows 7 releases at Microsoft's Windows Update The Long Fix Now below are the notes I've had to try and fix this before (personally it was because...

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