Close
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Menu
Search
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database

    Whats Next for SQL Server?

    By
    Lisa Vaas
    -
    September 26, 2003
    Share
    Facebook
    Twitter
    Linkedin

      Users demanded SQL Server bond tighter with Visual Studio .Net, and Microsoft Corp. has since heeded the call, putting into beta testers hands a version that opens the database up to .Net-compliant languages.

      The next version of SQL Server, code-named “Yukon,” was originally slated for a spring 2004 release. That deadline was pushed out to the second half of next year after customers said they expected Yukon to fit hand-in-glove with the next version of .Net, code-named Whidbey. The Yukon beta was released in July to some 2,000 customers and partners.

      eWEEK recently talked with Microsoft Group Product Manager Tom Rizzo to find out how the .Net integration that customers demanded, along with upcoming features such as native XML and Web Services support, will benefit enterprises.

      eWEEK: Were hearing that customers are asking for greater interoperability, greater flexibility and greater choice in programming models. What kind of interoperability are they seeking?

      Rizzo: Theres a couple different levels in interoperability. One is interoperability between the data of data-base vendors. They want data to go from Oracle [Corp. databases] into SQL Server or from Sybase [Inc. databases] into SQL Server. Then theres interoperability between the database vendor and the data stored in the database vendors products.

      The next level of interoperability is more around interoperability in their application development platform and application server environment. Thats things like, Make sure it works in .Net as well as J2EE so I can access the data in my database. So a customer can say, Im a Java shop, Im a .Net shop, Im both, and I can still build applications that work in SQL Server.

      Were hearing more and more not just about those two things, but business interoperability, which is, I have partners outside my firewall. I need to interoperate with them with my data. Make sure I can expose my data in an Internet-friendly way. And thats XML and Web Services.

      eWEEK: SQL Server 2000 already has XML support. How are you deepening that in Yukon?

      Rizzo: From the data level, we have things like native XML support. You take data from SQL Server, put it into XML format and ship it to anything that understands XML, such as Oracle has some XML support, and [IBMs DB2 database].

      XML is ultimate interoperability—its an industry-standard format, and its self-describing. You know both the schema of the data as well as the data itself. You dont lose the context when you pass your data around.

      We upped the level of XML support in Yukon through a number of things. In 2000 we had XML support but … it was shredding. [Shredding is the parsing of XML tag components into corresponding relational table columns.]

      In Yukon the key thing is we have an XML type. Like you have STRING and NUMBERS and all that inside the database, now you can declare [with the native data type] XML. Although we had XML support in 2000, and many leveraged it and were happy with it, now we have native support.

      eWEEK: Why is a native data type for XML so important?

      Rizzo: One reason we did it is to support XQuery. Also to support XQuery we had to build code so as to combine XML with relational query language. You can take the relational sorts of queries youre used to in the database world, where people select things from tables with filters on that data. You can combine XQuery statements [with such relational queries].

      Imagine, you have a database table of information, maybe sales information. It has customer information, but thats stored as XML type within the table. Maybe it comes from another application as XML. Maybe you want to store it as XML so you can give it to another application, say a CRM application. Maybe you have a million rows in the database: not only customer information in XML but maybe what they bought and when they bought it.

      [In SQL Server 2000] we allow you to query the data with existing relational queries, so you can say, Show me all orders over $1 million. That datas stored as relational. But now [with Yukon] you can say, Show me all orders over $1 million in Pennsylvania. Since the customer information is in XML, you can do a standard relational query and query into the XML document.

      We call this cross-domain queries. You have a relational domain and the XML domain. We allow you, in a seamless way, to do things across the two domains that are much, much easier.

      eWEEK: Whats up with Web Services in Yukon?

      2

      Rizzo: Today in SQL Server 2000 we support Web Services. We have a tool kit customers can download. It does require you to have IIS [Internet Information Services Web Server] running in your environment. With Yukon we remove that requirement. SQL Server can expose Web Services without having to have IIS running in your environment.

      The benefit is now the relational database can expose anything—for example, a stored procedure or data itself—as a Web Service, without requiring that infrastructure. Youve got this component between you and the database now. Theres a little performance hit, with two pieces instead of one. Now we get even better performance.

      eWEEK: Will performance improve in Yukon?

      Rizzo: Our goal is that Yukon will at least meet the same performance as SQL Server 2000, but were hoping it exceeds it. Thats in all aspects, not only in terms of what SQL Server 2000 has, but some new capabilities. For example, writing code in .Net should be the same as writing code in the T-SQL environment.

      eWEEK: Which gets us to the question of integrating the database with the .Net framework. Whats the motivation behind that?

      Rizzo: .Net code today doesnt run within SQL Server. It runs separate, outside the database. In Yukon weve put it into the database. Our plan is that T-SQL and .Net technologies will run at the same speed.

      The reason were putting .Net inside the database is now customers can write SQL Server business logic inside the database using any .Net language. For example, you can use C# or Visual Basic. Were also talking with Fujitsu, who builds Cobol .Net.

      Customers like the productivity of .Net, in terms of time to market. It allows them to build code faster. They dont have to build their own functions, because .Net has a framework that takes advantage of base things you have to do in programming. Customers want to take the skills, languages, Web sites and certifications they have in the .Net world and allow them to come into internal database business logic.

      Heres the scenario: A business has all its DBAs trained in Visual Basic. They go to SQL Server and have to use this thing called T-SQL. Its not hard, but theyre not 100 percent trained on it. A lot say, Hey, I want Visual Basic everywhere. So were providing customers the ability to have flexibility.

      Were also working closely with Borland, not only with C# but with J Builder, a Java-based product to support SQL Server 2000 and Yukon. Wed love for the entire world to be .Net-based. But customers make decisions based on their business needs, and some choose Java. We want to make sure we support whatever customers decide to program with.

      eWEEK: What are some other highlights of Yukon?

      Rizzo: In Yukon, well enhance Reporting Services. Well also ship a very much improved business intelligence platform.

      Weve seen great adoption of business intelligence technologies inside SQL Server as well as Microsoft Office. With Yukon were turning up the crank another notch, adding things like more advanced data mining technologies. One thing we heard from customers, they said Hey, business intelligence is great, it helps me figure out what happened in my business in the past. But computers should help me predict what will happen based on data they have stored and algorithms. Thats why were investing in business intelligence.

      There are two data-mining algorithms in SQL Server today. Six more will be added to Yukon. Integrated data mining, integrated reporting, business reporting overall, is really what makes data youre storing come alive.

      eWEEK: What about security in Yukon?

      Rizzo: Were doing a ton of work in security. We did a ton of work inside SQL Server 2000. We did a ton of work in Service Pack 3.

      Yukons one of many things in the road to secure computing for Microsoft. One thing youll see us do over the next couple months for SQL Server 2000, well come out with Microsoft Update. It will allow you to patch SQL Server in the automated way you now do with Windows.

      Well also add new security features like secure by design and secure by default. We wont have services turned on by default; youll have to opt on. Well have secure default settings, so passwords have to be strong, with characters, numbers and symbols. You cant put password as your password.

      eWEEK: What about improving manageability, scalability and availability?

      Rizzo: Those are our bread and butter. When it comes to databases, you can have great programming environment, great business intelligence features, but if the servers down, or if its not secure, well, youre done.

      Discuss This in the eWEEK Forum

      Avatar
      Lisa Vaas
      Lisa Vaas is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on eWEEK.com, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.

      MOST POPULAR ARTICLES

      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      Chris Preimesberger - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Cloud

      Why Data Security Will Face Even Harsher...

      Chris Preimesberger - December 1, 2020 0
      Who would know more about details of the hacking process than an actual former career hacker? And who wants to understand all they can...
      Read more
      Cybersecurity

      How Veritas Is Shining a Light Into...

      eWEEK EDITORS - September 25, 2020 0
      Protecting data has always been one of the most important tasks in all of IT, yet as more companies become data companies at the...
      Read more
      Big Data and Analytics

      How NVIDIA A100 Station Brings Data Center...

      Zeus Kerravala - November 18, 2020 0
      There’s little debate that graphics processor unit manufacturer NVIDIA is the de facto standard when it comes to providing silicon to power machine learning...
      Read more
      Apple

      Why iPhone 12 Pro Makes Sense for...

      Wayne Rash - November 26, 2020 0
      If you’ve been watching the Apple commercials for the past three weeks, you already know what the company thinks will happen if you buy...
      Read more
      eWeek


      Contact Us | About | Sitemap

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Property of TechnologyAdvice.
      Terms of Service | Privacy Notice | Advertise | California - Do Not Sell My Information

      © 2021 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×