stargeek
PHP news website logo.
home    PHP scripts    articles    seo tools    links    search    contact    shop    realtors


What's New in FOR XML in Microsoft SQL Server 2005







What's New in FOR XML in Microsoft SQL
Server 2005

What's New in FOR XML in Microsoft SQL
Server 2005
06/21/2004 11:23 PM

This first in a series of articles by Michael Rys details the major new capabilities of the server-side FOR XML clause in the next version of SQL Server. These enable you to further enhance the XML support in your applications and to write easy-to-maintain relational data-to-XML aggregations.




This is a GrokNews Entry: (what is grok?)





Similar Items

What's New in FOR XML in Microsoft SQL Server 2005

Grok Headline matches for What's New in FOR XML in Microsoft SQL Server 2005

Microsoft Delivers Latest Visual Studio
2005 and SQL Server 2005 Releases


Microsoft Delivers Latest Visual Studio
2005 and SQL Server 2005 Releases
04/18/2005 11:14 AM
Microsoft Corp. today announced availability of Visual Studio® 2005 Beta 2, Microsoft® .NET Framework 2.0 Beta 2 and the SQL Server (TM) 2005 April Community Technology Preview (CTP), the latest milestone in delivering these products to customers. Together, the products provide a deeply integrated development and data management platform, enabling customers to utilize existing skills and familiar tools to harness data in powerful new ways that increase productivity and efficiency. Several early adopters such as ABS-CBN Interactive, ORF and Townsend Analytics Ltd. have deployed these products in their production environments to reap the benefits of close tool and database integration. Because of broad customer demand to work with these prerelease products today, Microsoft also announced the Microsoft Go-Live license program for customers interested in deploying Visual Studio 2005 and SQL Server 2005 Express Edition immediately. Microsoft and multiple partners today also announced plans to provide customers with educational resources that will help them prepare for the launch of these two products.

Microsoft Releases Visual Studio 2005
Beta Two, SQL Server 2005 Preview


Microsoft Releases Visual Studio 2005
Beta Two, SQL Server 2005 Preview
04/18/2005 11:49 PM
Information Week Apr 19 2005 4:14AM GMT

Microsoft Distributes RC of Live
Communications Server 2005 September 13
- 8:24 PM ET Microsoft has provided b


Microsoft Distributes RC of Live
Communications Server 2005 September 13
- 8:24 PM ET Microsoft has provided b
09/13/2004 09:45 PM
BetaNews Sep 14 2004 1:54AM GMT

Microsoft Announces Virtual Server 2005
Release Date September 10 - 12:15 AM ET
News in Brief | Microsoft is i


Microsoft Announces Virtual Server 2005
Release Date September 10 - 12:15 AM ET
News in Brief | Microsoft is i
09/10/2004 03:46 AM
BetaNews Sep 10 2004 7:10AM GMT

XML Best Practices for Microsoft SQL
Server 2005


XML Best Practices for Microsoft SQL
Server 2005
08/03/2004 12:31 AM
Microsoft SQL Server 2005 provides extensive support for XML data processing. XML values can be stored natively in an XML data type column, which can be typed according to a collection of XML schemas, or left untyped. You can index the XML column. Furthermore, fine-grained data manipulation is supported using XQuery and XML DML, the latter being an extension for data modification. SQL Server 2000 and SQLXML Web Releases provide powerful XML data management capabilities. These features focus on mapping between relational and XML data. XML views of relational data can be defined using annotated XSD (AXSD) to provide an XML-centric approach that supports the bulkload of data, query, and update capabilities on XML data. Transact-SQL extensions provide a SQL-centric approach for mapping relational query results to XML (using FOR XML), and generating relational views from XML (using OpenXML). These supports have been extended in SQL Server 2005. Together with the newly added native XML support, SQL Server 2005 provides a powerful platform for developing rich applications for semi-structured and unstructured data management.

Microsoft launches Virtual Server 2005


Microsoft launches Virtual Server 2005 09/14/2004 08:57 AM
PC Pro Sep 14 2004 1:04PM GMT

Microsoft on last lap for Visual Studio
and SQL Server 2005


