Announcing: DBA School – Learning SQL Server for the Rest of Us
A new three-day course taught by Stephen Wynkoop and Chris Shaw – centered around real-world experiences, how-to information and specific demonstrations and labs that will let you use and explore the topics covered. We’ll be covering Performance, Management, Auditing, Security, Disaster Recovery and Very Large Database considerations. Find out more at the class site here.
The catch? There are a maximum of 15 seats in this class. If you’re interested in attending, please be sure to register as soon as possible.
This will be a great way to get some hands-on training in working with SQL Server.
For more information, and to register to save your seat, please click here.
Featured Article(s)
Oracle 2-Day DBA in x Days Post 19; The purpose of UNDO Tablespaces
UNDO Tablespaces have removed many of the problems associated with prior releases of Oracle and the use of rollback segments. This article looks at how we can manage UNDO tablespaces.
New SelectViews Show Now Available
Stephen Wynkoop and Chris Shaw talk about top SQL Server Performance Tips. Part 1 of 2 – things you can try, things you should know about, tips for your SQL Server.
[Watch the Show Here]
Previously:
[Watch Here] vConference Session Sample: Thomas LaRock SQL Server 2008 Maintenance Plans. Learn about the ins and outs of maintenance plans in SQL Server 2008 – what do you really need to know?
[Watch Here] The show today features RAID and Defrag tips, backup optimization with filegroups, baseline stats and industry news. Also, find out about virtual learning opportunities, the SQL tip, the developer/AJAX thoughts and much more.
Final Thoughts on SQL Server Pricing Considerations
George: "If MySQL can do it at $599 and make money at it, then it is clear that SQL Server, Oracle and DB2 are WAY over-priced. Why not do a test where you give 2 IT managers a budget of $125K to get the best possible performance for a DB server – one using each platform. and I guarantee that the MySQL platform will smoke the MS box like a cheap cigar."
Kenneth: "I would say two things, 1st price does matter however, application will dictate what you need to run. Especially if your purchasing a software package. Now most packages come with a user or two license, so your covered out of the box. Others will charge you a seat license, either way your going to pay somehow the question becomes how much.
Now for those lucky enough to still have an internal development team, they are going to use the business standard regardless of cost. If we use SQL Server as a standard engine, theres no way or little chance Im gonna get a change to run Oracle the opposite is true, unless of course the application dictates differently. Gotta love the way that works."
George (the MySQL viewpoint): "In a word – Yes – pricing matters a great deal. Microsoft’s pricing model that simply counts physical CPUs and charges on that basis, is absurd. I have a 4 physical CPU server populated with 4 dual core Xeon 7040s. SQL Server for this box costs the same as if it had single or 6 core CPUs – they all cost the same price – about $1!)0K! Now compare that to MySQL @ $599 regardless of CPU or core count! Granted that SQL Server has a few minor advantages, but certainly not $99,401 worth. That much money sure buys alot of very fast hardware that more than makes up for any minor deficiencies MySQL may have in the performance department and on that basis blows MS away. I work on client servers with both platforms every day, as well as hosting client CRM databases on my server on which I use MySQL. I put some of the savings into SSDs for the OS and write logs, added another 24GB of RAM, a bigger faster RAID 5 array of SAS drives and still have lots of the savings left to add a cluster of identical boxes or a RAID 1+0 of SSDs for even better performance.
If MySQL can do it at $599 and make money at it, then it is clear that SQL Server, Oracle and DB2 are WAY over-priced. Why not do a test where you give 2 IT managers a budget of $125K to get the best possible performance for a DB server – one using each platform. and I guarantee that the MySQL platform will smoke the MS box like a cheap cigar."
Featured White Paper(s)
SSIS Accelerator Series: Working with SSIS Expressions
Whether you’ve been involved with SQL Server Integration Services (SSIS) for years or are just learning SSIS, you’ve probably… (read more)