MySQL Forums :: Newbie :: Any tips for an MS SQL DBA trying to break into MySQL?


Advanced Search

Any tips for an MS SQL DBA trying to break into MySQL?
Posted by: Sam Alexander ()
Date: January 25, 2012 08:16AM

Hi everyone,

I've been an MS SQL developer for over a decade now, but other than using MySQL on a few sites I maintain I've never really learned the nuts and bolts of MySQL. Some questions for anyone who's gone down this same path or who works in both worlds:

- Is there an SSMS type tool for MySQL? I've tried MySQL Workbench but it just seems clunky. Also if possible i"d love to find something that works in Windows, Linux, and OSX since I live in all three worlds.
- Can someone recommend books or online resources about indexing and performance tuning?
- I use Microsoft SQL Server Reporting Services and love it, is there any equivalent tool for MySQL whether by Oracle or someone else?
- What about equivalent troubleshooting tools in MySQL like these in MS SQL: information_schema, SQL Profiler, DBCC SHOWCONTIG, etc.
- Also any good books or resources showing how MySQL works under the hood? I'm familiar with the tree/leaf method of how MS SQL works with indexes but what about MySQL?
- What about data warehousing? MS SQL has Analysis Services, but are there any tools either built into MySQL or maybe industry standard tools for business intelligence?

Thanks in advance for any pointers or tips. Take care,

Sam

Options: ReplyQuote


Subject Written By Posted
Any tips for an MS SQL DBA trying to break into MySQL? Sam Alexander 01/25/2012 08:16AM
Re: Any tips for an MS SQL DBA trying to break into MySQL? laptop alias 01/25/2012 08:24AM
Re: Any tips for an MS SQL DBA trying to break into MySQL? Sam Alexander 01/25/2012 08:43AM
Re: Any tips for an MS SQL DBA trying to break into MySQL? Erik Haselhofer 01/25/2012 06:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.