Microsoft on last lap for Visual Studio
and SQL Server 2005
04/19/2005 09:25 AM
Computer Weekly Apr 19 2005 1:46PM GMT

Microsoft set to ship Virtual Server
2005


Microsoft set to ship Virtual Server
2005
09/09/2004 08:42 AM
Microsoft Corp. next month will release Virtual Server 2005, its first foray into server virtualization and a key element of the broad management platform the company is creating for Windows.

Microsoft Releasing Virtual Server 2005


Microsoft Releasing Virtual Server 2005 09/10/2004 02:43 PM
theWHIR Sep 10 2004 7:12PM GMT

Microsoft unveils Virtual Server 2005


Microsoft unveils Virtual Server 2005 09/14/2004 10:43 AM
vnunet.com Sep 14 2004 2:07PM GMT

Microsoft prepares SQL Server 2005 for
AMD64


Microsoft prepares SQL Server 2005 for
AMD64
07/27/2004 05:58 AM
PC Magazine UK Jul 27 2004 10:18AM GMT

Microsoft Set to Release Virtual Server
2005


Microsoft Set to Release Virtual Server
2005
09/08/2004 06:08 PM
Microsoft is counting on its new offering as a way to entice users of older versions of Windows Server to migrate to Windows Server 2003.

Microsoft releases SQL Server 2005 beta


Microsoft releases SQL Server 2005 beta 07/26/2004 12:19 PM
A widely available test version of Microsoft's database will support AMD's Opteron processor.

Microsoft Releases SQL Server 2005 Beta
2


Microsoft Releases SQL Server 2005 Beta
2
07/26/2004 04:06 PM
On Monday Microsoft released SQL Server 2005 Beta 2, featuring support for the 64-bit AMD Opteron processor. In addition, this release includes security enhancements along with new management, development and business intelligence tools. The Beta 2 release is available to MSDN subscribers from the MSDN web site. The final release of SQL Server 2005 is expected early next year.

Microsoft Windows Server plans for 2005


Microsoft Windows Server plans for 2005 12/24/2004 12:55 PM
Following the announcement that Microsoft lost the EU appeal against removing Windows Media Player from it's Windows XP operating system, what is Microsoft planning for 2005?

It's not yet clear whether work has begun on removing Windows Media Player from XP but if work is planned to start in the New Year then this could significantly delay Longhorn, again. Depending on how Microsoft chose to remove Windows Media Player they may need to recompile different sections of the operating system to ensure there is no shell integration of WMP whatsoever. Changing an operating system and ensuring it has hot fix compatibility may require an external beta test to OEMs and partners. It's a big job and one that will inevitably slow down Longhorn progress.

On a bright note 2005 is the year for Windows Server. Last week I sat down with Mark Tennant (Windows Server Product Manager). Although we joked about WinFS (which should be code-named Hokey Pokey) and I fumed about anywhere access being removed from R2; it still seems that the Windows Server team have a lot of things going on in 2005.

Perhaps most significantly in the first half of 2005 we'll see the first Service Pack released. Taking a lot of security improvements from XPSP2, it aims to deliver increased reliability, scalability, security and performance. According to Mark "From our internal tests we’re seeing 20% more users for ERP business applications, 50% more users per server for Terminal Services."

At around the same time we'll see the Windows Server x64 editions available. "Our approach here is to provide low-cost, high volume 64-bit computing with our partners to a broad segment of the market. Again we’re seeing some big performance improvements in some of the traditional windows workloads (Web Servers, File and Print, Terminal Services) as well as customers running their existing 32-bit apps on the x64 platform."

In the second half of 2005 the team will release Windows Server 2003 "R2" and Windows Server 2003 Compute Cluster Edition. "This will see us supporting high performance hardware and related industry standards such as MPI-2 and RDMA over Ethernet and Infiniband, as well as MPICH".

Windows Update Services is the highly anticipated and highly delayed replacement to SUS (Software Update Services). Currently SUS is lacking in terms of functionality but 2005 looks to be the year that WUS will finally make its debut in the first half.

Keep your browser firmly on Neowin.net for the latest Windows Server news in the new year. May I take this opportunity to wish everyone a very Merry Christmas and a Happy New Year!

