SSRS Zero Paddinghttps://joellipman.com/component/content/article/ssrs-zero-padding.html?catid=75&Itemid=165

10 November 2011 modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting Services v2008 R2 environment. My use for this was when displaying an audit log...

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

Problem creating SSRS report subscriptionshttps://joellipman.com/component/content/article/problem-creating-ssrs-report-subscriptions.html?catid=75&Itemid=165

11 November 2013 "New Data Source" Specify the details, especially the connection string (which the system account can use). Set "Connect Using" to "Credentials supplied by the user running the report". Browse to your report or upload it if it does not exist. Hover the...

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

SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

07 March 2014 not 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 close without warnings or notifications. We...

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

Include a carriage return in a column headinghttps://joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

07 July 2014 understand the carriage return and often return it as "AcademicWeek"). Other Search(es) Format a column alias with new line Using carriage return in column names New line Character in column alias

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

Remove write-protect from USB pen in Windowshttps://joellipman.com/component/content/article/remove-write-protect-from-pen-in-windows.html?catid=80&Itemid=165

13 April 2010 setup in windows XP is that it doesn't need it. Bulletproof, waterproof, fireproof, shockproof BUT NOT joe-proof!... I'm using windows 7 and my day-job machines tend to be windows xp. I found this solution on a windows xp machine so if the error...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

18 May 2010 to emulate their environment as accurately as I can which I can do by setting up my work computer to be just like theirs (using the same image, etc). Programs which I would NOT recommend I've put a list of programs which I installed and uninstalled just...

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

Print Directory Contents to a Filehttps://joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

19 July 2012 we add the "Command prompt from here" option (now built-in to Windows 7). I added this option for him in Windows 7 Ultimate using the system registry (see "How: for Windows 7" below). -- yield a_subfolder_in_this_folder a_file_in_this_folder.txt...

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

Windows Live Mail Error ID: 0x8DE00005https://joellipman.com/component/content/article/windows-live-mail-error-id-0x8de00005.html?catid=80&Itemid=165

14 December 2016 to: Windows Live Mail 2012 What? A quick article on how to update the Microsoft Live Server URL for Hotmail using Windows Live Mail. Well how to deactivate an account and set up a new one in Windows Live Mail. If you used IMAP all along then the new...

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

Windows OS: Alt Codes / Symbols / Special Charactershttps://joellipman.com/component/content/article/windows-os-alt-codes-symbols-special-characters.html?catid=80&Itemid=165

03 June 2021 be times when you have lost the formatting and get weird question mark characters instead such as: . How? Ensure you are using the numbers on your numeric keypad and NOT the numbers at the top of your keyboard for the following steps. Also check that...

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

Apple Magic Trackpad with Windows 11 Intelhttps://joellipman.com/component/content/article/apple-magic-trackpad-with-windows-11-intel.html?catid=80&Itemid=165

20 October 2025 by LinxHype (https://www.youtube.com/watch?v=J_z9-rE_6zI) so I don't want to take credit for it. There were other videos using the GitHub repo: GitHub / imbushuo / mac-precision-touchpad but those instructions seemed only for those on an AMD or ARM...

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

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

09 November 2010 following 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...

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

The ReportServer Databasehttps://joellipman.com/articles/else/database/the-reportserver-database.html

08 August 2011 columns (which measure in milliseconds) and convert to a time value with milliseconds showing. Now why don't these match? Using in an aggregate, how do I get the milliseconds between start and end times instead of summing the remaining columns?...

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

Search a database for a value and count matching rowshttps://joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 value. ** ** NOTE: This script can be run separate to a stored procedure by ** ** declaring @p_Value and @p_Column and using only the code ** ** from the BEGIN to the END (exclusive) - allows you to run ** ** this against any table only changing the...

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

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

08 March 2013 OK Searches ssms restore database in use Cannot drop database because it is currently in use Restoring a SQL Database Backup Using SQL Server Management Studio Unable to restore database "..because it is in use by this session." determine who is...

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

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

13 July 2010 you haven't done this silly mistake. I'm only guessing the same 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...

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

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

06 January 2011 ' ', YEAR(t1.Date)) AS Month Solved by changing 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...

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

T-SQL example of Case-Sensitive Soundexhttps://joellipman.com/articles/else/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 Additional Note how this also picked up typos in the 4th value which is good as I didn't want to overcomplicate things using LEVENSHTEIN and DIFFERENCE: SOUNDEX('Data Not Yet Available') = SOUNDEX('Daat oNt EYt Avialable')

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

Stored Procedure to List Distinct Values and Countshttps://joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF...

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

DataTumble - Randomize Data Rowshttps://joellipman.com/articles/else/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 V 0.01 ** ** Description: Stored Procedure to scramble Data in a column of a table. ** ** The process will mix the Data using a random function. ** ** Once the Data has been scrambled it won't be possible to get the original set of Data. ** ** ** **...

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

DataScramble - Randomizing data rowshttps://joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work with: Before: StudentID StudentName...

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