Administrator Program Shortcut without Prompthttps://www.joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

25 February 2013 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 rights/privileges when run. This is so that these programs can write...

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

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

08 March 2013 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 quickly forgotten. How? You need to set the database...

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

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

13 July 2010 error 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...

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

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

06 January 2011 SQL statement 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...

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

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

01 August 2012 your SQL Server Data" by John Magnabosco but tweaked for our purposes. NOTE that the following has only ever been run on development environments and I would not recommend running this on a production system as I have not tested the performance and...

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

Export/Import Database using MySQL Workbenchhttps://www.joellipman.com/articles/else/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 open MySQL Workbench. We're going to go on the basis that you already setup a connection to your database under the SQL Development section. Export/Import happens under the Server Administration section: Let's create a Server Instance, I'm going to...

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

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 up the monitors Log in to your application server and create the shortcuts to run the monitors (this is as per our development environment) The DOT Monitor should have a shortcut similar to the...

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

Accessing Apimo WebService APIhttps://www.joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

29 March 2016 using the GET method. Why? This was quite difficult to connect to and to determine what was wrong with each step of the development as the error messages were somewhat vague. I thought I'd quickly write this article so I don't have to spend so much time...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

30 September 2011 to his tricks... no it wasn't really, time was the issue. Additional conditions Direct access to our databases, both development and production, means that anyone with access to the Excel spreadsheet can go and view the connections and see the...

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

Checklist for the local computer repairshttps://www.joellipman.com/component/content/article/checklist-for-the-local-computer-repairs.html?catid=116&Itemid=165

28 April 2011 Cards Extra RAM (to charge for) Extra Cables (again to charge for) Service: Software installs at flat price Website development per hourly rate Computer repair per hourly rate "I always had work order forms in duplicate. Right above the signature line...

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

Joes WebGL Experimenthttps://www.joellipman.com/component/content/article/joes-webgl-experiment.html?catid=53&Itemid=165

06 April 2013 Experiments WebGL Globe which I think is beautiful; here's a screenshot of what I envisaged though: Demo It's still in development and a somewhat stable beta version is demo'd at http://demo.joellipman.com/joomla16/index.php/joes-infographic-for-joomla...

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

Two icons created on Androidhttps://www.joellipman.com/articles/else/app-dev/android-os/two-icons-created-on-android.html

20 October 2014 don't think I'll forget this one but I was stumped for a bit until I found it on the a forum: Stack Overflow: Android App Development. How? Basically don't have the following declared more than once in the AndroidManifest.xml

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

SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issuehttps://www.joellipman.com/component/content/article/ssis-cannot-open-data-flow-task-dts-pipeline-2-issue.html?catid=74&Itemid=165

09 June 2014 them suitable for our new SQL Server 2012 instances. How? This applies to a workstation (hopefully you're not doing development directly on the server). I re-installed sql server setup, re-ran the repair to no avail. A clue came from the MS site for an...

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

SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/component/content/article/ssrs-expand-specific-drilldown-by-default.html?catid=75&Itemid=165

23 February 2011 Server 2000 or SQL Server 2005. This 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 particular week. When...

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

SSRS - Lost window with datasetshttps://www.joellipman.com/component/content/article/ssrs-lost-window-with-datasets.html?catid=75&Itemid=165

25 March 2011 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. I spent a bit of time enabling/disabling toolbars...

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

SSRS Repeat Headers in PDF Reporthttps://www.joellipman.com/component/content/article/ssrs-repeat-headers-in-pdf-report.html?catid=75&Itemid=165

26 October 2011 same page. The same happens when I run this on the Reporting Server. My Setup - XP Workstation - Business Intelligence Development Studio 2008 (BIDS) - SQL Server Reporting Services 2008 R2 (SSRS) - PDF generated to a Windows File Share The Fix Click on...

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

Reminder on SSRS row separatorhttps://www.joellipman.com/component/content/article/reminder-on-ssrs-row-seperator.html?catid=75&Itemid=165

26 October 2011 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 row lists the day, date, room name, start/finish times, booking...

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

SSRS Subscriptions cannot be createdhttps://www.joellipman.com/component/content/article/ssrs-subscriptions-cannot-be-created.html?catid=75&Itemid=165

22 November 2013 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 because the credentials used to run the report are not stored, or if a...

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

SITS: XET format for Export not availablehttps://www.joellipman.com/articles/cms/website-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 as it will know what the data and label fields look like. How? I had this in my training environment but not in my development environment. I had to create a Data Exchange Format first: Run the DEF from the menu Clear and create a new one based on the...

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