tag:blogger.com,1999:blog-3226257105744032892023-11-15T23:42:23.428-08:00My SQL Stuffdiashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.comBlogger18125tag:blogger.com,1999:blog-322625710574403289.post-8034668611335381662009-09-02T13:11:00.000-07:002009-09-02T13:13:11.972-07:00Microsoft disputes password-stealing SQL Server bugFor more than a year, Microsoft has been sitting on a purported SQL Server vulnerability that could enable a malicious insider to obtain users' passwords, claims database security vendor Sentrigo. <br /><br />The software giant, however, said that the issue is not a security flaw.<br /><br />The potential bug, which Sentrigo notified Microsoft about last September, involves SQL Server keeping passwords unencrypted in its database memory, Slavik Markovich, CTO at Sentrigo, told SCMagazineUS.com on Tuesday. The issue affects SQL Server 2000, 2005 and 2008, running on Windows operating systems. <br /><br />Markovich said he believes this is a security issue because it enables any individual with administrative privileges to access SQL Server's process memory and see all the usernames and passwords that are stored for anyone who accessed either the server itself or applications that connect to the server.<br /><br />“It's something that is security 101, something you never do -- share or see other people's passwords,” he said. <br /><br />Since people often reuse the same passwords for multiple enterprise systems and for their personal lives, a malicious insider could use the stolen SQL Server credentials to access other systems or a user's personal accounts. <br /><br />“If someone can see your password, think about all the other systems they could access,” Markovich said. <br /><br />But Microsoft said that it has “thoroughly investigated” the issue and found that no vulnerability exists, a Microsoft spokesperson told SCMagazineUS.com in an email Tuesday. The software giant has no intention of offering a security update for the issue.diashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-51277068651593579242009-07-14T12:03:00.000-07:002009-07-14T12:05:43.718-07:00SQL Sentry Announces Performance Optimization Software for SQL Server Analysis Servicesthe developer of award-winning software for Microsoft SQL Server, announced today the availability of monitoring and optimization software for Microsoft SQL Server Analysis Services. SQL Sentry Performance Advisor for Analysis Services provides unparalleled insight into Analysis Services performance, including bottlenecks related to memory and storage systems, aggregation usage, unoptimized queries, and query and processing tasks competing for the same resources.<br /><br /><br />"Building on the success of Performance Advisor for SQL Server, we are proud to bring exciting new capabilities to the market for managing Analysis Services," said Greg Gonzalez, President and CEO of SQL Sentry. "And when combined with SQL Sentry Performance Advisor for SQL Server and Event Manager, we are providing the only solution in the market covering Microsoft's entire BI platform, including the relational data warehouse (SQL Server), Analysis Services (SSAS), Integration Services (SSIS), and Reporting Services (SSRS)."<br /><br /><br />"Performance Advisor for Analysis Services is truly a game changer. This is the first software that brings all of the pertinent information together in a clear and concise fashion, providing a level of insight into Analysis Services performance that before now just hasn't been possible," said John Welch, SQL Server MVP, Chief Architect, Mariner.<br /><br /><br />Performance Advisor for Analysis Services is packed with many groundbreaking features, all designed to simplify the process of optimizing Analysis Services performance. Key Features include:<br /><br /><br />Powerful SSAS Performance Dashboard <br /><br />Innovative Workload and Bottleneck Profiling <br /><br />Capture of all High Impact MDX, XMLA and DMX Commands <br /><br />Alerting and Response for SSAS Commands and Runtime Deviations <br /><br />SSAS Cache and Storage System Monitoring <br /><br />Calendar Views Combining SSAS, SQL Server, SSIS, and SSRS Events <br /><br />Monitoring and Alerting for SSIS Data Warehousing Jobs and SSRS Reports Pricing and Availabilitydiashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com1tag:blogger.com,1999:blog-322625710574403289.post-48138647090353687272009-05-23T14:00:00.000-07:002009-05-23T14:01:46.367-07:00Zoho Attempts to Bridge the Cloud and SQLEveryone knows that the most important thing is the data itself and not the storage or access of it through applications. We don't need Zoho to tell us that. We also know that more and more we are using other storage formats for our data than relational databases -- take XML repositories for instance -- and that we are using other methods to retrieve our data other than SQL.<br /><br />But what Zoho says we don't know, or don't realize, is that we can use the SQL query language to access our data even when it's not stored within a traditional relational database. At least we can now using Zoho's newest technology CloudSQL.diashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-57577739901472096802009-04-10T12:17:00.000-07:002009-04-10T12:18:53.311-07:00Server 2008 Service Pack 1 arrives<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgczidU85I3hVPT3MoPUmWrl2UVpYm6sU3zV6mEaP1nX8IE_6f-W_n3w_JD8XseMipLz9UissCDaBT1W3tyC6zR6awiwFUPZyaj0lokIsIZcayPAVgOKdloRDkjJKCU_PKWdOsyQqlnR9M/s1600-h/sql_server_2008_small.png"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 200px; height: 113px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgczidU85I3hVPT3MoPUmWrl2UVpYm6sU3zV6mEaP1nX8IE_6f-W_n3w_JD8XseMipLz9UissCDaBT1W3tyC6zR6awiwFUPZyaj0lokIsIZcayPAVgOKdloRDkjJKCU_PKWdOsyQqlnR9M/s200/sql_server_2008_small.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5323144316154424674" /></a><br />Microsoft today released Service Pack 1 for all seven editions of SQL Server 2008, its relational database management system that uses Transact-SQL as its primary query language. The update is available in 32-bit, 64-bit, and ia64 flavors from the Microsoft Download Center. SP1 is primarily a roll-up of previous cumulative updates and while there are no new features, Microsoft did highlight the following three improvements: <br /><br />Slipstream allows administrators to install SQL Server 2008 and Service Pack 1 in a single instance. This decreases the total time for an installation, including a fewer number of reboots, thereby increasing productivity and deployment availability <br />Service Pack Uninstall allows administrators to uninstall the service pack separately from the database release. This feature also improves DBA productivity, reduces the cost of deployment and improves overall supportability <br />Report Builder 2.0 Click Once improves the existing SQL Server end-user report authoring application by easing deployment to business users <br />Microsoft also took the opportunity to note that there have been "over three million downloads" of SQL Server 2008 to date. SQL Server 2008 hit the RTM milestone in August 2008. The CTP of SP1 was released in February.diashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-40431180166388913152009-03-15T13:44:00.000-07:002009-03-15T13:45:37.141-07:00DiscountASP.NET Adds SQL 2008 Backup APIASP.NET hosting and SQL hosting provider DiscountASP.NET (www.discountasp.net) has expanded its Open Control Panel API with the addition of APIs for SQL 2008 Database backup as part of DiscountASP.NET's Open Control Panel Initiative, designed to offer an open hosting system framework that provides maximum control.<br /><br />According to DiscountASP.NET's Wednesday announcement, customers can access the API library through their control panel and are assigned a unique Authentication Key. Also, a Sandbox Key is provided so that customers can test their applications without the risk of making changes to their hosting account. <br /><br />In 2006, DiscountASP.NET unveiled the first phase of its Open Control Panel Initiative by introducing an ASP.NET web service API library that customers can use to develop their own web, desktop or mobile applications that interface directly with their web hosting account. This exposed a number of methods to retrieve resource usage information, and manage some IIS functions, such as recycling their application pool. Today, DiscountASP.NET has found more methods for customers to backup their SQL 2008 databases. <br /><br />"Our control panel API is a move to provide our customers with a next-generation hosting experience." marketing vice president Takeshi Eto said in a statement. "Our vision for the Open Control Panel Initiative is to offer our customers the flexibility and freedom of choice. They can manage their hosting presence using our hosted control panel application or through web services and customized user-driven solutions." <br /><br />DiscountASP.NET has undergone many improvements in the past few months, increasing options for customers looking for advanced ASP.NET and SQL functionality.<br /><br />At Microsoft's (www.microsoft.com) Professional Developers Conference in October 2008, DiscountASP.NET announced it had teamed with the software heavy weight to offer a free beta sandbox hosting environment for the Web Deployment Tool, Microsoft's deployment, management and migration tool for web apps, sites and servers.<br /><br />http://www.thewhir.com/web-hosting-news/103108_DiscountASP.NET_Offers_IIS_Tool_Beta<br /><br />More recently, in January, DiscountASP.NET partnered with web-based applications provider myLittleTools (www.mylittletools.com) to add myLittleAdmin to DiscountASP.NET's feature set, giving customers free access to the web-based SQL management tool.diashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-29972586187066195382009-01-19T11:52:00.000-08:002009-01-19T11:54:25.404-08:00SQL DeCryptor 2.2 (Windows)SQL Decryptor is developed by Imperia Software, to decrypt views, user defined functions and stored procedures in an easy-to-use graphical interface. It works quickly to decrypt items in Microsoft SQL Server 6.5, 7.0, 2000, 2005, 2008 and MSDE. SQL Decryptor allows for easy viewing of encrypted code, of any size.Version 2.2 with best search performance.diashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-55542723995681114332008-12-28T01:39:00.000-08:002008-12-28T01:40:20.489-08:00Microsoft confirms it's been working on SQL Server bug since AprilMicrosoft Corp. today confirmed that it has been working on a critical vulnerability in SQL Server for more than eight months, but declined to say whether it has had a patch ready since September, as an Austrian security researcher has alleged. <br /><br />On Monday, the company warned customers of a bug that could be used to compromise servers running older versions of the database software, which is widely used to power Web sites and applications. <br /><br />"Microsoft opened an investigation for this vulnerability in April upon the initial report by the security researcher," said a company spokesman in an e-mail today. "We immediately started an investigation and have been working on this issue since that time," he added. <br /><br />The researcher, Bernhard Mueller of SEC Consult Security, a Vienna-based security consulting company, went public with details of the vulnerability as well as an exploit code on Dec. 9, apparently after tiring of Microsoft's lack of communication. <br /><br />According to Mueller, who posted findings in an advisory on the SEC Consult site, as well as to prominent security mailing lists, the bug was reported to Microsoft on April 17, 2008, and Microsoft's last message to him was on Sept. 29. After four requests for an update on a patch's status during October and November, Mueller disclosed the vulnerability. <br /><br />Mueller also said that Microsoft had informed him in September that it had completed a fix. <br /><br />The Microsoft spokesman didn't directly respond to a question about whether the company had a patch in hand, as Mueller claimed, but instead said, "At this time, security updates are not available for the affected versions listed in Microsoft Security Advisory 961040." <br /><br />Although it is true that Microsoft has not yet issued an update to the affected software -- which includes SQL Server 2000, SQL Server 2005, SQL Server 2005 Express Edition, SQL Server 2000 Desktop Engine, Microsoft SQL Server 2000 Desktop Engine and Windows Internal Database -- one security expert said he's betting that the company will release one soon.diashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-58600726580536065992008-11-11T11:46:00.000-08:002008-11-11T11:49:50.249-08:00Internals of SQL Cluster Setup and Troubleshooting TipsUnlike Exchange Cluster Setup process, SQL Cluster Setup process is not tricky. You just click on next and finish the setup. The purpose of this article series is to explain the internals of the SQL Cluster Setup. The Setup process executes couple of functions from its Setup DLL. These functions are internal to SQL Setup and are never exposed to the user running the setup. The functions it executes are used to decide whether SQL Setup should install the SQL Database Instance in a stand-alone environment or in a cluster environment. <br /><br />SQL Server Setup Functions <br />How does SQL Server cluster setup configure a second node to be cluster-aware? <br />What all-registry entries are created during the setup and their importance in a SQL Cluster environment?<br />I will start with the first topic mentioned in the above list. <br /><br />SQL Server Setup Functions<br />SQL Setup mainly uses the SQLCluster.DLL from its BINN Directory to execute the following functions in it: DoSQLClusterSetUpWork <br />DoUnClusterSetup <br />CheckDatabasesForInstancediashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com1tag:blogger.com,1999:blog-322625710574403289.post-11633372393653851842008-10-15T12:48:00.000-07:002008-10-15T12:51:45.711-07:00Introduction to Policy-Based Management in SQL Server 2008New to SQL Server 2008 is Policy-Based Management. This new technology allows for defining polices to ensure your database guidelines are met. In this article, SQL Server consultant Tim Chapman gives an overview of this new technology.<br /><br />————————————————————————————–<br /><br /> <br /><br /><br /><br /><br />Policy-Based Management in SQL Server 2008 allows the database administrator to define policies that tie to database instances and objects. These policies allow the Database Administrator (DBA) to specify rules for which objects and their properties are created, or modified. An example of this would be to create a database-level policy that disallows the AutoShrink property to be enabled for a database. Another example would be a policy that ensures the name of all table triggers created on a database table begins with tr_. <br /><br /> <br /><br />As with any new SQL Server technology (or Microsoft technology in general), there is a new object naming nomenclature associated with Policy-Based Management. Below is a listing of some of the new base objects. <br /><br />PolicyA Policy is a set of conditions specified on the facets of a target. In other words, a Policy is basically a set of rules specified for properties of database or server objects. <br /><br />TargetA Target is an object that is managed by Policy-Based Management. Includes objects such as the database instance, a database, table, stored procedure, trigger, or index. <br /><br />FacetA Facet is a property of an object (target) that can be involved in Policy Based Management. An example of a Facet is the name of a Trigger or the AutoShrink property of a database.diashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-18600110308685725632008-08-25T12:02:00.000-07:002008-08-25T12:03:35.543-07:00Microsoft's SQL Injection ProtectionHomer Simpson may have enjoyed his hot beef injections (for Homer these were hot dogs), but he would be far less fond of SQL injections, attacks upon SQL Server that can cripple Web sites.<br /><br />Many with SQL Server also have IIS, which is why Microsoft is beefing up IIS with SQL Injection protections. The new filter against these attacks is free and available now.<br /><br />From all indications Small Business Server 2003 was a fine product -- easy to set up, easy to use and boasting many essential business features. As I recall, the only drawback was if your company outgrew the SBS product, it was hard to move up gracefully.<br /><br />The new version of the server, SBS 2008, is now in the hands of hardware makers who expect to have it bundled up by November. I guess they want to take their time and get it perfect.<br /><br />Do you use SBS? What do you like and what don’t you? Answers welcome at dbarney@redmondmag.com.diashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-1470071475993838982008-07-12T10:49:00.000-07:002008-07-12T10:50:10.879-07:00Slam these SQL Injection Attacks!In January 2003, the Microsoft SQL Server community got a massive wake-up call. The SQL Slammer hit the internet. This denial-of-service virus brought down many database servers including those at Bank of America and Microsoft itself. The solution was to apply SQL Server 2000 SP3 which by pure coincidence had been released 10 days earlier. The actual hotfix had been available for 6 months or more but in those days many DBAs just waited for the next Service Pack. Big mistake! Attacks like this prompted Bill Gates to launch the Trustworthy Computing initiative and current project plans were elongated by 3 months to allow product teams to focus on security. Products under development included Windows Server 2003, Exchange 2003 and SQL Server 2005 - they all benefited from this "strategy". <br /><br />But what about SQL Injection attacks? <br /><br />SQL Injection attacks take advantage of poorly coded applications by submitting hidden code "injected" into a seemingly harmless piece of code. The solution is to make sure input fields from an application are fully validated including checking for special characters before they are used in SQL commands. Recently, this vulnerability has emerged in many ASP applications so Microsoft have produced a utility that will check ASP code for potential vulnerabilities.<br /><br />Microsoft Source Code Analyzer for SQL Injection: <br /><br />http://www.microsoft.com/downloads/details.aspx?FamilyID=58a7c46e-a599-4fcb-9ab4-a4334146b6ba&DisplayLang=en%20 <br /><br />Check it out!diashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-2593239370327848622008-07-12T10:47:00.000-07:002008-07-12T10:48:44.259-07:00SQL Server 2008 may not come in August after all<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkzIMAfd_h8oFdAFvnky4RtiDOYWa302WKgZRm8DSnTJ9vDsOYW0UvtmQYEXoJX9iOAPBr6oMQZT48MBLwjcmQXV0_sP4TPpZnk4r4rMVTuSXwWrU_ZdDOLWAWrclobqvo-xqnjqbrxmM/s1600-h/microsoft_sql_server.gif"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkzIMAfd_h8oFdAFvnky4RtiDOYWa302WKgZRm8DSnTJ9vDsOYW0UvtmQYEXoJX9iOAPBr6oMQZT48MBLwjcmQXV0_sP4TPpZnk4r4rMVTuSXwWrU_ZdDOLWAWrclobqvo-xqnjqbrxmM/s200/microsoft_sql_server.gif" border="0" alt=""id="BLOGGER_PHOTO_ID_5222185905954133474" /></a><br />Microsoft SQL Server is a relational database management system whose primary query language is Transact-SQL. The latest version of the Microsoft database platform is Microsoft SQL Server 2005 SP2, but Microsoft has for a while now been working on what was previously codenamed Katmai. Microsoft is planning to release the long-awaited Microsoft SQL Server 2008 (overview) sometime during the third quarter of this year. <br /><br />At the Microsoft Worldwide Partner Conference, the company announced to partners that the new version is now listed on the August price list. Pricing is to remain the same as it is with SQL Server 2005. Various news sites took this information and ran with it: many began to report that SQL Server 2008 was becoming available in August, but this is not necessarily true. <br /><br />Microsoft is still expecting the new version to arrive sometime in Q3. As Andrew Fryer put it on his blog: "Bottom line—It will be out sometime in Q3 when it’s ready," the fact that it is available on August's price list does not guarantee that it will become available then. It is entirely possible that the new version will launch just at the end of Q3 (late September), and even then, you can never rule out delays with Microsoft. Currently, the latest build is RC0 (released in early June). Once it is finally released, Microsoft has previously said that SP3 for SQL Server 2005 will arrive, hopefully in Q4.diashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-8462022219116260212008-06-16T08:23:00.000-07:002008-06-16T08:25:19.178-07:00Windows IT Pro and SQL Server Magazines Announce Their Best of Tech Ed IT Pro AwardsWindows IT Pro magazine and SQL Server Magazine announced the winners of their Best of Tech Ed 2008 IT Professional Awards yesterday evening. Jeff Lewis, the Group Publisher of the Windows IT Group, presented the awards at a ceremony at Universal Studios in Orlando. Out of over 223 product nominations that were received for the Best of Tech Ed Awards, editors chose 29 finalists in nine categories.<br /><br />Winners were chosen based on innovation, competitive advantage, and value to customers.<br /><br />In the Messaging category, the winner is Azaleos OneServer Virtual Edition. Our judges liked the features of this innovative virtual appliance, ranging from its polished interface to its wealth of management and analysis options.<br /><br />The winner in the Business Intelligence category is SoftArtisans OfficeWriter. OfficeWriter can connect to SQL Server, Analysis Services, and other databases and deliver fully functional Microsoft Excel and Word documents over the Web.<br /><br />In the SharePoint category, the winner is the AvePoint DocAve Software Platform. SharePoint use is exploding, and the DocAve Software Platform provides an integrated environment for SharePoint management, disaster recovery, and real-time backup.<br /><br />In the Hardware, Networking, and Storage category, the winner is Strangeloop WS1000. The WS 1000 can increase the performance of Web services by an order of magnitude. Its advanced caching technologies enable plug-and-play performance optimization without requiring any changes to the Web services application code.<br /><br />In the Database Administration category, the winner is SQL diagnostic manager. SQL diagnostic manager provides the ability to monitor SQL Server performance as well as diagnose and analyze performance problems.<br /><br />In the Productivity and Collaboration category, the winner is Colligo Contributor Pro. Giving users access to company information on the road is essential, and Colligo Contributor Pro allows users to access and edit Microsoft SharePoint content both online and offline.<br /><br />In the Security category, the winner is Trend Micro ScanMail for Microsoft Exchange. ScanMail for Microsoft Exchange provides comprehensive e-mail security including anti-virus, anti-spyware and zero-day virus protection.<br /><br />In the Virtualization category, the winner is VMware Virtual Infrastructure 3. Virtualization is taking the IT world by storm, and VMware has been driving that change more than anyone.<br /><br />In the Systems Management and Operations category, the winner is Athena by Odyssey Software. Athena is a management solution for Windows-based mobile devices. The product seamlessly integrates into the Microsoft System Center management interface to provide remote tools, extended asset reporting, and provisioning for mobile devices in the enterprise.<br /><br />The Breakthrough Product award winner is Quest Software’s PowerGUI, a scripting and command shell platform that enhances ease of use of Windows PowerShell.<br /><br />This year's Attendees' Pick award winner is Syntergy Replicator for SharePoint.diashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-56974603398131054142008-06-16T08:22:00.000-07:002008-06-16T08:23:06.311-07:00Delayed SQL Server 2008 hits release phaseMicrosoft's delayed SQL Server 2008 has inched closer to daylight, with the company's first release candidate (RC) code.<br />SQL Server 2008 RC 0 has been made available in three editions - the full database, Express and Express Advanced. Also released for testing is the SQL Server 2008 Feature Pack, consisting of installation packages, with 15 new components.<br />tile++;<br />document.write('\x3Cscript src="http://ad.uk.doubleclick.net/adj/reg.channel.4159/software;cta='+cta+';ctb='+ctb+';ctc='+ctc+';sc='+sc+';cid='+cid+';'+RegExCats+GetVCs()+'pid='+RegId+RegDT+';'+RegKW+';test='+test+';pf='+RegPF+';dcove=d;tile='+tile+';sz=336x280;ord=' + rand + '?" type="text/javascript">\x3C\/script>');<br /><br />Calling RC 0 a "milestone", server and tools chief Bob Muglia told Microsoft's TechEd in Orlando, Florida, that the company is "very close" to shipping its delayed database. "It's in great shape," he said.<br />Microsoft was originally due to launch SQL Server 2008 at the end of last year. That was pushed back to February 27, with launch timed to coincide with Windows Server 2008 and Visual Studio 2008. In January, the release was again pushed back to the third quarterdiashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-22903045915418566222008-05-16T12:39:00.000-07:002008-05-16T12:42:34.538-07:00Not Going Closed Source?MySQL is one of the most popular databases in use today, a popularity that has been driven by the open source community. Some in the community, however, are taking issue with exactly how open MySQL actually is as fears about the future of the open source database grow.<br />At stake and at issue are the $1 billion dollars Sun has invested in MySQL. As community members question Sun's intentions, MySQL defends its turf.<br /><br />This week Sun's MySQL division preannounced the release of MySQL 5.1, which is expected to be available in June. The actual release is months behind schedule and follows the last major MySQL release, MySQL 5.0, by two and half years.<br />MySQL also announced some new features for MySQL 6, currently in Alpha development.diashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-35283197191208103042008-05-16T12:36:00.001-07:002008-05-16T12:36:50.448-07:00MySQL Backs Off Closed Source PlanMySQL has backed off a plan to charge for some encryption and compression backup widgetry in the next version of the database – and, heavens, NOT OPEN SOURCE THE STUFF, an idea it trotted a few weeks ago and predictably caught hell for.<br />Sun, which bought MySQL for a billion dollars, a good reason to try to make some of the money back, took the rap.<br />MySQL’s community relations VP Kaj Arno says on a blog that the features will be open sourced after all, admitting “a change in direction” and absolving Sun of complicity in the, um, miscalculation. Sun gets enough bad press.<br /><br />“The change,” he writes, “comes from MySQL now being part of Sun Microsoft. Our initial plans were made for a company considering an IPO, but made less sense in the context of Sun, a large company with a whole family of complementary open source software and hardware.”<br />That is not to say, MySQL won’t try again. Arno says “To financially support MySQL’s free and open source platform, we have a business model which allows both community and commercial add-ons, and we remain committed to it….expect Sun/MySQL to continue experimenting with the business model, and with what’s offered for the community and what’s offered commercial-only.”diashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-24301782769482065592008-05-16T12:31:00.000-07:002008-05-16T12:34:25.297-07:00MySQL backtracks on closed-source plan"MySQL Server is and will always remain fully functional and open source," said Kaj Arno, MySQL's vice president of community relations, in a statement released on his website on Tuesday. "So will the MySQL Connectors, and so will the main storage engines we ship."<br />In effect, MySQL has changed its plans for forthcoming encryption and compression backup features that it had planned to ship under a proprietary licence, and will now release the features with open-source licences, Arno said. He also confirmed that pending backup functionality in MySQL 6.0 and the MyISAM driver for MySQL Backup will be open source.<br />The announcement is a step back from plans announced last month by Marten Mickos, former chief executive of MySQL and now a Sun vice president.diashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0tag:blogger.com,1999:blog-322625710574403289.post-31644895359826779982008-05-16T12:24:00.001-07:002008-05-16T12:24:34.846-07:00MySQL in a Nutshell, Second Edition--New from O’Reilly: Updated Reference Keeps Pace with MySQL’s Growth and ChangesSebastopol, CA�MySQL has held steady as one of the great open source success stories, and there is no indication that this will change in the foreseeable future, in spite of its recent acquisition. "Although MySQL AB has recently been purchased by Sun Microsystems, the software and the organization has remained intact" reports author Russell J. T. Dyer. "The software will only get better now that the company has the money to expand its software engineering department. More importantly, the software will be broadly adopted by larger companies now that it has the backing of a multi-billion dollar company like Sun. Sun can assure large companies, institutions, and governments that MySQL is here to stay and that it’s fully supported"<br /><br />MySQL aficionados confirm that this is indeed the case, making the new second edition of Dyer’s book, MySQL in a Nutshell (O’Reilly, US $34.99) even more timely. "There have been several changes to MySQL since the first edition: in particular the stabilization of version 5.1 of MySQL" says Dyer. "I wanted to expand the book to include the changes and improvements to MySQL. This new edition includes the many new features such as stored procedures, stored functions, triggers, and viewsdiashttp://www.blogger.com/profile/17598339351743294731noreply@blogger.com0