Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming joel is required, the following 661 results were found.

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

    The 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...

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

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

    Amazing, I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation as to what this database is and how it...

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

  3. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    What? I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search...

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

  4. Cheat Sheet for mySQL vs t-SQLhttps://www.joellipman.com/articles/else/database/cheat-sheet-for-mysql-vs-t-sql.html

    Some memory aids for me so that I don't have to keep looking them up: MySQL T-SQL Strings String Replace REPLACE(haystack,needle,replacement) REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [,...

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

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

    What? This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO --...

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

  6. Reorder Columns in a Tablehttps://www.joellipman.com/articles/else/database/reorder-columns-in-a-table.html

    What? Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns...

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

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

    Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done...

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

  8. 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

    Thought I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during...

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

  9. Formatting a date in an MDX queryhttps://www.joellipman.com/articles/else/database/t-sql/formatting-a-date-in-an-mdx-query.html

    Thought I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The other formats are: =FormatDateTime(Fields!BirthDate.Value,...

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

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

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

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

  11. T-SQL DateTimestampshttps://www.joellipman.com/articles/else/database/t-sql/t-sql-datetimestamps.html

    My setup Windows XP SP3 MS SQL Server Management Studio 2008 SQL Server 2008 R2 Regional Setting: London BST (British Summer Time) Tuesday the 11th of October 2011 at 06:00am: CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) Oct 11 2011 6:00AM CONVERT(CHAR(8),...

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

  12. Zoho Deluge - Regex to Strip all non-numeric charactershttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-regex-to-strip-all-non-numeric-characters.html

    What A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above...

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

  13. Zoho Deluge - Get Current User IDhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-current-user-id.html

    What? This is a quick article on different ways to get the current user ID in Zoho through code. How? I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this...

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

  14. Zoho Deluge - Get User Timezone, Country and Locationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-user-timezone-country-and-location.html

    What? A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The...

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

  15. Zoho Deluge - Pad with leading Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-pad-with-leading-zeros.html

    What? There may be other articles out there documenting this but I can't keep trying to find these in Google so referring to my own website, this is a doddle for me to find each time. Why? I have to do this so often that it deserves an article. Though...

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

  16. T-SQL Record Separatorhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on my computer" and me replying "why would you want to do...

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

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

    This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on...

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

  18. Zoho Deluge: Convert Map to URL Parametershttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-map-to-url-parameters.html

    define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id"); m_Payload.put("redirect_uri","https://www.joellipman.com"); m_Payload.put("response_type","code"); m_Payload.put("scope","my_api_scopes");...

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

  19. Drop If Object Existshttps://www.joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html

    What? Some people have been suggesting you can use "CREATE OR REPLACE... VIEW... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various...

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

  20. Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/else/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

    Why? Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
Results 381 - 400 of 661