Search - Joel Lipman .Com

1. Databases: / Category /; Created on 05 March 2020
2. Compare two databases using T-SQL: / Transact-SQL /; Applies 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 ...; Created on 24 September 2013
3. Access MySQL databases using Oracle SQL Developer: / MySQL /; What? So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04. Why? I've used various mySQL administration tools to manage mySQL databases over the years, ...; Created on 01 February 2013
4. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; Applies to: PHP 5.4 MySQL 5.1.4 Databases initially setup with collation 'latin1_swedish_ci' What Another article trying to help people display foreign characters on their website without ...; Created on 25 January 2016
5. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... settings will be enabled and the ID is in the URL. We will insert assets as new ones but associate these to the v25 assets. Categories will be associated by comparing both databases' content tables. ...; Created on 12 September 2015
6. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to recover the data and present it in a report, which would average about ...; Created on 07 March 2014
7. Fix Oracle Tnsping 3511 without Windows Registry: / Oracle PL/SQL /; ... matched the TNSNAMES.ORA file located in "C:\ORACLE\product\11.2.0\client_1\network\admin". Furthermore I've been asked why aren't all our Oracle databases the same version? It's due to the fact that ...; Created on 04 March 2013
8. Search a database for a value and count matching rows: / Databases /; ... Issues Consider adding a drop of the temporary table to the start of this script if you plan on running this successively against several databases: DROP TABLE #CountRecordsPerTablePerCol or ...; Created on 05 November 2012
9. Search a database for a string (MySQL, T-SQL): / Databases /; ... UPDATE @SQLTbl SET Execstatus = 1 WHERE Tablename = @tmpTblname END SET NOCOUNT OFF GO MySQL Source: http://kedar.nitty-witty.com/blog/search-through-all-databases-tables-columns-in-mysql ...; Created on 08 October 2012
10. DBMS Random Reference: / Oracle PL/SQL /; What? How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing ...; Created on 21 August 2012
11. Migrate Joomla Users to WordPress: / Wordpress /; ... Note that your database user should have access to both databases in order for this to run smoothly: INSERT INTO my_wordpress_db.wp_users (ID, user_login, user_nicename, user_email, user_url, user_registered, ...; Created on 03 October 2011
12. Stop Excel Row Height Self-Adjust on Refresh: / Excel /; ... in adjusting row height would be like a magician revealing the secrets to his tricks... no it wasn't really, time was the issue. Additional conditions Direct access to our databases, both development ...; Created on 30 September 2011
13. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... the executives. SQL query returns individual items while Excel allows drag and drop grouping/drilldown pivot tables. Have managed to get this working with SQL Server, Oracle and MySQL databases... Now ...; Created on 24 August 2011
14. T-SQL DateTimestamps: / Transact-SQL /; 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), ...; Created on 23 March 2011
15. Developer's Checklist: Taking over a projec: / Web-Development /; ... goes in, what comes out? (accepts/returns, data types specifically, test by running each function separately) Examine databases (data types, constraints, primary/foreign keys, autoincrements, schema ...; Created on 01 March 2011
16. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... your favorite database management tool (phpMyAdmin, workBench, navicat, sqlyog?) and connect to the new database. This script will use both databases, reading from the old Joomla database and writing ...; Created on 30 January 2011
17. MySQL Commands to display all columns: / MySQL /; ... The following is a MYSQL query that displays the structure of all the columns in all the databases of the localhost: SELECT * FROM information_schema.COLUMNS ORDER BY TABLE_NAME, COLUMN_NAME ...; Created on 28 October 2010
18. Project Plan for Freelance Website: / Web-Development /; ... CMS version (if it has to be purchased, discuss with client) Install the CMS with respective databases for the LIVE system Install the CMS with respective databases for the TEST system ...; Created on 25 February 2010