View: More Information on Windows Server System

Read full story...

Review: Microsoft Virtual Server 2005


Review: Microsoft Virtual Server 2005 06/18/2004 12:21 AM
While server virtualization is nothing new, with the forthcoming release of Virtual Server 2005, an application that virtualizes the Windows 2003 Server operating system, Microsoft promises to ease server application migration and simplify testing environments using a unique take on the technology.

Microsoft introduces Virtual Server 2005


Microsoft introduces Virtual Server 2005 06/22/2004 01:56 PM

Microsoft SQL Server 2005 Express Beta 2


Microsoft SQL Server 2005 Express Beta 2 07/27/2004 05:58 AM

Microsoft Announces SQL Server 2005
Support For AMD 64bit


Microsoft Announces SQL Server 2005
Support For AMD 64bit
07/27/2004 11:22 AM

Microsoft Virtual Server 2005 Standard
Edition RC


Microsoft Virtual Server 2005 Standard
Edition RC
06/14/2004 03:07 PM

Microsoft To Launch Virtual Server 2005
Next Week


Microsoft To Launch Virtual Server 2005
Next Week
09/09/2004 06:54 AM

Direct and Related Links for 'Microsoft To Launch Virtual Server 2005 Next Week'

“The two-year wait is over. Microsoft will formally launch its long-awaited Virtual Server 2005 early next week, sources said. The virtualization software, which Microsoft acquired from the former Connectix in February 2003, runs on Windows Server 2003 only but supports Windows NT and Windows 2000 workloads. It will compete with EMC’s VMware and SW-Soft’s Virtuozzo, which allow for server consolidation and simplified management of applications. Pricing has not yet been released but sources expect the…

Microsoft Virtual Server 2005 will not
be a part of MSDN


Microsoft Virtual Server 2005 will not
be a part of MSDN
09/15/2004 07:29 PM
Microsoft have decided to not make available Virtual Server 2005 for MSDN subscribers. Instead, the company has arranged a special promotion:

The VS and MSDN teams have collaborated to create a special offer for Virtual Server 2005 Standard and Enterprise Editions which are being made available only to MSDN Universal and MSDN Enterprise subscribers between October 1, 2004 and March 31, 2005. This is a special promotional offer.

MSDN Universal and Enterprise level subscribers are being granted special access to Virtual Server 2005 Standard and Enterprise Editions as downloads from MSDN Subscriber Downloads only. Virtual Server 2005 Standard and Enterprise Editions will not be made available by fulfillment or in the monthly subscription shipments.

This is the full retail, production version of the product and does not include the typical MSDN restrictions of running only in dev/test environments and can be run in production (except on XP Pro).


News source: Virtualization.info



Read full story...

Microsoft, ISV Partners Gear Up For
Virtual Server 2005


Microsoft, ISV Partners Gear Up For
Virtual Server 2005
09/15/2004 01:31 PM
Computer Reseller News Sep 15 2004 4:57PM GMT

Microsoft offers sneak peak of SQL
Server 2005


Microsoft offers sneak peak of SQL
Server 2005
08/31/2004 04:49 PM
Microsoft has announced the availability of Beta 2 of its SQL Server 2005 database, which will include support for AMD's 64-bit Opteron CPU and Intel's 64-bit Itanium chip.

Microsoft Plans Security Perks for SQL
Server 2005


Microsoft Plans Security Perks for SQL
Server 2005
05/25/2004 01:34 PM
The software giant adds encryption/decryption to its next-generation database and will put it through the government's security ringer.

Microsoft SQL Server 2005 Express
Technical Preview


Microsoft SQL Server 2005 Express
Technical Preview
06/29/2004 08:42 AM

Microsoft Unveils Live Communications
Server 2005


Microsoft Unveils Live Communications
Server 2005
05/04/2004 12:12 PM
Microsoft Corp. today announced the opening of the beta program for Microsoft® Office Live Communications Server 2005, or LCS 2005, previously code-named "Vienna." LCS 2005, a next-generation enterprise instant messaging (IM) and presence-awareness server, will be a significant next step toward Microsoft's vision of seamlessly connecting people, information and business processes in real time to increase productivity and enable better decisions faster.

