Thoughts and experiences of a DBA working with SQL Server and MySQL. How To Use SQL to Convert a STRING to an INT. How to set up MySQL Replication Tutorial. How to Use SQL CASE for Conditional Logic in Your SQL Queries. Using ISNULL in SQL Server to Replace NULL Values.

Occasional notes of typical DBA day-to-day work. Non-clustered indexes can be as many as 249 per table for older SQL server versions and up to 999 for 2008 versions. Or letter range, ex A.

Get reliable, 24 X 7 database administration services across all major database platforms. Highest level of protection and responsiveness in a cost-effective package. The Infrastructure Management Services Company.

Not got a password? If you have not used this site before please register. Logging in allows you different privileges depending on who you are. Are you an employee of a DBA Member company? If yes, your password will allow you access to the Members-only helpful guides and advice. If you are a designated staff member, with appropriate access rights, you will be able to access and update all areas of your agency profile in the DBA Directory. Not a DBA member or a client? .

Creating an ASM Instance and Migrating a NON-ASM d. Currently working for dba DIRECT as a Sr. Oracle Applications DBA Starting versions from 11. I am Oracle 10g and Oracle apps 11i certified consultant. Thursday, March 24, 2011. Creating an ASM Instance and Migrating a NON-ASM database to ASM database in windows.