Microsoft this week released the last cumulative updates for SQL Server 2005 and will end mainstream support for the product in a few weeks.
The Cumulative Update #15 for SQL Server 2005 Service Pack 3 contains six fixes, while the Cumulative Update #3 for SQL Server 2005 Service Pack 4 contains five fixes.
Although mainstream support ends April 12, technical support will continue for another five years for the latter service pack.
And plan ahead: technical support of SQL Server 2008 Service Pack 1 ends Oct. 11.
What version do you run? Do you feel pressured to upgrade? Comment here or send me an e-mail.
Posted by David Ramel on 03/23/2011 at 1:15 PM1 comments
Microsoft announced that developers can get help with building early, real-world projects with the next version of SQL Server, code named "Denali," through the Metro Early Adoption Program.
Denali, expected by many to be released later this year and sometimes unofficially known as SQL Server 2011, was issued last fall as a Community Technology Preview. It features enhancements such as a high-availability component called Always On, a "column-based query accelerator" and the capability to "allow for the creation of so-called columnar indexes over relational databases," as explained by Andrew J. Brust on Redmond Developer News.
And, of special interest to developers: it will provide a new unified Visual Studio IDE that's being called "Juneau."
Microsoft is seeking to get more developers onboard with Denali and started on real projects that will help them put some positive spin on the new version come release time. All you need to apply to the Metro Early Adoption program is a Windows Live ID and willingness to sign a non-disclosure agreement, Microsoft senior technical evangelist Roger Doherty announced in his blog Monday.
"You will be asked to provide some details about your company and your early adoption project," Doherty said. "We review each nomination that comes in and approve the solutions we think will have the best chance of showcasing SQL Server Denali improvements during the launch wave."
He said early adopters would get access to:
- Confidential online meetings with SQL Server teams.
- DeepDive developer labs, with assistance from the SQL Server engineering team.
- Beta support.
- Training events.
- A ready-to-go, dedicated virtual Sandbox learning and testing environment.
You can get more information in a Channel 9 video featuring Doherty and colleague Steve DiMarco or the Microsoft Denali page.
Will you be applying? Are you looking forward to the new SQL Server or are you overwhelmed by a new version too soon after 2008 R2? Comment here or drop me a line.
Posted by David Ramel on 03/23/2011 at 1:15 PM0 comments
Forget all this touchy-feely open-source LAMP stack stuff--throw away your SQL Server and run our MySQL database on Windows.
Okay, maybe the message wasn't quite that stark, but there's no doubt Oracle upped the ante in the database wars today when it launched a comprehensive program to entice SQL Server developers, DBAs and such to run its Linux-borne MySQL database on Windows.
"It's a really nice implementation. I think it exceeds what Microsoft provides in their SQL Server implementation," quipped Rob Young, an Oracle senior product manager, during a three-hour Webcast. Talk about a direct attack on Microsoft's home turf: He was referring to Connector/NET, a tool that helps developers build .NET apps with MySQL. It was even noted that Connector/NET was written entirely in C#!
Oracle devoted an entire presentation to .NET development during its Webcast (but the audio was bad, so I have no idea what they said; the audio was fine before and after that presentation). And in the opening segment it trumpeted MySQL's improved "Windows eco-system support" for Visual Studio, Entity Framework, Windows administration tooling and connector enhancements--all deemed priorities for fiscal year 2011-12.
Connector/NET lets developers create C#, ASP.NET and VB.net apps, Oracle said, while implementing the ADO.NET interfaces, integrating into ADO.NET-aware tools and sporting a fully managed ADO.NET driver.
It almost seemed as if Oracle was adopting a "if you can't beat 'em, join 'em" mentality with MySQL. "Windows is, and will continue to be, No. 1 for development and deployment and we really want to stay focused and make sure that the performance capability [of MySQL development on Windows] is top-notch," said Tomas Ulin, vice president of MySQL Engineering when discussing upcoming enhancements to Oracle's Windows development tools.
Young summarized the state of the latest version of Connector/NET (6.3) and where it's going: "We have Visual Studio 2010 compatibility. We have support for .NET 4.x and we go back to 2.x as well, so if you're using an older version and haven't upgraded yet, our Connector will work back a couple of versions. We've also got this Model First development using the Entity Framework, so Connector 6.x will support that, so you can actually develop objects, tables, that type of thing, within the Entity Framework environment and then forward-engineer those into actual DBL and ultimately into database objects. If you're familiar with the SQL Server editor within Visual Studio, the MySQL editor looks, basically, exactly the same."
He also discussed MySQL compatibility with Visual Studio wizards and Web site wizard integration. "They look and feel and function exactly like they do for SQL Server. So you can use our Connector along with MySQL along with Visual Studio and feel very comfortable if you're already using those things for SQL Server as well. So no surprises here, just complete, simple integration with the Visual Studio environment."
Young also discussed the MySQL Workbench, which he noted was the No. 2 download from the MySQL family and, according to a slide, has a "growing, enthusiastic developer community." He said "it puts a face--a visual, point-and-click face--on the front of MySQL."
He said Workbench has a graphical design aspect that lets users reverse engineer a database, for example, and see it graphically, change things around and roll those changes into a new, physical database.
"It's got the ER design, development aspect to it as well," Young said. "You can work with code, and it's just a very nice, slick implementation. And what we've done is we've gone to great lengths to make sure the features and functionality within Workbench match very closely that of Visual Studio 2010. It very much feels like a Windows product because it is a Windows product. And just know that this is here, specifically, to extend what Visual Studio does for MySQL and provide a lower-level development tool for those that would like to use MySQL in a big way."
So there you have it. MySQL goes Windows. While Microsoft woos the open-source community to embrace SQL Server, Oracle is enticing Windows developers to move from SQL Server to open-source MySQL.
And with that, I pose a few questions: What will developers say about this? What will the Linux fanbois say about this? And why do they pronounce SQL Server as "sequel server" while pronouncing MySQL as "my s-q-l"?
I need answers to these burning questions. Comment here or send me an e-mail.
Posted by David Ramel on 03/16/2011 at 1:15 PM4 comments
No need to wait for that next major .NET Framework upgrade to get Entity Framework improvements, as a stand-alone EF installer is about to be released for the first time.
Entity Framework CTPs have been out for months and have alleviated many user concerns, and Entity Framework 4.1 is due to arrive any week now to address more.
It includes two major components: a DbContext API and Code First capability. The former is basically a simplified and enhanced ObjectContext. Most of the buzz among developers is around the new Code First component.
"Code First alleviates any need for a visual model, you can just create your classes, add any needed configurations to make sure they align with EF rules and go," said EF expert and author Julie Lerman in an interview. "You get the benefits of the ORM [object relational mapping] features offered by EF without the extra layer of having to create your model in a designer and then futz with a code generator to get your classes the way you want them."
Alleviation of the futz factor is a definite plus, indicated Tim Laverty, who as the lead program manager on the Microsoft EF team probably knows as much about Entity Framework as anyone in the world. In an interview, Laverty said Code First "offers a way for 'code-oriented' customers to build EDM [Entity Data Models] models and use EF. Previously, tooling or a command-line interface was required to create your model unless you were willing to create and edit complex XML files."
Laverty also mentioned that EF 4.1 supplies several conventions, such as database creation, to help developers build apps easier, and also has rich ASP.NET MVC integration.
And developers are likely to be excited about the new DbContext API, too, said Lerman, who wrote a preview of EF 4.1 in MSDN Magazine [full disclosure: my day job is features editor for the mag]. "It's not just that the amount of exposed properties and methods has been reduced," she told this site, "but there are a lot of coding tasks that have been simplified … whereas you have to do a little more juggling with ObjectContext to achieve the same ends."
While many developers lauded the new release when it was announced last week, there's still a big list of improvements they want, such as support for stored procedures, type conversions, enums, bulk updates and more.
"Darn it! No SP support? Cached queries? Very disappointing," said a user named Darius in the comment section of the ADO.NET team blog announcing the "Go-Live Release Candidate." "Guess we'll have to wait a bit longer to use this. Please just make sure that when you do implement, you do it right. Needs SPs to map to POCO objects or maybe even dynamic objects. Same goes for an ad-hoc SQL query."
Laverty sounded like he's heard about the enum clamor before. "Enum support!" he exclaimed when asked about future improvements (it's actually No. 1 on the uservoice site list, with more than 1,200 requests). "This is our top ask and is in our product plan for vNext," Laverty said. "After that, there's a large backlog: TVF [Table-Valued Function] support, Spatial support, better integration with database projects … better SQL gen, batch CUD [create, update or delete], second-level cache support, sharding support, migrations/database evolution, better [stored procedures] support" and more.
Laverty noted that disassociating EF from the evolution of Visual Studio and .NET Framework releases will help the EF team get improvements out faster--hopefully once per year. "We don't have a locked date for the release after 4.1 but are working on it now," he said.
He said you can let Microsoft know what features you'd like to see in EF in three main ways. "Give us feedback on our uservoice site, our forums, and our blog, please. We actively use each to build and prioritize our product backlog."
What would you like to see done to Entity Framework? Comment here or drop me a note.
Posted by David Ramel on 03/09/2011 at 1:15 PM11 comments
Here's a roundup of recent product announcements in the database development world.
Devart announced the new version of dbForge SQL Complete, an add-in to enhance code completion for users of Microsoft SQL Server Management Studio.
The company said SQL Complete Version 2.5 comes only a month after version 2.0, incorporating new features requested by users. Some of the main enhancements include:
- Quick object info: Moving the mouse cursor over a database object identifier produces a popup window to quickly show information such as column names and data types, more column properties, different kinds of keys, object types and user descriptions.
- Expanded INSERT statement feature: Users can type a table name in an INSERT statement and then just press the Tab key to expand the statement to the entire template.
- Export/Import setting wizard: Users can export the tool's settings to a file and use it later to import these settings.
The company also listed an improved SQL formatter, a button to reset page defaults and improved logic for JOIN clause suggestions.
Norway-based Norsync announced its U.S. launch with a free trial of its suite of tools for mobile application developers "who want to build, operate and synchronize data-driven mobile applications in a fraction of the time and cost."
The company said programmers often find it too complex to synchronize data between mobile clients and servers or configure a database management system to filter appropriate data to mobile databases.
Norsync Suite lets developers input a SQL-based database schema to generate an entire Visual Studio project with deployable C# applications for Windows and Windows Mobile devices, with support for iPhone and Android devices expected next quarter.
Red Gate released SQL Source Control 2.0, which lets users connect existing source control systems--such as Team Foundation Server or Subversion--to SQL Server. The company said the tool also offers a shared model to let developers on a team see other members' database changes in real time.
The company offers a 28-day free trial of the software that it says can be installed in less than five minutes.
Revelation Software announced a new version of its OpenInsight Development Suite, which provides developers with Windows and Java-based GUI tools for Web and client/server apps that support native and relational technologies such as XML, SQL and Lotus Notes, among others.
Version 9.2.1 provides new components such as:
- OpenInsight for Web: A toolkit that helps OpenInsight and MultiValue developers build Web 2.0 browser-based programs as well as forms, reports, dashboards and menus.
- Source code management: A new feature that lets users group source code into modules and kept as unique versions as it's compiled.
- U2 DotNet Connecter: This has been redesigned in order to use the Uniobjects .NET library in lieu of Intercall libraries; this allows connection pooling.
The company also announced new versions of its Universal Driver.
Posted by David Ramel on 03/08/2011 at 1:15 PM0 comments
Netflix is hiring, but SQL Server gurus need not apply.
The company that transformed from a clunky DVD-by-mail delivery system to cutting-edge video streaming from the cloud has some SQL Server developers worried about their future job prospects as Netflix embraces the NoSQL movement. Few things are scarier than wondering if you backed the wrong horse in your career choice.
"This sort of questions are freaking me out," wrote one blogger about a forum post that expressed concern about the Netflix decision. "Can you imagine how panicked programmers are, knowing that not only tens of programming languages are out there (plus C/C++ is dead, Java is dead, etc.), but also a couple of different programming paradigms?"
The post he was referring to appeared on a SQLServerCentral forum and referenced a Netflix blog discussing the move to the NoSQL camp. "Is this something relational database guys has to be concerned about? I am concerned on what future holds for SQL-Developers and SQL-server DBAs," said forum member sqlcool.
The blog posting that stirred all this up was titled "NoSQL at Netflix" and was written a couple weeks ago by Yury Izrailevsky, director of Cloud and Systems Infrastructure at Netflix.
"While it is not easy to re-architect your systems to not run join queries, or not rely on read-after-write consistency (hey, just cache the value in your app!), we have found ourselves braving the new frontier of NoSQL distributed databases," Izrailevsky said.
The Neflix exec explained: "the reasons behind our choice of three ... NoSQL tools: SimpleDB, Hadoop/HBase and Cassandra."
After discussing each one, he admitted:
Adopting the non-relational model in general is not easy, and Netflix has been paying a steep pioneer tax while integrating these rapidly evolving and still maturing NoSQL products. There is a learning curve and an operational overhead. Still, the scalability, availability and performance advantages of the NoSQL persistence model are evident and are paying for themselves already, and will be central to our long-term cloud strategy.
There has been plenty of other discussion about Netflix and its embrace of NoSQL, including a technical white paper by Netflix software architect "Sid" Anand. He’s going to talk more about it in a meeting next week titled "NoSQL @ Netflix."
Meanwhile, as Izrailevsky concluded: "For those technology superstars out there: Netflix is hiring."
Are you a SQL Server guy worried about this kind of stuff? Please share your thoughts by commenting here or drop me a line.
[Editor's note: This article was updated from its original posting, with corrected information pointed out by the commenter referenced in paragraph 3 and 4.]
Posted by David Ramel on 02/10/2011 at 1:15 PM4 comments
SQL Azure developers are at a disadvantage compared to Windows Azure coders because of a lack of desktop emulators, a Microsoft blog indicated.
The Windows Azure SDK includes emulators that run on your PC so you don't have to subscribe to the online service to code against it, noted Buck Woody in an earlier posting. Yesterday he said that posting brought up the question of whether there was such a thing for SQL Azure.
"The short answer is that there isn't one," Woody said in a Carpe Datum blog posting titled "Where is the SQL Azure Development Environment." (I realize that, being an editor, I'm overly picky about such things, but isn't that headline screaming for a closing question mark?)
He explains how to develop with SQL Azure without emulators ("you can simply treat it as another edition of SQL Server") and it doesn't sound that onerous, but I wonder about the scripting part: "you can script out the database when you're done as a SQL Azure script." Things may well have improved since I tried a SQL Server-to-SQL Azure database conversion script in the early days of the cloud-based offering, but I was pulling my hair out having to make all kinds of manual changes.
Anyway, Woody concluded:
"Will all this change? Will SSMS, 'Data Dude' and other tools change to include SQL Azure? Well, I don't have a specific roadmap for those tools, but we're making big investments on Windows Azure and SQL Azure, so I can say that as time goes on, it will get easier."
What do you think? Are you database guys getting the short shrift, or is it no big deal? Please comment here or drop me a line.
Posted by David Ramel on 02/04/2011 at 1:15 PM0 comments
It's no coincidence that business intelligence is the focus of Microsoft's brand-new update to the SQL Server 2008 R2 training kit.
The very first item listed in the announcement for the SQL Server 2008 R2 Update For Developers January 2011 Update (seriously, guys: get some professional help for naming your products!) is "Build Your First Microsoft BI Solution with SQL Server 2008 R2."
The Redmond software giant has championed "self-service BI" in everything from the Business Decision Appliance to the project "Crescent" data visualization tool to the PowerPivot plug-ins for Excel and SharePoint.
Microsoft data and storage VP Ted Kummert seems to have made it his personal crusade. In case there's any doubt about that, a search for "Ted Kummert" and "self service BI" garners 3,380 hits in Google and and 1,190 in Bing.
That full-court press just continues with the new training kit update. It includes an extremely comprehensive set of offerings with 11 units that feature (as listed in the announcement):
- 31 presentations (PowerPoint slides, videos and transcripts included)
- 27 demos (installer scripts, videos and transcripts included)
- 12 hands on labs (installer scripts included)
Let's hear it from you professional BI gurus and vendors out there: is Microsoft trying to put you out of business, like some are hinting? Comment here or drop me a line.
Posted by David Ramel on 01/26/2011 at 1:15 PM1 comments
Last week the Data Driver wondered if SQL Server was behind the recent Hotmail outage.
The answer is: No.
It was a script error, according to a Windows Blog post by Mike Schackwitz, pointed out to me by a helpful member of Microsoft's PR firm.
To sum up, a script meant to delete temporary accounts used for automated testing accidentally deleted some real users' directory records. This supposedly didn't delete any actual data, but a lot of users responded to the post and disputed that, with many saying they lost years' worth of messages and that some accounts were still unavailable. The complaints were still rolling in as of today.
Microsoft representatives were helping some of those users, but there were many comments along the lines of "Disgusted!!!!" and "Shameful!!" and "IT IS CERTAINLY NOT FIXED."
If you're still missing data, the blog lists several links that might be able to help you recover it.
Are you still having Hotmail data issues? Comment here or drop me a line.
Posted by David Ramel on 01/12/2011 at 1:15 PM7 comments
Microsoft is providing scant details about last weekend's Windows Live Hotmail outage, but the Data Driver blog's interest was piqued by a Microsoft announcement in a blog post that customers "temporarily lost the contents of their mailbox through the course of mailbox load balancing between servers."
And, as has been reported many times, Hotmail runs on SQL Server. A December 2009 blog posting that offered "A peek behind the scenes at Hotmail" indicated the service is "the largest SQL Server 2008 deployment in the world (we monitor and manage many thousands of SQL servers)." (Coincidentally, both aforementioned posts were in the Windows Team Blog.)
Of course, after the outage was fixed, the anti-Microsoft camp soon weighed in with some pointed digs, such as these two found in comments on a Yahoo News article:
- "Wow! Microsoft is blaming their service failure on a Microsoft server. Wow!"
- "Maybe someone should tell them about Linux?"
But interestingly, according to Yahoo Answers, "Before Microsoft bought out Hotmail, their servers were all Linux based, and Microsoft left them that way for many years until the bad publicity forced them to use their own operating systems."
Of course, all computer systems will suffer failures, and I think Microsoft is as serious about reliability and security as anyone. But coming close on the heels of the cloud-based Business Productivity Online Suite data breach, the Hotmail outage opens the company up to yet more criticism as it seeks to transition to "live" and cloud-based services.
Ironically, that "peek behind the scenes at Hotmail" posting mentioned earlier included this information:
We make significant investments in engineering and infrastructure to help keep Hotmail up and running 24 hours a day, day in and day out, year after year. You will rarely hear about these efforts – you will only read about them on the rare occasion that something goes wrong and our service has run into an issue.
Do you have any inside info on how Hotmail uses SQL Server or more details on the nature of the outage? Please comment here or drop me a line.
Posted by David Ramel on 01/05/2011 at 1:15 PM2 comments
As an addendum to last week's post about a recent SQL Server camp held for PHP developers, Microsoft's Brian Swan has published some new nuts-and-bolts details for converting MySQL queries.
Swan, who blogs on the "At the Intersection of PHP and Microsoft" page, said he learned the technique at the JumpIn! camp, where Microsoft hosted some 17 prominent PHP developers in order to share ideas and educate them about the process of supporting SQL Server and SQL Azure in their PHP applications.
He said it was "an excellent two-way learning experience" and one of the things he learned was that the SQL Server Migration Assistant for MySQL 1.0 (SSMA) can convert specific database queries in addition to its main job of converting databases.
Swan explains the relatively straightforward process by using SSMA to convert the MySQL query:SELECT post_title, post_date FROM wp_posts ORDER BY post_date LIMIT 5 OFFSET 5;
to the SQL Server query:SELECT TOP (5) ssma$sub1.post_title, ssma$sub1.post_date
SELECT wp_posts.post_title, wp_posts.post_date, ROW_NUMBER() OVER (
ORDER BY wp_posts.post_date) AS ssma$rownum
) AS ssma$sub1
WHERE ssma$sub1.[ssma$rownum] > 5
ORDER BY ssma$sub1.[ssma$rownum]
(Whew! If I'm a noob evaluating the two on the basis of query simplicity, it's pretty clear which direction I'd lean.)
Swan noted that all queries won't translate successfully (if they contain functions specific to MySQL, for example), but even if it doesn't work, it can provide clues to help write the translated query yourself.
Do you have experience in supporting SQL Server in PHP apps? Is MySQL really that much simpler than SQL Server? Please share your thoughts here or drop me a line.
Posted by David Ramel on 12/08/2010 at 1:15 PM3 comments
Microsoft isn't letting up on its full-court press to woo PHP developers into the SQL Server world.
The company earlier this month hosted 17 PHP developers at a SQL Server JumpIn! Camp, where they learned how to incorporate SQL Server support into their apps with the help of Microsoft experts, according to a post yesterday in the Microsoft SQL Server Driver for PHP Team Blog.
Program manager Ashay Chaudhary reported that the 17 developers represented 10 PHP projects from several countries. They were treated to dinners, entertainment and more at the five-day camp, where the goal was to "listen to and learn from the PHP community and educate them about our technologies, SQL Server, SQL Azure, Windows Azure & IIS, and help them understand how they can leverage them best in the applications."
The 10 projects included content management systems, a profiling utility, an e-commerce solution, a Web application framework and more. Chaudhary said eight of the projects completed enough coding to demo their apps with SQL Server, while four actually managed to publish builds during the camp. Four projects reported improved their performance on IIS using the WinCache extension, four tested successfully on SQL Azure and three used the new PDO driver for SQL Server support.
"By adding support for SQL Server, these projects stand to gain from the broad customer base that already has SQL Server in their organizations," Chaudhary said.
"We now have a much clearer understanding about what we need to do to better support PHP applications on Windows/IIS/SQL Server and the Azure platform," he said. "The PHP participants now have a better understanding of how SQL Server works and how PHP applications can best utilize its capabilities, and understand how we are trying to add value to their applications."
Last April, Microsoft held a similar camp in Zurich, Switzerland.
Chaudhary said he will write more about the November camp as he has time to reflect on the event, but he didn't indicate that any future camps were scheduled.
"For now," he said, "you can look forward to Windows, IIS, and SQL Server support in several great PHP applications with many more to come over the next few months."
One of those apps will be ImpressCMS, a content management system. Marc-Andre, CEO and founder of ImpressCMS, blogged that his goal at the camp was to "implement PDO and MSSQL support" into his product and reported it was a success. "We are still missing a few things in the installer to make our CMS install properly on MSSQL, but we will get there!" he said.
What do you think about Microsoft's overtures to the open source community? Comment here or drop me a line and share your thoughts.
Posted by David Ramel on 11/30/2010 at 1:15 PM1 comments