Microsoft Distributes RC of Live
Communications Server 2005


Microsoft Distributes RC of Live
Communications Server 2005
09/13/2004 08:33 PM
Microsoft has provided beta testers with Release Candidates for Office Live Communications Server 2005 (LCS 2005) and Windows Messenger 5.1. This distribution marks the software's first major milestone since Microsoft publicly announced the opening of the beta program in May.

SQL Server 2005 Mobile Edition Server
Tools Beta 1 for use with IIS and SQL
Server 2005 Beta 2 (USA)


SQL Server 2005 Mobile Edition Server
Tools Beta 1 for use with IIS and SQL
Server 2005 Beta 2 (USA)
07/27/2004 12:45 AM
SQL Server 2005 Mobile Edition (SQL Mobile) is the compact database for rapidly developing applications in both native mode and the .NET Compact Framework that extend enterprise data management capabilities to devices. Companies and users of SQL Mobile that plan to synchronize to SQL Server 2000 or SQL Server 2005 Beta 2 databases will need to install this Server Tools release on their servers running Internet Information Services (IIS).

Microsoft Announces General Availability
of Virtual Server 2005


Microsoft Announces General Availability
of Virtual Server 2005
09/13/2004 02:39 PM
Microsoft Corp. today announced the general availability and pricing of Microsoft® Virtual Server 2005. Available in both Standard and Enterprise editions, Virtual Server 2005 helps customers reduce hardware costs and increase operational efficiency in three key scenarios: automation of software test and development environments; rehosting of legacy applications; and consolidation of production server workloads such as networking, directory infrastructure or departmental applications. As a key deliverable of the Dynamic Systems Initiative, Microsoft's vision for simplifying and automating the way customers design, deploy and operate distributed systems, Virtual Server 2005 provides customers with more flexibility and control in the provisioning of data center resources.

Microsoft: Windows Server Service Pack,
64-Bit Editions Not Until 2005


Microsoft: Windows Server Service Pack,
64-Bit Editions Not Until 2005
07/27/2004 06:23 PM
The Redmond software maker confirms security-specific Windows Server 2003 update and new 64-bit versions are all running late.

Microsoft Announces SQL Server 2005
Support For AMD Extended System


Microsoft Announces SQL Server 2005
Support For AMD Extended System
07/26/2004 05:40 PM
Microsoft Corp. today announced it would add support for the AMD Opteron (TM) with Direct Connect Architecture in Microsoft® SQL Server (TM) 2005, the next generation of Microsoft's flagship database product. The enhanced functionality provides customers and partners with simultaneous high-performance 32- and 64-bit computing, which gives them the technical and business flexibility to solve their unique problems in a way that best meets their needs. In addition, it supplies customers with a compelling and cost-effective alternative to UNIX-based solutions through 64-bit capabilities that deliver both high scalability and lower cost of ownership. By introducing AMD Extended System architecture in SQL Server 2005, Microsoft is adding a new offering complementing the high-performance 64-bit Intel Itanium support in SQL Server 2000.

Microsoft sends Live Communications
Server 2005 in beta


Microsoft sends Live Communications
Server 2005 in beta
05/05/2004 05:30 AM
PC Pro May 5 2004 8:47AM GMT

Microsoft Offers Virtual Server 2005
Release Candidate


Microsoft Offers Virtual Server 2005
Release Candidate
06/14/2004 04:15 PM
After some delay, Microsoft looks on track with its Virtual Server 2005 software. The company on Monday offered the Release Candidate version for download and said the final code will ship by year's end.

Microsoft Announces Virtual Server 2005
Release Date


Microsoft Announces Virtual Server 2005
Release Date
09/10/2004 12:08 AM
Microsoft is inching closer toward the release of Virtual Server 2005. Virtual Server leverages the Windows 2003 Server system as a platform for running multiple instances of alternative operating systems on a single system. The final version of the Server will be made available on September 13th in two varieties: Standard and Enterprise. More information on Virtual Server is available in the BetaNews archives.

Microsoft Live Communications Server
2005 Beta Challenge


Microsoft Live Communications Server
2005 Beta Challenge
07/02/2004 08:17 AM

