AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() ![]() If you come from a predominantly Oracle background, then you will be interested in a fine series on Crossing the Great Divide from Oracle to SQL Server by Jonathan Lewis. It can be quite an initial shock to move from one RDBMS to another. Oracle 11g R2 and Developer 2.1 – The Latest Toys from the Oracle World Being multilingual myself, I was briefly tempted to give this article the long-winded title “ Applying the Principles of a Polyglot to Database Management: How Shrewd DBAs Benefit from MySQL and Oracle, Over and Above SQL Server”. ![]() In the same way that knowing several languages can help you to know your own language better, I believe that taking the deep dive into another RDBMS can also broaden your approach to resolving problems in your ‘native’ RDBMS. If you want to become what I describe as a polyglot of databases, equally confident in a range of RDBMSs, you must first have an excellent grasp of the fundamentals of RDBMSs, such as normalisation and indexing, and understand the importance of certification and practice. Surely, any Database Administrator who really understands databases and SQL standards could work quite well with any of the leading Relational Database Management Systems (RDBMS). However, I’d like to argue that DBAs should diversify as a way to improve their marketable skills or competitiveness, broaden their knowledge and innovative thinking. Specialists sometimes maintain that you cannot be a Master/Mistress of more than one database management system. If a challenge that arises which requires your services as a DBA, it may not necessarily be your favourite flavour of RDBMS that is the best solution for your employer, or client. But MySQL is NOT free for business usage, and that doesn't seem to be widely understood.Being a database administrator means you have taken up a career as a DBA, and not necessarily a vendor-specific DBA. Many people are ideologically opposed to using Microsoft tools, or being locked into a Windows environment, and I can understand that. A relatively easy-to-use window-based management tool that lets you do most administration tasks in a "clicky" way.Interactive debugging of stored procedures and UDFs.A strong set of ancillary tools and capabilities, including a programming environment, an ETL tool (SSIS), dimensional modeling (SSAS), a reporting environment (SSRS), and a reasonably sophisticated job scheduler. ![]()
0 Comments
Read More
Leave a Reply. |