Microsoft Announces Availability and
Pricing of Virtual Server 2005


Microsoft Announces Availability and
Pricing of Virtual Server 2005
09/13/2004 10:43 AM
WebProNews Sep 13 2004 1:49PM GMT

ActiveWin.com: Microsoft Virtual Server
2005 Enterprise Edition - Review


ActiveWin.com: Microsoft Virtual Server
2005 Enterprise Edition - Review
04/10/2005 11:18 PM
http://www.activewin.com/reviews/software/servers/microsoft/virtual05/ images/box.JPG

Microsoft to Extend the Reach of Live
Communications Server 2005 to Mobile
Devices


Microsoft to Extend the Reach of Live
Communications Server 2005 to Mobile
Devices
04/19/2005 03:45 AM
Microsoft Corp. today announced it is extending Microsoft® Office Live Communications Server 2005 capabilities to mobile devices, enabling companies to deploy trusted instant messaging (IM) and presence-enabled solutions that provide a consistent experience across PCs and smart mobile devices. As an initial step, the company unveiled plans to deliver a new mobile Live Communications Server 2005 client, for Windows Mobile (TM) -based devices.
Grok Description matches for What's New in FOR XML in Microsoft SQL Server 2005
GrokA matches for What's New in FOR XML in Microsoft SQL Server 2005

What's New in FOR XML in Microsoft SQL Server 2005

The following phrases have been identified by the grok system as matching this entry:

















Also check out:


Grok

Ipod Porn on the
Rise

Brief Abstract of
Wikipedia's
Mesothelioma Cancer
page

Get first aid
instructions in your
cell phone

IE is crap
JSPWiki gains
podcasting support

Security Headaches?
Take ASP.NET 2.0!

Is Burton Really
Ready?

Microsoft: Buyback
or the Bahamas?

Winners of the
ExtremeTech Extreme
Case Mod Contest

ATI HDTV Wonder
Arts and Cultural
Happenings In
Connecticut

Apple & BMW
Seamlessly Integrate
the iPod and Car
Audio System

Mac Design
Conference & Expo
draws large
attendance

Got docks in your
pocket and don't
know what to do with
them?...Ask DrBott

LGA 775: A Joke And
A Threat That Is No
Joke.

Skype
The 23rd Top500 list
Huayi group values
patent technology

WA police in
internet paedophile
sting

Rate-limiting
Moonshine

Microsoft Business
Solutions Updates
Great Plains Suite

Ask Jeeves Zooms
into Site Preview

Business IM Vendors
Look for Answers,
Profits

Warehouser Admits
Selling Rat-Tainted
Meat (AP)

Bush's Ratings Erode
as Anti-Terror
Fighter

Connecticut
Republican Governor
Quits Amid Scandal

Conn. Gov. Rowland
Resigns Over
Corruption Scandal

Camcorder bounty
Friend of research?
Accord over
satellite

Posthumous nod
Cambridge to open
center

Court backs AMD
Customs computer
project criticised

Oracle Weighed Bids
for 2 Others in
Software Before
Aiming at PeopleSoft

IE/0DAY -> Insider
Prototype

ZoneAlarm Pro
'Mobile Code' Bypass
Vulnerability

Re: Virus scan
attack

Multiple osTicket
exploits!

Code execution in
the Unreal Engine
through \secure\
packet

Beer prices set for
MPs inquiry

'GM cargo ship'
campaigners held

Urgent talks on
seized UK crew

Programmer Has Lost
All Motivation to
Work!

Buying a PR8 Site
for it's PR

Governor Quits Under
Pressure in
Connecticut

Top Commanders Can
Be Questioned in
Prison Abuse Case

Justices Limit
Ability to Sue
Health Plans

Bush Considers
Replacing Tenet More
Quickly

Silicon Valley
(Version 2.0) Has
Hopes Up

Private Team, in a
Milestone, Sends
Manned Craft to
Space

Navratilova Wins and
Aims Volleys at
Critics

Oracle Mulled Other
Software Takeovers
(Reuters)

U.S. Unveils Oracle
Takeover Target List
(AP)

Tech Alliance on
'Digital Living' to
Be Unveiled
(Reuters)

what is grok?