SQL.RU
 client/server technologies
 Главная | Документация | Статьи | Книги | Форум | Блоги | Опросы | Гостевая | Рассылка | Работа | Поиск | FAQ |

SQL Server 2005

SEMINARS   PUBLICATIONS

CONTENTS

01. Reviews
02. Installing and Database Engine
03. Security
04. Languages and Programming
05. Tools and Utilities
06. Replication
07. Data Transformation Services
08. Analysis Services
09. Reporting Services
10. Notification Services
11. Service Broker
12. Full-Text Search

2005/12/26 (292)

01. Reviews


Exam Thoughts 70-441
Steve Jones
Steve Jones recently took the 70-441 Beta exam for Developing Solutions on SQL Server 2005. This article will not break the NDA and tell you what the content is, but it gives you some feedback from a SQL Server 2000 DBA on the new exam.

SQL Server 2005 Samples and Sample Databases (December 2005)
Microsoft
The samples databases downloads include the AdventureWorks sample online transaction processing (OLTP) database, the AdventureWorksDW sample data warehouse, and the AdventureWorksAS sample Analysis Services database. These databases are used in the samples and in the code examples in the SQL Server 2005 Books Online

That time has come.... goodbye SQL Server, hello WinFX!
Eric Nelson
For the last two years I have been working with UK ISV early adopters of SQL Server 2005 - a great product and a very fun two years. However come January 2006 my focus pretty much switches entirely to development for Windows Vista/WinFX and then later in the year I will also pick up Office 12 development. This blog has majored on SQL Server 2005 - but I feel with the launch safely behind us the time has come to switch the focus of this blog over from SQL Server to (initially) development with WinFX.

Стив Баллмер: "Для SQL Server 2005 нет ничего невозможного"
Александр Лобас
MSSQLServer: Стив Баллмер: "Для SQL Server 2005 нет ничего невозможного" На прошлой неделе в Сан-Франциско состоялось официальное представление сервера баз данных Microsoft SQL Server 2005, пакета для разработки Visual Studio 2005, а также анонс сервера интеграции BizTalk Server 2006...

Embedding SQL Server Express into Custom Applications
Robert Walters
This white paper discusses how to integrate and deploy Microsoft SQL Server Express-based applications by using configuration files and the ClickOnce deployment technology in Microsoft Visual Studio.

Новые аргументы в пользу перехода на SQL Server 2005
Брайан Моран
MSSQLServer: Итак, SQL Server 2005 увидел свет. По всему миру проходят акции по продвижению нового продукта, элементы которого можно загрузить из MSDN. У некоторых распространителей можно приобрести носители с программным обеспечением. Теперь переход большей части клиентов SQL Server на SQL Server 2005 - только вопрос времени. Большинство технических специалистов заинтересованы в скорейшем переходе - никому не хочется оказаться последним в ряду счастливых обладателей <новой игрушки>. Однако руководители, больше всего обеспокоенные вопросами безопасности, склонны подождать появления первого пакета обновлений. Отложим рассуждения о плюсах и минусах ранней модернизации и вернемся к образному сравнению, предложенному несколько ранее в материале "Переход к SQL Server 2005: кто первый?" В...

Oracle 10g vs SQL Server 2005
Darren Gosbell
I had a request recently from someone for information on performance of Oracle 10g vs SQL Server 2005. I don't think there is too much around on SQL 2005 yet as it has not been officially released for that long and the Beta and CTP releases were not really meant to be used for benchmarking (in fact I think the license agreements explicitly states that this is not allowed).

A first look: SQL SERVER 2005
jason
Well this weekend I received my copy of the SQL server 2005 community preview. And last night I successfully migrated my MSSQL 2000 server to the 2005 server. The installation started a bit rocky as I had a few Microsoft beta products installed, such as the 2.04 framework. Once I removed these beta products the installation went very smoothly. It allowed to create a second instance of SQL server 2005 and run it side by side with my current SQL server 2000 instance. With both servers up at once it was very easy to move my data and stored procedures over.

Microsoft объявила о выходе Visual Studio 2005 и SQL Server 2005
Поль Тюрро
MSSQLServer: Microsoft официально выпустила Visual Studio 2005 (прежнее кодовое название Whidbey) и SQL Server 2005 (прежнее кодовое название Yukon) на большом гала-представлении в Москон-центре (Moscone Center) Сан-Франциско. Председательствовал на конференции Стив Балмер, Microsoft CEO, он и сделал основной доклад. Microsoft объявляет оба продукта готовыми для публичного использования непосредственно после обнародования этой информации. Подписчики Microsoft Developer Network - MSDN - получили доступ к обоим продуктам уже на прошлой неделе. Третий продукт, Microsoft BizTalk Server 2006, также выпускается, однако его поставки начнутся только в начале следующего года...

SQL Express 2005 без ограничений по пользователям
Олег Михайлик
MSSQLServer: Обнаружилось, что SQL Server Express не имеет нескольких очень существенных ограничений своего предшественника MSDE. Давайте по порядку, какие ограничения есть...

Жаркие денечки SQL Server 2005 Express
Майкл Оти
MSSQLServer: Что объединяет Microsoft Windows Update Services (WUS), Systems Management Server (SMS), Visual Studio (VS) и Microsoft Operations Manager (MOM) - в дополнение к многочисленным приложениям независимых производителей, таких как HP Systems Insight Manager, VMware Virtual Center, и еще сотне других приложений независимых поставщиков? Нет-нет, не все они разработаны с использованием .NET, это не так, и не все поставляются на компакт дисках. Правильный ответ: все создаваемые сейчас версии этих продуктов будут использовать новое ядро настольной базы данных, SQL Server 2005 Express...

Release: SQL Server 2005 Express
Олег Михайлик
MSSQLServer: В отличие от предшественника MSDE, лицензировать SQL Server Express для использования в своих программах можно совсем бесплатно. Как известно, MSDE предоставлялся "почти" бесплатно, то есть в комплекте с другим софтом, например Microsoft Office...

Visual Studio 2005 Express - БЕСПЛАТНО!
Олег Михайлик
C-sharp: Новые продукты линейки Visual Studio выпущены бесплатно!...

Переход к SQL Server 2005: кто первый?
Брайан Моран
MSSQLServer: Прежде чем сказать несколько слов о программе SQL Server Front Runner, хочу напомнить забавную историю о пингвинах, рассказанную генеральным менеджером Microsoft по SQL Server Engine Дэвидом Кэмпбеллом на саммите профессионального объединения специалистов по SQL Server (Professional Association for SQL Server - PASS). Как ни странно, связь имеется...

Лучший способ получить Visual Studio 2005
Microsoft
C-sharp: С выходом Visual Studio 2005 будут выпущены 5 новых вариантов подписки MSDN уровня Premium: одна для версии Visual Studio 2005 Team Suite, по одной для каждой из ролевых версий Visual Studio 2005 Team Editions для программистов (for Software Developers), проектировщиков (for Architects) и тестировщиков (for Testers); и еще одна для Visual Studio 2005 Professional. В каждой из этих подписок MSDN Premium сочетается полный набор возможностей MSDN Universal, один из инструментов разработки Visual Studio 2005, а также приоритетный доступ к обновлениям продуктов и новым выпускам...

LAUNCH DAY!!! Why are we doing such tight integration between VS and SQL Server anyway?
Euan Garden
I’ve just come out of SteveB’s jam packed keynote I thought I would take the chance to write down some thoughts on why the VS integration is a key component of this SQL Server release.

SQL Server 2005 BI более чем в два раза дешевле чем Oracle 10 BI
Михаил Козлов
MSSQLServer: Что бы сравнить цены Microsoft SQL 2005 BI с Oracle BI при процессорном лицензировании для N-процессорной машины со стороны Microsoft нужно 24,999 (U.S.) (цена Enterprise Edition) умножить на N. Все необходимые для BI компоненты (OLAP, Reporting, Data Mining, Notifications, KPIs, среда BI разработки) уже включены в стоимость SQL Server. Для Oracle 10 BI нужно выполнить более сложные вычисления, т.к. придется покупать много дополнительных компонентов, включая ежегодно оплачиваемую поддержку плюс право на получение "заплаток"....

SQL Server 2005 - Вау!!!
Михаил Козлов
MSSQLServer: Я не большой специалист в реляционных базах данных, но знающие люди говорят, что SQL Server 2005 - это очень круто! А интегрированные возможности BI, поверьте, действительно очень впечаляют. Особенно на фоне все остального, что есть на рынке :-)...

Сегодня SQL Server 2005 и Visual Studio 2005 выпущены в производство!
Михаил Козлов
MSSQLServer: Подписчики MSDN могут не дожидаться выхода продуктов на носителях и могут загрузить необходимые им версии в рамках своей подписки...

Top 10 new features in SQL Server 2005
Jeremy Kadlec
In the business world, everything is about being "better, faster and cheaper" than the competition -- and SQL Server 2005 offers many new features to save energy, time and money. From programming to administrative capabilities, this version of SQL Server tops all others and it enhances many existing SQL Server 2000 features. Here I'll outline the 10 most significant new features in order of importance:

Siebel 7.7 Benchmarks on SQL Server 2005
anuchaw
At Siebel Customer World 2005 held in Boston last week, two new record breaking Siebel Platform Sizing and Performance Benchmarks (PSPP) were announced. The world record for Siebel Scalability is now the 30,000 Siebel Concurrent User Benchmark on SQL Server 2005. This is an amazing performance benchmark with real world Siebel workloads that is done on a 16 X HP Integrirty 8620 machine with 64 GB of RAM. SQL Server 2005 Non Uniform Memory Access (NUMA) and connection affinity features maximised the performance and scalability of the HP Integrity rx8630 database server. Read the full bencmhark results and get information on how it was done

Microsoft Research Tech Transfers: Better Decisions Faster
Microsoft
Microsoft SQL Server 2005, Visual Studio 2005 and BizTalk Server 2006 are poised for launch, and key components of the products stem from technology transfers by Microsoft Research.

Choosing a Database for High Availability: An Analysis of SQL Server and Oracle
Microsoft
SQL Server 2005 provides enterprise-class high-availability features at a lower cost than Oracle 10g. This white paper compares the high-availability features of SQL Server 2005 and Oracle 10g that address planned and unplanned downtime. Additionally, this paper presents steps to overcoming the primary barriers to high availability.

My Top 10 SQL 2005 Features for RTM
Myles Matheson
This post is all about the top ten features I am looking forward to in SQL Server 2005. You may be surprised it’s not just SSIS nor is it just about reporting services.

SQL Server превосходит Oracle
Buck Woody
MSSQLServer: Энтузиасты Oracle очень любят критиковать SQL Server, и Бак Вуди думает, что пришло время перевести этот спор на более профессиональный уровень. Раз есть такой спор, то он хочет логически выявить, что лучше: SQL Server или Oracle. Хотите узнать, кто победитель?...

SQL Server нацелен на нишу рабочих групп, и цена его растет
Paul Thurrott
MSSQLServer: Не так давно компания Microsoft объявила, что несколько раз отложенный SQL Server 2005 (собственно говоря, его можно называть группой продуктов) выйдет в середине года. С выходом новой версии мы увидим новое позиционирование сервера и более высокую цену. Начнем с того, что Microsoft добавляет редакцию SQL Server по имени Workgroup Edition. Но этот продукт не будет ожидать выхода SQL Server 2005. Нет, Microsoft планирует выпустить SQL Server 2000 Workgroup Edition этой весной, до выхода SQL Server 2005...

So what does SQL 2005 mean to an ISV? Part 1
Ryan Storgaard
Let's face it, there is a LOT of information available out there on SQL 2005, Visual Studio 2005, Visual Studio Team System, and BizTalk 2006. What I'd like to do, in a series of posts over the next little while, is to take a different approach to discussing the features of these products. I'm sure you'd love to hear how "super excited" I am about them but I have a feeling you'd rather understand the features from the perspective of "how can I make a more powerful product leveraging these Microsoft products so that as an ISV I can make more money!!".

Changes to the Readme.txt file for SQL Server 2005 September CTP
Microsoft
The following information has changed or has become available since the ReadmeSQL2005.htm file for SQL Server 2005 September Community Technology Preview was published.

Getting ready for SQL Server 2005
Sandy Yakob
Welcome! I am Sandy Yakob with the Microsoft SQL Server Content team. I will be your hostess for what I hope are many future SQL Server Support Voice columns. A quick note about me: I have been with Microsoft for 14 years, and for the past three years I have been working in the SQL Server Content team.

September CTP Issues
Steve Jones
The September CTP of SQL Server 2005 is not available and I'm sure lots of people have downloaded it. I actually grabbed it the night before it was announced, got some pre-release info :), and got it burned onto a CD. Or I got the downloaded EXE burned at least.

SQL Server 2005 Technical Overview blogcasts
Mat Stephen
New SQL Server 2005 Technical Overview blogcasts from the States

SQL Server 2005 September CTP Highlights - Part 1
SQL Server 2005 Distilled
Version: 9.0.1314.06 .NET Framework Version: 2.0.50727.26. This is the last CTP before the final release.

Changing the Game
Soumitra Sengupta
I am writing from PDC 2005, at Los Angeles. Anders Hejlsberg just showed a demonstration of the Language Integrated Query Framework (codename Project LINQ) at Jim Allchin's keynote address. If you are not at PDC and want to see what this is all about, please visit http://msdn.microsoft.com/netframework/future/linq/. The site will be up and running in the next few days. If you program against SQL Server and XML it will be worth your while. It is going to change the way you will query, transform and manipulate data from relational databases, XML and in-memory objects. The result I believe is dramatic increase in productivity.

Big SQL Server 2005 News
sqlservercentral
Confidential until the official release at 9:00am Pacific Time today. Check back after that time to get the big news!

SQL Server 2005 Tidbit 018
Kevin Remde
A little birdie told me to expect a big announcement about SQL Server 2005 in the next day or two, originating from the floor of the PDC.

SQL Server 2005 Tidbit 019
Kevin Remde
I promised there would be some news on SQL Server 2005, and it happened today.

SQL Server 2005 Update from Paul Flessner
Paul Flessner
We are nearing the finish line of what will be the biggest release in SQL Server's history. Today, we achieved our latest milestone with the delivery of our final Community Technology Preview (CTP), the September CTP, which is available for download on the SQL Server Downloads page. More than 300,000 of you downloaded our previous CTP from the Web site or requested CDs. With your help, we hope to exceed these numbers.

SQL Server September CTP and VS.NET RC are here!
Prologika
If you are subscribed to Microsoft Beta, you can downoad the SQL Server September CTP and Visual Studio Release Candidate (plan for a day or two given the 30K connection speed) from the Microsoft betaplace website.

On The Road Again...Part I
Robert Pearl
An interesting interview with Raj Gill, SQL Server 2005 Roadshow Presenter by Robert Pearl. Get inside the mind of the co-founder of Scalability Experts and a highly experienced BI consultant.

Good News and Bad News--the July CTP
William (Bill) Vaughn's Blog
I'm working with the July CTP this week I've discovered the following:

AMO Lets You Dig Deeper into Your Data from Your Own Applications
Liu Tang and Paul Bradley
This article is based on a prerelease version of SQL Server 2005. All information contained herein is subject to change

Microsoft to Serve Up SQL Server 2005 Preview
Darryl K. Taft
Microsoft Corp. will use this week's Tech Ed conference in Orlando, Fla., to update product plans and show developers how it hopes to make data a first-class player in the company's development strategy, said sources close to the company

Yukon Classrooms Follow-up Questions Answered
Larry Chesnut
Over the last few weeks, I have been traveling across the country, delivering training for SQL Server 2005 in a Microsoft initiative called Yukon Ascend. My first stop was in Atlanta to talk for a week with HP folks about SQL Server 2005. It was really great to get to spend time with the makers of Super Dome. My next stop was in Seattle to talk to MS people at their Issaquah campus. Beautiful, simply beautiful. After two weeks of questions, there came up a few items I promised I would address after the class. Since I couldn’t make time for each class attendee individually, I promised I would answer their questions in this forum.

Make Sense of Your Web Feedback using SQL Server 2005
Peter Pyungchul Kim
The interactive nature of the Web has made it a great medium for data collection. As Web sites have evolved beyond click and buy, the solicitation of feedback has held the promise of greater insight into the customer and her needs, necessary product improvements, and future directions. But collecting reams of text-based data is not the same as gleaning useful information from it. In a typical customer feedback Web page, users enter comments about your product (see Figure 1). Some fields present preset answers users can choose from. Other fields let users type in any comments they like. This sort of free-form comment is especially difficult to put to good use because it must be divided into classifications if it is to be analyzed, quantified, and used for decision making

XML and Web Services Go Native in SQL Server 2005
Stephen Swoyer
When Microsoft Corp. first incorporated business intelligence (BI) capabilities into its SQL Server 7.0 database seven years ago, it kicked off a firestorm of sorts, with some purists arguing that such features had no place in a relational database management system

Microsoft SQL Server 2005
Michelle Dumler
This paper provides an overview of the new benefits and functionality available in SQL Server 2005

SQL Server 2005 April CTP + Important Announcements
adam machanic
In addition to releasing the April CTP of SQL Server 2005, Microsoft has made two important announcements this morning

SQL Server 2005 Express
Serdar Yegulalp
Along with the upcoming release of SQL Server 2005, Microsoft is introducing a new edition of SQL Server called SQL Server Express

Next CTP...
Kirk Haselden
The next CTP is close and I wanted to give you all a preview of some improvements that will be available there

OLTP Drag Races: SQL Server 2000 vs. SQL Server 2005
Rob Garrison
You're out cruising Main Street on a Saturday night in your slightly dated but still very nice 2000 model. At the light, up rumbles a shiny new 2005 model. It's got all the cool new features: CLR-integration, T-SQL enhancements, table partitioning. You call to the driver, "Nice car. What'll she do?"

Вышли новые бета-версии
Брайан Моран
MSSQLServer: Microsoft объявила о доступности Visual Studio 2005 Beta 2, .NET Framework 2.0 Beta 2 и SQL Server 2005 April Community Technology Preview (CTP). Также сообщается о новой программе лицензирования GoLive!, предусматривающей возможность развертывания приложений Visual Studio 2005 и SQL Server 2005 Express Edition в рабочей среде еще до выпуска указанных продуктов. Открыт общедоступный сайт Microsoft, где каждый может заявить о своем желании участвовать в программе Technical Adoption Program (TAP), в рамках которой клиентам предоставляется право включать в рабочую эксплуатацию предварительные варианты (CTP) версий SQL Server 2005 Standard и Enterprise Edition. Как говорится в адресованном сообществу SQL Server открытом письме старшего вице-президента Microsoft Пола Флес...

Kimberly Tripp Talks About SQL Server 2005 on DotNetRocks
Paul Ballard
In a recent episode of DotNetRocks, Carl and Richard talk to SQL Server expert Kimberly L. Tripp about the new features of SQL Server 2005 including how to use the CLR and XML features properly, new availability features, and changes to the T-SQL language

SQL Server 2005 Books Online
whidbey.msdn.microsoft.com
This documentation is provided for informational purposes only. Microsoft makes no warranties, either express or implied, in this document. See the link at the bottom of this page for the full copyright notice

Excellent presentation on SQL Express!
The SQL Doctor is In
From Kent Tegels blog: Enjoy Every Sandwich (not the one on blogspot, it is much different!,) a SQL blog that if you are not reading it you should! He just had a presentation he gave at one of the SQL Server Summit's put up on Microsoft's site. It is a very good presentation, and the only reason it isn't great is that there are a couple of slides that say: "Demo Goes Here" that make me want to see what the demo was like, and that makes me sad

Learning SQL Server 2005
Steve Jones
Everyone wants to get ahead of the curve with SQL Server 2005, but many people don't have the time or desire to dig through a Google search. Steve Jones has gotten quite a few requests for resources, so here is a compiled list of some places that might help you get started. I've gotten a few emails and posts lately on how someone should go about learning SQL Server 2005. At first I'd start to point people to whatever current sources exist, but then I thought that perhaps it's worth a few minutes to list some places and ideas about how to tackle things

Microsoft to license betas for production use
Martin LaMonica
The software colossus is going to offer licences that will permit customers to use the betas of SQL Server and Visual Studio for production

The April CTP is Here and No Beta 3
Steve Jones
SQL Server 2005 is on everyone's mind, especially with SQL Server 2000 almost 5 years old. On Monday, April 18, Microsoft made an announcement that the April CTP was available, but there would be no Beta 3. Read Steve Jones take on this announcement as well as a few more details

Want to hear the latest on SQL Server 2005 from the big cheese? Want to get a go-live-license for SQL Serever 2005 Express Edition?
Mat Stephen's WebLog
I want to share with you a letter from Paul Flessner that has been sent to 'Testers of SQL Server 2005'. Why? Because if this is news to you, you are not a tester and if you’re reading this you are most likely interested in what’s going on with SQL Server 2005 behind the scene visible to you

SQL Server 2005 Update from Paul Flessner
Paul Flessner
Many partners and customers are readying themselves for the next generation of Microsoft products which includes SQL Server 2005 and Visual Studio 2005. Building on the success of SQL Server 2000, SQL Server 2005 promises to be the biggest release of SQL Server. When I say biggest, I’m not only talking about functionality but also biggest in terms of breakthroughs in performance, scalability, and availability. This release will also deliver unprecedented integration between Visual Studio 2005, .NET Framework and SQL Server 2005 as well as tight integration with other Windows Server System servers to deliver new levels of manageability and TCO across your entire environment. We have worked diligently to bring this technology to you, and we are confident that it will allow you to make the most of your existing skills and technologies to increase productivity and efficiency

No SQL Server Beta 3 in sight!
The SQL Doctor is In
Now that you have been snookered into reading this, let me be more clear. For this product only (at the moment, they have the right to change their minds more than my daughter trying to find clothes to wear to church) they are dropping the Beta moniker from the upcoming releases and are only going to release CTP's from now on. One thing that I am really excited about is that we have been promised that it is essentially feature complete, though GUIs may change some (so don't start copy and pasting those screen shots just yet my friends!)

SQL Server 2005 April CTP + Important Announcements
adam machanic
In addition to releasing the April CTP of SQL Server 2005, Microsoft has made two important announcements this morning

Microsoft Delivers Latest Visual Studio 2005 and SQL Server 2005 Releases
Microsoft
Company encourages developers to Go-Live today, and highlights enterprise customers running mission-critical applications on the integrated development and data management platform

Various Downloads of Samples and Documentation for SQL Express
sqlexpress's WebLog
MSDN has a downloads page specific to express

Choosing a version of SQL Server 2005 Express (Updated for Visual Studio Beta 2)
tfosorciM.org
As many people who have used SQL Server 2005 Express in its various beta and Community Technology Preview versions will know, there have been many problems with installation, uninstallation and moving from one release to another. As I write this I am downloading Visual Studio 2005 Beta 2. I hope that April CTP of SQL Server 2005 and of SQL Server 2005 Express will be available very soon now

Microsoft лицензирует опытное ПО для промышленной эксплуатации
securitylab.ru
MSSQLServer: В понедельник Microsoft выпустила тестовые версии своих будущих инструментов разработки и базы данных, которые, как она утверждает, уже можно использовать в действующих бизнес-приложениях. Заказчики Microsoft, подписанные на Microsoft Development Network, получили доступ ко второй бета-версии Visual Studio 2005 и апрельской версии community technology preview СУБД SQL Server 2005. Оба продукта должны быть закончены во втором полугодии и поступят в продажу одновременно...

New SQL Server 2005 Resources Available
Paul Ballard
Microsoft has released a number of new SQL Server 2005 resources including several presentations and a new hands-on virtual lab. Topics cover SQL Server 2005 internals, Service Broker, security, and Integration Services for developers

Разбираем "айсберг" SQL Server 2005
Брайан Моран
MSSQLServer: На пути к освоению новых возможностей и постижению многообразия вариантов архитектуры SQL Server 2005 вспомним мудрые слова "путь длиной в тысячи миль начинается с первого шага". Хотя понятно, что читатели, скорее всего, не располагают временем для изучения продукта, который еще как минимум полгода не будет запущен в рабочий процесс...

SQL Server 2005: анализ возможностей
Брайан Моран
MSSQLServer: Выпуск SQL Server 2005 уже на протяжении стольких лет кажется таким близким и одновременно далеким, что с трудом верится в скорый выход пакета. Читатели, в чьи планы не входит немедленный переход на SQL Server 2005, могут сохранять спокойствие. Понятно, что большая часть сообщества пользователей SQL Server еще не один год будет хранить верность версии SQL Server 2000. Однако, поскольку SQL Server 2005 - первое значительное обновление за очень долгое время, информация о технологии заинтересует многих. Тему SQL Server 2005 мы будем регулярно обсуждать на протяжении предстоящих месяцев. Сегодня я обращаю ваше внимание на статью Microsoft под названием "Expanding the SQL Server Product Line", размещенную по адресу http://lists.sqlmag.com/t?ctl=6904:7F5AD. В ней дается общее...

So many ways to get your hands on SQL Server 2005
Kimberly L. Tripp
For the past couple of years, the early betas of SQL Server 2005 were very limited and even the events were somewhat limited - limited primarily to large customers under NDA, MVPs, RDs, and very dedicated SQL Server specialists. So far, only the SQL Express 2005 Edition made it on microsoft.com for download (click here if you're interested in SQL Express and the SQL Express Manager downloads)...

Microsoft объявила о расширении продуктовой линейки готовящегося к выходу SQL Server 2005
пресс-релиз Microsoft
MSSQLServer: Корпорация Microsoft сообщила подробности о новой продуктовой линейке для Microsoft SQL Server 2005 - новой версии своего основного продукта СУБД масштаба предприятия, рассказав о новых функциональных возможностях и ценовой политике для расширенной продуктовой линейки SQL Server 2005. Семейство продуктов SQL Server 2005 было переработано с тем, чтобы более полно удовлетворять потребности заказчиков из всех сегментов. Являясь широко распространенной базой данных, продукт предоставляет исключительные преимущества и функциональность, по сравнению с конкурирующими решениями. В четырех новых версиях продукта будут представлены различные возможности: от максимальной доступности и высокой масштабируемости до улучшенных инструментов бизнес-анализа. Таким образом, пользователи в...

SQL 2005, мартовский CTP: They did it! Теперь все срочно переписывать...
Ivan's Blog
MSSQLServer: Сам пока не проверял, но по достоверным слухам в следующей версии сиквел-сервера, вот такая незатейливая команда: select * from sysobjects o, syscolumns c where o.id *= c.id Приведет к одному из самых длинных сообщений об ошибке...

New Program Readies Industry for SQL Server 2005
Microsoft
Roundtable Q&A: The Ascend Program provides Microsoft industry partners and customers with deep technical training, tools and hands-on labs to accelerate the process of migrating to next-generation technology

SQL Server 2005 Virtual Labs Now Online
John Bristowe
Microsoft has announced the public availability of the SQL Server 2005 Virtual Hands-On Labs. These labs let participants experience many of the new features in SQL Server 2005 including CLR integration, XML support, and deep business intelligence integration

SQL Server 2005: Figuring Out the Features
Brian Moran
The release of SQL Server 2005 has seemed so close but yet so far away for so many years that it's easy to lose sight of the fact that SQL Server 2005 is finally (I hope ) just around the corner. If you're not planning to move to SQL Server 2005 right away, don't worry--we realize that a large percentage of the SQL Server community will be on SQL Server 2000 for years to come. But because SQL Server 2005 is the first major upgrade in years, many readers are ready and eager for information about it. I'll begin to share SQL Server 2005 topics more regularly over the next few months. This week, I want to point you to the Microsoft article "Expanding the SQL Server Product Line" at http://lists.sqlmag.com/t?ctl=6904:7B3DB . This article provides a high-level overview of planned features for different SQL Server editions: SQL Server Express, SQL Server Workgroup Edition, SQL Server Standard Edition, and SQL Server Enterprise Edition. The feature list in the article isn't particularly detailed, perhaps because decisions for all the feature-edition mixes haven't been finalized. However, I've learned about a few interesting features

Microsoft SQL Server Express 2005 (MSDE)
Don Schlichting
SQL Express 2005 is a new, FREE, Microsoft SQL Server lightweight edition. This new edition is the upgrade to Microsoft's SQL Server 2000 Desktop Edition (MSDE). Targeted to developers of "simple" applications, it includes a fully functional SQL Server database engine and a Query Analyzer type management tool. And best of all, it is FREE to use and redistribute

WinFS
The Unfrozen Caveman Engineer
Well, June is here so it must be time to make a post. Let's talk about... Hmmm... What should we talk about? Hmmm.... How about WinFS!

SQL Server 2005 - What will it not support?
Mike Epprecht's Blog
I've been busy sticking my head deep into SQL Server 2005. What is missing?

Intro to Microsoft SQL 2005 native web service support
JIMWU's WebLog
I'm finally back, well more like I finally found some time to blog. As promised, I will add a little introduction to how Microsoft SQL 2005 native web service support works

Learn SQL Server 2005 In Reading
Press Release
If you're a T-SQL programmer / DBA working with T-SQL for some time now, learning from the seat of your pants, and want to upgrade your skills, this full-day seminar is for you

Microsoft Clarifies SQL Server Ship Date
Lisa Vaas
The ship date for Microsoft's massive database overhaul hasn't slipped again, per se; rather, Microsoft has redefined what "summer" means, according to Tom Rizzo, director of SQL Server product management

Sleepycat CEO talks Microsoft open source tactics
Mark Brunelli
Mike Olson, the outspoken CEO of Berkeley DB provider Sleepycat Software Inc., believes that the successful open source players of tomorrow will incorporate at least some aspects of proprietary computing into their business model. In this conversation, Olson discusses why he thinks ever-evolving attitudes toward open source will make these hybrid offerings lucrative. He then runs through an interesting "thought experimentation" to show what would happen if Microsoft ever decided to embrace open source

Microsoft Acquires DB Best
Microsoft
Microsoft has acquired DB Best, one of the leading providers of database migration tools. The DB Best family of database migration tools will become a part of SQL Server Migration Assistant—a set of tools to help customers automate the migration of their applications from other databases to SQL Server. DB Best technology will be one of the cornerstones of the SQL Server migration strategy, and a phenomenal asset for customers who want to gain the benefits of moving to SQL Server

SQL Server Kicks Oracle's Butt
Buck Woody
Oracle enthusiasts love to bash SQL Server, and Buck Woody thinks it's high time that the debate is taken to a professional form. If it's to be an argument, he wants to involve the discipline of logic to see which is better: SQL Server or Oracle. Care to see who wins?

Oracle versus SQL Server in the Enterprise
David Hull
Can Oracle kick SQL Server's behind? Oracle expert David Hull throws down the gauntlet to Microsoft devotees

Не откладывайте изучение SQL Server 2005
Брайан Моран
MSSQLServer: Новый набор инструментальных средств SQL Server 2005 радикально отличается от предыдущих версий. В публикациях, посвященных базам данных, много говорится о том влиянии, которое окажет на эту сферу деятельности ввод среды исполнения Common Language Runtime (CLR). Однако нужно иметь в виду, что инструментарий SQL Server 2005 нисколько не похож на тот, которым вы пользуетесь сегодня. Новые инструментальные средства хороши, однако требуется время, чтобы к ним привыкнуть. Например, разработчик будет чувствовать себя гораздо комфортнее, работая с Management Studio, чем с DBA, благодаря сходству с Visual Studio по общему впечатлению и ощущениям. Таким образом, овладение новым средством все же не следует откладывать до самого момента запуска технологии SQL Server 2005 в работу...-RIGHT: 5.4poI

Commentary on the March 14th Forrester Report
Kevin Kline
Lisa Vaas of eWeek recently reported on a Forrester Report, writing by Noel Yuhanna (http://www.eweek.com/article2/0,1759,1776014,00.asp), that describes a number of customers who are not at ease with the current condition of the Yukon beta. Yuhanna describes two key concerns – performance benchmarking and high-end scalability benefits – which are the heart of the article which I would like to comment on

Visual Studio 2005 Ship Date Slips Again
Darryl K. Taft
Microsoft Corp. Monday announced that the much-anticipated next version of its developer tools suite will ship in the second half of 2005 in several versions, with the Microsoft Developer Network as its primary delivery mechanism

Visual Studio 2005 Pricing and Delays
Paul Ballard
Microsoft has released the pricing for the various editions of Visual Studio 2005 including pricing for those with MSDN subscriptions. This news comes on the heels of other announcements that Visual Studio 2005 (and therefore SQL Server 2005) will be further delayed to the end of the year

Visual Studio and SQL Server delayed again
Martin LaMonica
Microsoft has pushed back the release dates of both software packages to the second half of 2005

Microsoft опять задерживает Visual Studio 2005 и SQL Server 2005
Поль Тюрро
MSSQLServer: Вчера Microsoft объявила о ценовой и лицензионной стратегии для Visual Studio 2005, в то время как собственно выход новой генерации программной платформы для разработчиков - в том числе сервера Microsoft SQL Server 2005 - откладывается до второй половины 2005 года. Ранее планировалось, что оба продукта появятся в середине 2005 года. Как заявляют в Microsoft, Visual Studio 2005 и SQL Server 2005 будут выпущены одновременно...

When to use SQL Server 2005 inbuilt Web Services?
Microsoft
Alan Xu Asked: can the sql 2005 add pdf file as a data field like picture?

Report Casts Doubt on SQL Server 2005 Scalability
Lisa Vaas
SQL Server 2005 will likely be a dud at delivering high-performance computing, according to a new report from Forrester Research Inc

An Interview with Idera CEO, Rick Pleczko
Steve Jones
Rick Pleczko, CEO of Idera, took time out of his busy schedule to spend a few minutes answering some questions from me about his company, SQL Server 2005 and more. If you're in a large SQL Server environment, then you might want to take a look at some of the Idera tools and products

SQL Server 2005: версии, лицензии и стоимость
Брайан Моран
MSSQLServer: На прошлой неделе представители Microsoft объявили о новой версии SQL Server Workgroup Edition и назвали предположительные цены на продукты SQL Server 2005. Изменение цен не касается SQL Server 2000, хотя новая версия SQL Server 2000 Workgroup Edition выйдет в первой половине текущего года. Четырем версиям SQL Server 2005 дано следующее описание...

Project REAL: SSIS in the real world
Jamie Thomson's Blog
Project REAL is a Microsoft led initiative to build an end-to-end demonstrable BI solution on SQL Server 2005 BI tools (i.e. SSIS, SSAS, SSRS). A paper has been released documenting the experiences gained whilst building the ETL portion of this project using SSIS

Inside SQL Server 2005
Tom Rizzo
Tom Rizzo, the director of product management for Microsoft SQL Server, talks about Reporting Services, SQL Server 2005, and more. Note: This is a transcript of an interview conducted at VSLive! San Francisco

Дебаты вокруг открытых баз данных
Брайан Моран
MSSQLServer: Есть ли смысл использовать открытые базы данных? Выражаясь точнее, разумно ли выбирать базу данных с открытым исходным кодом вместо SQL Server, если основной проблемой является стоимость приобретения технологии? По этому вопросу хочется поделиться некоторыми соображениями. Такое желание возникло у меня после прочтения ряда статей, посвященных открытым базам данных, таким как MySQL или Ingres, с описанием их преимуществ по сравнению с технологиями, за которые приходится платить...

SQL Server: цены растут, но есть версия для рабочих групп
Поль Тюрро
MSSQLServer: Неоднократно переносившийся срок начала поставок семейства продуктов Microsoft SQL Server 2005 наконец-то определен окончательно: середина 2005 года. Объявив об этом, представитель Microsoft отметил, что будет предложено новое семейство продуктов и по более высоким ценам. Для начала Microsoft добавила сервер баз данных для рабочих групп - SQL Server Workgroup Edition. Но этот продукт не будет дожидаться появления SQL Server 2005, вместо этого компания запускает SQL Server 2000 Workgroup Edition уже этой весной, раньше SQL Server 2005...
Codename for release after SQL Server 2005
YukonXML.com
By now everybody knows that SQL Server 2005 release was codenamed "Yukon". Do you know what's the codename for release after Yukon?
Microsoft Releases Third Community Preview of SQL Server 2005
Lisa Vaas
Microsoft Corp. on Thursday released the third SQL Server 2005 Community Technology Preview, an incremental release that is most notable for its advanced reporting functionality
Is Microsoft Double-Dipping on SQL Server Licensing?
Lisa Vaas
Opinion: Those who have peeled back the covers on Microsoft's recently released pricing and packaging details have found some nasty surprises, particularly with Client Access Licenses. When you take a look at Microsoft's newly unveiled pricing and packaging details for SQL Server 2005, it seems at first blush that Microsoft is seriously courting low-end users, what with the introduction of a stripped-down, lower-cost but still enterprise-level version of SQL Server—its new Workgroup edition
SQL Server 2005 Gets BI Infusion
Stephen Swoyer
Microsoft rebrands ETL facility, beefs up Analysis Services, and hints at plans for ActiveViews end-user query and authoring technology
SQL Server 2005 Gets One Step Closer to Reality
Stephen Swoyer
Users are already buzzing about the next version of SQL Server
SQL Server 2005 Offers Risks, Rewards for BI Vendors
Stephen Swoyer
As Microsoft preps its most ambitious business intelligence offering to date—SQL Server 2005—the good relations it enjoys with some long-time BI partners could be at risk
Is SQL Server 2005 Worth the Cost?
Stephen Swoyer
Is SQL Server 2005—even with significantly improved OLAP, ETL, and reporting features—worth the cost?
Is Microsoft Double-Dipping on SQL Server Licensing?
Lisa Vaas
Those who have peeled back the covers on Microsoft's recently released pricing and packaging details have found some nasty surprises, particularly with Client Access Licenses When you take a look at Microsoft's newly unveiled pricing and packaging details for SQL Server 2005, it seems at first blush that Microsoft is seriously courting low-end users, what with the introduction of a stripped-down, lower-cost but still enterprise-level version of SQL Server—its new Workgroup edition
Microsoft may offer peek at SQL Server code
Martin LaMonica
Will the software industry's wave of open-source databases spill onto Microsoft's turf?

Microsoft Announces Expanded SQL Server 2005 Product Line to Meet Customers' Growing Demands
REDMOND, Wash. -- Feb. 24, 2005
Microsoft Outlines Enhanced Product Line and Pricing for SQL Server 2005; Dell to Offer SQL Server Workgroup and Standard Editions

SQL Server 2005 Features Comparison
Microsoft
Microsoft has redesigned the SQL Server 2005 product family to better meet the needs of each customer segment with four new editions: Express, Workgroup, Standard, and Enterprise. As a low-cost mainstream database, SQL Server 2005 will deliver unprecedented value and functionality compared with competitive solutions. The four new editions will offer a range of features, from high availability and robust scalability to advanced business intelligence tools, designed to empower users across an organization through a more secure, reliable, and productive data management platform. Additionally, with the reduced application downtime, robust scalability and performance, and tight security controls, SQL Server 2005 represents a dramatic step forward in supporting the most demanding enterprise systems in the world. Because SQL Server is part of Windows Server System, customers also receive the added benefits of reduced total cost of ownership and faster development time through the increased manageability and integration that result from the common engineering strategy implemented across Windows Server System products. The table below presents details about each of the different editions

SQL Server Heads to the Workgroup, Gets a Price Increase
Paul Thurrott
Microsoft's oft-delayed SQL Server 2005 family of products will finally ship mid-year, the company said this week, but it will bring with it a new product lineup and higher prices. For starters, Microsoft is adding a Workgroup Edition of SQL Server. But that product won't wait for SQL Server 2005. Instead, Microsoft is launching SQL Server 2000 Workgroup Edition this spring, ahead of the SQL Server 2005 launch

The Debate About Open-Source Databases
Brian Moran
Does it make sense to consider using an open-source database? More to the point, does it make sense to choose an open-source database instead of SQL Server when cost is your primary concern? Interesting questions—I want to share some insights. I touched on this topic in my previous commentaries "In the Express Lane with SQL Server" and "MSDE: Get More than You Pay For". I want to revisit the topic because I've been reading some articles in the mainstream press about open-source databases such as MySQL or Ingres and how they compare favorably to database solutions that you have to pay for

SQL Server 2005: Pricing and Open Source
Paul Ballard
Microsoft has released the pricing model for SQL Server 2005 for all editions including the MSDE replacement Express edition. Also in the news is a statement by Tom Rizzo, Product Manager for SQL Server 2005 that Microsoft is considering, based on customer demand, open sourcing SQL Server 2005

SQL Server 2005 Editions and Integration Services
Darren Green
The SQL Server 2005 product family has now been announced, so with four editions available, what does this mean for SQL Server Integration Services? Starting from the bottom the free edition known as Express and the entry level Workgroup edition, neither include the full IS product. They have the Import/Export capabilities, but nothing more, so simple loading and extraction of data this should suffice, but you will not be able to build packages

Microsoft Adds Workgroup Option For Present, Future SQL Servers
By Barbara Darrow
Shifts some high-end functions from enterprise to standard edition of Yukon Microsoft is sticking to its story that SQL Server 2005 will ship this summer, but in the meantime the company will release a new version of SQL Server 2000

Comparison of SQL Server 2005 Editions
Brian Knight
Microsoft this week announced a new product line for its flagship database and a new pricing structure for its users. For Enterprise Edition customers, the price increase equated to approximately 20% for those who license per processor. Standard Edition customers will see about a 15% price increase once they migrate to SQL Server 2005. This price increase marks the first price increase in more than 5 years

Microsoft Pitches New Low-Cost, Entry-Level Database Edition
Lisa Vaas
Facing ever-stiffer competition in the database price wars, Microsoft Corp. is introducing an edition of its upcoming SQL Server 2005 upgrade that will provide an easier step between free and not free than it now does with SQL Server 2000

Where Is Microsoft's 'Yukon' Beta 3?
Mary Jo Foley
Redmond is rolling out packaging and pricing for its SQL Server 2005 database. But still no Beta 3

SQL Server 2005. Microsoft Brings Software Know-How To HIV Research
John Foley
Microsoft on Wednesday outlined its latest efforts in applying data-mining algorithms, machine-learning techniques, and computer modeling to the search for more effective HIV vaccines. Some of the technology being used will be included with Microsoft's forthcoming SQL Server 2005 database

Microsoft contemplating 'sharing' source of SQL Server 2005
Martin LaMonica
SQL Server 2005 is a candidate for Microsoft's shared-source programme, according to senior Microsoft sources within the unit responsible for the database product

Microsoft Preps Maestro For Yukon
Barbara Darrow
This week's note is brought to you courtesy of CRN's Barbara Darrow, who graciously shares her insight on some interesting database news

PredictNodeID - The reason behind the prediction
DMTeam
Use the PredictNodeID DMX function to gain insight into the rule(s) applied by your favorite algorithm to churn out that nifty recommendation

Integrating InfoPath with SQL Server 2005
Write Ahead Blog
I discovered InfoPath only a few months ago and started wondering how it could be used in enterprise offices. InfoPath does a great job of building forms for publishing XML data quickly. It not only makes the task of building CRUD (create/retrieve/update/delete) applications for Web-services really easy but with the introduction of the .NET extensions for InfoPath, it is possible to build really diverse InfoPath application. So how do you build desktop productivity applications in InfoPath that offer asychronous execution and reliability that traditional web-services over HTTP do not offer?

Otey on Stinger Vs. Yukon and the Art of War
Enjoy Every Sandwich
Sun Tzu writes in The Art of War: "A defeated army first seeks to do battle, then obtains conditions for victory." It's amazing how true this really is. Adam points us at an op-ed piece that Michael Otey has written comparing DB/2 "Stinger" to SQL Server 2005 with respect to CLR integration. While I don't know that I'd blame the apparent brain damage shown by these poster(s) on Java, it really does seem like they have an agenda themselves, rushed into battle then tried create conditions where they might be seen as being "right." Here's what I posted back as comments

SQL Server 2005: Two Little Known Features That Matter Big!
Ravindra Okade
SQL Server 2005 brings a host of new features to the table. Ravindra Okade details a couple of nuggets that are not easy to find but can be very useful to every developer and DBA. Synonyms are very handy for managing database objects. And non-clustered index included columns, although a mouthful, is a unique feature that can drastically optimize queries

What's new in SQL Server 2005
Sara Cushman
Though plenty of people have already caught a glimpse of SQL Server 2005, and some companies are even using Beta 2 in production environments, most enterprises won't be seeing the latest release of Microsoft's DBMS until it ships early next year. But attendees at last week's 2004 PASS Community Summit in Orlando were eager to learn about what's ahead

Microsoft продолжает тестировать Yukon
Martin LaMonica
MSSQLServer: В пятницу компания выложила вторую версию community technology preview СУБД SQL Server 2005. Выпуск третьей тестовой версии, которая будет доступна более широкому кругу заказчиков, запланирован на начало будущего года. Финальная версия СУБД должна появиться летом...

What You Need to Know About Microsoft SQL Server 2005 Beta 3
Paul Thurrott
Although it might seem that SQL Server 2005, code-named Yukon, has been in perpetual beta, the recent release of SQL Server 2005 Beta 3 brought some surprises in the form of several interesting new features. These features, which include new Data Transformation Services (DTS) functionality, new data-mining functionality, and the recently acquired ActiveViews reporting services technology, round out the product nicely. Here's what you need to know about SQL Server 2005 Beta 3

SQL Server 2005 Express Tips
Kevin Kline
By now, you’ve probably heard something about Microsoft’s new SQL Express. SQL Express is the replacement for Microsoft's MSDE database. It’s a free, light-weight database version of SQL Server. It is SQL Server, but it’s stripped down to make it a smaller download. It’s less filling and tastes great too!

More SQL Server 2005 Bits
Brian Moran
Last week, Microsoft released the second SQL Server 2005 Community Technical Preview (CTP). I wrote about the CTP program a few weeks ago (see "Technology Previews Deliver Pre-Beta 3 Peeks at SQL Server 2005" at http://www.windowsitpro.com/article/articleid/44291/44291.html ). Microsoft will release SQL Server 2005 CTP builds more frequently than it does for typical beta cycles, primarily to speed up the feedback cycle so that the company can incorporate as much user input as possible into SQL Server 2005's final release. SQL Server 2005 CTP 2 is now available to all Microsoft Developer Network (MSDN) subscribers. Non-MSDN subscribers can't directly download or acquire the CTP builds, but your local Microsoft field office will probably be open to distributing the bits to customers who are interested in exploring SQL Server 2005—just use your usual channels for communicating with your local Microsoft sales representatives

Microsoft продолжает тестировать Yukon
ZDNet.ru
MSSQLServer: Microsoft выпустила еще одну опытную версию своей будущей СУБД SQL Server 2005 и предложила бесплатный инструмент управления...
SQL Server 2005: What's New?
David Fells
Microsoft SQL Server has shown a lot of growth in its last two releases. With SQL Server 2005, Microsoft continues to aim the tool at enterprise application developers. David Fells examines its most useful new features--and complains about a number of things that Microsoft perhaps shouldn't have done with the program

Microsoft Issues 2nd SQL Server 2005 Public Beta
Paul Thurrott
On Friday, Microsoft issued its second Community Technology Preview (CTP) release of SQL Server 2005, while providing public testers with a new beta release as well, SQL Server 2005 Express Manager, a new, free database management tool. The SQL Server 2005 CTP is available to all MSDN and Microsoft Betaplace subscribers, the company says

MS Rolls Out Second Interim Beta of SQL Server 2005
Lisa Vaas
Microsoft Corp. on Friday released its second Community Technology Preview of SQL Server 2005 and rolled out a new, free tool to manage SQL Server 2000 and MSDE (Microsoft Desktop Engine) 2000

Finding Gold in Yukon
Don Jones
Not your father's SQL Server, administrators will find comfort in Yukon, while developers are left out in the cold.

WinFS: It's Back!
Doug Barney
Too many versions of Windows adds to the burden of support. The unified file system component of Longhorn may have been unceremoniously dumped from the initial shipment coming in 2006, but it will appear sometime later, according to Microsoft prez Steve Ballmer. This is great news for those who have guzzled the Longhorn Kool Aid, but I have to wonder what it means for IT. After all, a file system is't like a new skin for Media Player that you just slap on and start using. I's a bit more fundamental

Cut From Longhorn, WinFS Is in Peril
Scott Bekker
Does Windows Future Storage really have a future? The Windows Future Storage (WinFS) technology that got cut out of Windows "Longhorn" is in serious trouble, and not just the hot water a feature might encounter for missing its intended production vehicle

SQL Questions & Answers: SQL Server Express, Encrypting Data, and More
Nancy Michell
Database Sizer Tools

SQL Server 2005 Part 1 Introduction
Marcin Policht
SQL Server 2000 will be soon reaching its five-year mark, which in terms of software life-cycle translates into fairly advanced maturity. While this is still far from retirement age, the name of its successor, SQL Server 2005, suggests that it might be time for you to start looking into what the new generation has to offer. The release of SQL Server 2005, originally introduced as Yukon, has already been postponed, but its current Beta 2 implementation (with several incremental Community Technical Previews expected before Beta 3 becomes available early next year) brings promise of a timely RTM stage (planned for summer next year). In this series of articles, we will look into functional highlights of the new incarnation of the Microsoft database management system, focusing on those that are likely to remain unchanged in the final product
Get a Lean, Mean Dev Machine with the Express Editions of Visual Basic and SQL Server 2005
Brian A. Randell
I only vaguely remember the first time I attempted to write a Windows®-based application. I was using C and writing for the 286. Actually I've tried to block the whole experience from my mind. Considering that I started programming on an HP 3000 mini using COBOL and RPG, programming with Windows was painful by comparison
Новые возможности MS SQL Server 2004 "Yukon"
Иван Бодягин
Описать более-менее подробно все возможности новой версии Microsoft SQL Server задача не тривиальная, поэтому в данной статье предложен лишь небольшой обзор некоторых нововведений. А именно представления метаданных, схем, немного о безопасности, новые возможности при работе с индексами и новые встроенные типы данных. Я не ставил перед собой цели раскопать все в подробностях, поскольку на данный момент доступна лишь первая предварительная версия сервера и многое может измениться, но основная функциональность, очевидно, останется, поэтому ее и имеет смысл рассмотреть...
SQL Server 2005 Express Edition Overview
Rajesh George
SQL Server Express, a free product based on SQL Server 2005 technology, includes the unique Application XCopy feature, and networking and security that differ from other SQL Server 2005 editions. These topics and the integration of SQL Server Express with Visual Studio 2005 are discussed. Compare this product with the existing Microsoft free databases like MSDE and Jet. (20 printed pages)
Data Validation Using .NET and External Metadata
Jonathan Schafer
Data validation is a task that we perform every day when writing code. Applying the techniques described here can make your systems more robust and eliminate the constant rebuilding of applications every time a business rule changes. Using .NET reflection and external metadata makes it easy to add data validation to your objects. Nearly every application that collects data, whether from a Windows- or Web-based form or from a file, needs to validate that the data is in the correct format
WebService - Enabling SQL Server 2005 Procedures
Peter A. Bromberg
SQL Server 2005 is emerging from its final BETA cycle to become a full-fledged product offering very soon. The SQL Server BETA 2 offering, available from MSDN Subscriber Downloads, is both full - featured and fully functional at this point. Only a few items remain, mostly revolving around tuning and final optimization, and some user tweaks and minor bug fixes
Microsoft addresses multicore processor licensing
Martin LaMonica
Taking a stand on what has become a contentious issue, Microsoft on Tuesday said it will count new multicore processors as single units when they debut next year
Support Tools Available For Stress Testing & Performance Analysis
Read80Trace is a command line utility for processing trace files generated by SQL Server 2000. As output, it generates RML files and/or a database populated with normalized data that can be useful for analyzing the performance of the system. Read80Trace requires that the destination database also run SQL Server 2000 or later
Microsoft Previewing SQL Server
Clint Boulton
Trolling for as much feedback as possible as it moves toward its next major database release for 2005, Microsoft (Quote, Chart) Friday kicked off a Community Technical Preview (CTP) of SQL Server 2005

"Dog Fooding" Lessons: Microsoft Internal IT Group Deploys Beta 2 of Microsoft SQL Server 2005
Mike Hatch
Q&A: A senior internal technology architect shares insight Microsoft has gained from deploying and testing the latest beta release of Microsoft SQL Server 2005 as part of the company’s SAP R/3 enterprise resource planning system

Microsoft Seeks to 'TAP' Elite Beta Tester Pool
Mary Jo Foley
Redmond quietly is implementing its new Technology Adoption Program across its product lines. On Thursday, Microsoft Corp. notified some of its SQL Server 2005 testers that they are eligible to join the next phase of the "Yukon" beta program. As noted in a beta tester e-mail note posted on the ieXbeta Web site, Microsoft is seeking customers to join its Technology Adoption Program (TAP) beta program for its next-generation database

SQL Server 2005 Bug Reporting
Help improve SQL Server 2005
We spend lots of time designing and testing our products to make sure that they fit your needs. However, there is no substitute for feedback directly from you. Please help us make SQL Server 2005 the product that you want by submitting bugs and feature requests to our team

Waiting for Yukon
Michael Otey
Competition in the database arena has never been fiercer. Remember the year 2000? Clinton was in the White House, the tech economy was booming, and Microsoft had just released SQL Server 2000. The new SQL Server release quickly broke through the wall from department-level to enterprise-level database. It hit the top clustered Transaction Processing Performance Council (TPC) TPC-C scores so convincingly that the TPC split the benchmark into clustered and nonclustered categories. Since then, however, SQL Server's main enterprise competitors have launched new releases. Now, 4 years after its impressive debut, SQL Server 2000 is invisible in the clustered TPC-C scores, which feature Oracle's new 10g database on top. And SQL Server sits in third place in the nonclustered category, with IBM's DB2 holding the best nonclustered score

Get Ready for SQL Server 2005
Roger Jennings
Belated Beta 2 shows what's in store for data architects, project managers, and DBAs. SQL Server 2005—the database formerly known as Yukon—is in the throes of what promises to be a five-year-plus gestation. Projected beta release dates have come and gone since its first demonstration in 2001, and some features have been cut. Microsoft released Beta 2 this July for download by MSDN Enterprise, Universal, and Professional subscribers (see Additional Resources). Microsoft's Tom Rizzo, director of SQL Server product management, says Beta 2 is "close to feature-complete," with later betas to deliver enhancements to SQL Server Reporting Services and the management tools. The actual product is due to ship in 2005, as its new name promises, with the additional promise that it will be fast, bulletproof, and secure

Beta testers review Yukon's finer points
Robert Westervelt
Improved business intelligence tools, enhanced memory management components and the ability to easily debug scripts has Don Watters, a senior database administrator with the Walt Disney Internet Group, feeling good about the newest version of SQL Server 2005 database management system (DBMS).

Microsoft's Platform Strategies for 2004–2005
Peter O'Kelly
The 2005 versions of Visual Studio and SQL Server pave the road to Longhorn. This is the third Trends & Analysis column in a series focused on the past, present, and future of Microsoft's platform strategies. The first column, "Understanding Microsoft's Platform Strategies," established a framework for evaluating Microsoft's product line in terms of platforms, tools, applications, and services. The second, "Microsoft's Platform Strategies Today," described how .NET has matured during the last two years. This one focuses on .NET Framework 2.0, Visual Studio 2005, and SQL Server 2005, three of the most important development projects Microsoft has ever undertaken

SQL Server 2005 Express Edition Beta 2, Free
Microsoft
It was an open secret that Visual Studio 2005 Beta 1 ("Whidbey") and SQL Server 2005 Beta 2 ("Yukon") were set to debut this summer. What most of us didn't know was that Microsoft would release a new line of "Express" versions for testing at the same time. In particular, the release of SQL Server 2005 Express, the successor to MSDE, came as a complete surprise to most observers. As a free database server, it's shaping up to be pretty darned impressive

Waiting for Yukon
Tim DiChiara
Picture a barren landscape. Two forlorn and confused SQL Server DBAs wait. And wait. And wait. They try to pass the time. And wait. For something that doesn't come

Microsoft Announces SQL Server 2005 Support For AMD Extended System
Customers and Partners Invited to Start Testing Expanded 64-Bit Functionality With SQL Server 2005 Beta 2 Today
SQL Server 2005 Beta 2 Is Out!!!
Steve Jones
Microsoft quietly announced the release of SQL Server 2005 (Yukon) Beta 2 today in a presspass article on their site. All MSDN customers also were notified that the MSDN download would be available later today. Good luck getting bandwidth from MSDN downloads tonight and tomorrow! I'm sure lots of ISVs as well as us regular geeks are hitting it hard

DBAs take on new role in the enterprise
Robert Westervelt
Arup Nanda, a skilled Oracle DBA consultant, is among those database professionals whose work assignments have changed drastically in recent years

TechEd 2004 Europe coverage : SQL Server 2005 Mobile Edition alias SQL Mobile alias SQL Server CE 3.0 alias Laguna
Kevin Collins
What is SQL Mobile? It is a successor to SQL CE database. But it is not just linear extension, but a whole revolution in mobile databases! Here are some highlights of the features of SQL Mobile that we learned from Kevin's session

Understanding Microsoft's Platform Strategies
Peter O'Kelly
Making sense of Whidbey/Yukon and Longhorn in a .NET Framework world. The product and strategy floodgates at Microsoft are currently wide open, with a deluge of releases late last year and the unveiling of detailed strategies for the next two waves of platforms and tools at its October Professional Developers Conference (PDC). It's important for enterprise IT planners to assess these product waves not only in the broader context of overall application platform evolution but also relative to Microsoft's .NET strategy, as these waves are much more significant than traditional product updates

SQL Server Express
Steve Jones
As most people know, Microsoft is moving forward with the next evolution of SQL Server, AKA Yukon, AKA SQL Server 2005. The product is being developed and coincides with the Visual Studio 2005. However the next Beta, Beta 2, which TechEd 2004 attendees were allowed to sign up for, will not be a large public release (according to ENT News. Instead it should be here any day for a larger audience than Beta 1, but still a limited group, only about 100,000 users. Beta 3 is expected to be available for the general public

Case Study: Realtime Trader Seeks 64-Bit Realtime Database
Jacqueline Emigh
Learn how one company is using the next version of SQL Server. Rebecca Lewis of Townsend Analytics is a pivotal behind-the-scenes figure in an environment of fast-paced online trading. The IT systems director seeks a database that can keep completely up to speed. Lewis hopes that the 64-bit edition of SQL Server 2005, formerly codenamed Yukon, will prove itself able to do this job. So far, however, SQL 2005 isn't available for beta testing in 64-bit mode

Золотодобыча на YUKON
Майкл Оти
Появлению новой версии Microsoft SQL Server под названием Yukon, которая увидит свет в конце 2004 — начале 2005 г., предшествовал пятилетний цикл разработки. В продукте реализовано столько новых возможностей, что описать их в рамках одной статьи не представляется возможным. В этой версии SQL Server можно обнаружить 13 ценных находок

Yukon: What's Really Important
Brian Connolly
Data warehousing enhancements and analysis improvements round out a complete BI offering. SQL Server 2005, code-named Yukon, promises some fundamental enhancements to Microsoft's core database technology, and it is a central focus of Tech•Ed's Data Management track. The enhancement that has received the most attention is integration with the Common Language Runtime (CLR). This will give developers the ability to develop stored procedures and callable functions in languages such as VB and .NET

Microsoft To Step Up Server Product Release Schedule
Mary Jo Foley
Microsoft seems to be moving to upgrade more frequently the other members of its Windows Server System

Top 30 Features of SQL Server "Yukon"
Discover how the next version of SQL Server, code-named "Yukon," will benefit you with the new and enhanced abilities and features described on this page
Yukon Delayed Again and Named
Brian Knight
As you may've already suspected, Microsoft confirmed today that the next release of SQL Server, code named "Yukon", has been delayed yet again into 2005. The previous announcement had Yukon being released the later part of 2004. With Beta 2 still be needing to be released before then, the math didn't quite add up though for a 2004 GA release. Also announced today was that Yukon will officially be called SQL Server 2005 upon its release. The next release of Visual Studio, code named Whidbey, will also have the 2005 branding with Visual Studio 2005

What's New and Cool in SQL Server "Yukon"
Peter W. DeBetta
Sure, SQL Server has lots of features that make it easy to manage and administer. Sure, it's a world-class relational database management system. Sure, Transact-SQL (T-SQL) is an easy-to-learn language. Yet despite these and other facts, many developers only have a cursory knowledge of programming in SQL Server. I am here to announce that all that will change with SQL Server "Yukon".

Next Generation SQL Server - Yukon
I know that this is one topic that has raised interest in minds of many database designers. The next generation of SQL Server is full of promises. With the release of Yukon we will be able to do amazing things. What I would try to do here is to enlist some of the public information published on the internet. There are tons of links that come up if you were to search for "Yukon" on any search engine. We will try to highlight some interesting features available from the net. You can also visit the resources page to get a list of some of the links
Next Generation SQL Server Part II - Yukon
Welcome to the Part II of the series where we take a closer look into Yukon . The release of the next version of SQL Server, code-named Yukon , is expected in early 2004(as per news reports). The Yukon release will include the .NET Common Language Runtime (CLR), which will allow developers to write database objects such as stored procedures and triggers in .NET-compatible languages such as C# and VB.Net, C++.NET, J#. Yukon is still a long way off, but it is not too early to start preparing for the dramatic changes the new SQL Server release will bring - especially those associated with Microsoft's .NET Common Language Runtime (CLR)
Next Yukon, Whidbey Betas Due In May, Microsoft Says
Paula Rooney
7:33 PM EST Fri., Oct. 10, 2003. Microsoft expects to launch Yukon Beta 2 and the Whidbey Beta 1 in May of 2004 with Phase III testing scheduled for August, company executives said on Friday

Microsoft prepares for Yukon, Longhorn
Martin LaMonica
Microsoft on Tuesday announced plans for new development tools, as the company continues to lay the groundwork for its next major database and operating system software releases

Yukon для мaньякoв. T-SQL.
Anatoly Lubarsky
Ктo хoчет пoсмoтреть пoлный списoк фич, тoму сюдa: An Overview of SQL Server "YUKON" for the Database Developer. Я тoлькo упoмяну некoтoрые из них. Вo первых нa смену всеми любимым Enterprise Manager и Query Analyzer прихoдит Mssql Workbench, сoвмещённый с Whidbey, т.е. грядущей версией Visual Studio. Кoнечнo с встрoенным intellisense. Вo втoрых пoчти пoлнoстью переписaн DTS. Ну этo не жaлкo, oн между нaми вo мнoгoм устaрел уже с выхoдoм первoй версии .NET Framework. Улучшилaсь системa зaщиты, все системные тaблицы теперь будут view (кaк в oрaкле, кстaти). Чтo ещё... Ну пoскoльку extended procedures пoтеряли aктуaльнoсть с выхoдoм .Net, a зaмены всё не былo, в YUKON, недoрaзумение устрaненo, зaместo extended прoцедур, мoжнo пoдключaть .Net assembly прямo через T-SQL прoцедур и выпoлнять рaзные вещи, нaпример делaть рaссылку писем. Oчень легкo. Этa фичa нaибoлее рaзлеклaмирoвaнa в YUKON. Ну ещё усиление и умoщнение oптимaйзерa, perfomance, т.е. mssql в дoпoлнение к нoвшествaм нaкaчaл бицепсы. И ещё мнoгo всегo

ISVs Courted for 'Yukon' Apps
Lisa Vaas
Microsoft Corp. plans to whet the appetite of small and midsize businesses for a major update of its SQL Server database—code-named Yukon—with a liberal helping of Yukon-ready applications

Inside Longhorn: The Details
Don Kiely
PDC, October 28, 2003. Microsoft divided its presentation of Longhorn into three basic aspects: presentation (code-named Avalon), data (code-named WinFS), and communication (code-named Indigo). User interfaces today are targeted at different platform and device technologies, such as Windows or Web forms-based applications. You can create a multi-tier application that allows client code of any type to access the middle and data tiers, but you have to write different client code for each version of the interface. Longhorn's presentation services, code-named Avalon, is the first step in unifying all client code technologies, providing a brand new way of defining a user interface in Longhorn. It is a unified presentation model for Windows apps, Web apps, graphical apps, and apps that run on various devices. It also has rich support for advanced input devices, such as a TV remote control, virtual ink, and various smart devices. Microsoft is again raising the level of abstraction that Windows makes over the hardware

Microsoft Struggles To Get Yukon Database Beta Out The Door
By Barbara Darrow
Boston -- The clock is ticking on Yukon. Microsoft has promised the first real beta of its next-generation database for the first half of the year. Depending on how first half is defined, that gives the company just over a month. Company sources said the push is on internally to deliver a beta drop by June 1, just in time for the company's TechEd conference in Dallas

Preparing for Yukon
Michael Otey
Yukon is still a ways off, but it's not too early to start preparing for the dramatic changes the new SQL Server release will bring—especially those associated with Microsoft's .NET Common Language Runtime (CLR). SQL Server 7.0 transformed SQL Server's underlying database-engine architecture, but the way that DBAs manage the server remained essentially the same. You still use Enterprise Manager for multiserver management and T-SQL to create and update databases and their objects. Although Yukon features the same underlying architecture, the release has big changes in store for DBAs

Navigating Yukon - A First Look
Steve Jones
This series of articles will dive into the new features of Yukon, the release of SQL Server scheduled to succeed SQL Server 2000. I've searched around the web and I see bits and pieces of the product listed, but no real in depth look at them, so I decided to track my progress. As you read the articles, you may see changes in my experiences as the product evolves through Beta cycles and I learn more about it. I'll try to dig into particular features and do more than just mention them, though we'll learn together about the product. It's been a little while since I wrote this, but the NDA just lifted, so here's the first impression

Microsoft reveals Longhorn server plans
Ina Fried
Microsoft has laid plans for a server version of Longhorn, the next release of Windows. But it remains unclear what the software will include and when it will debut

Великая отсрочка
Майкл Оти
На конференции Tech Ed в июне старший вице-президент Microsoft Пол Флесснер объявил, что выпуск версии Yukon SQL Server, поначалу ожидавшийся в конце этого года, а затем перенесенный на первую половину 2004 г., по-видимому, не будет готов и до второй половины следующего года. Сама по себе отсрочка выпусков продуктов Microsoft не вызывает удивления; можете ли вы припомнить хотя бы один продукт Microsoft, выпуск которого состоялся бы вовремя? Но компания редко афиширует значительную задержку, когда до выпуска продукта остается еще больше года

Tidbits from the PDC 2003
Bradley L. Jones
This week I'm attending Microsoft's Professional Developers Conference, or PDC as they call it. It is safe to say that it has already proven to be better than the last. But then, the last PDC focused on .NET My Services aka "Hailstorm" -- a technology that is relatively missing in action at this point. One thing that is sure, the technologies covered this year will not go by the way side in the same way as .NET My Services

SQL Server on a non MS platform? Never!
News IS
The analyst community has long been saying that it’s only a matter of time before Microsoft starts porting its applications, especially its server-based business applications, to Linux

Стали известны подробности о новой файловой системе в SQL Server Yukon
Главной темой для обсуждения при представлении на конференции Microsoft Professional Developers новой версии реляционной базы данных SQL Server Yukon стала новая файловая система WinFS. По словам представителей компании, WinFS вобрала в себя все самое лучшее за 15 лет развития продукта SQL Server. Как отметил Гордон Манджионе (Gordon Mangione), вице-президент подразделения Microsoft SQL Server, платформа для хранения данных WinFS в новой версии Windows Longhorn, вместе с SQL Server Yukon позволит каталогизировать информацию различными способами и связывать один информационный элемент с другим
What admins need to consider in advance of Yukon
Margie Semilof
DALLAS -- At the TechEd conference earlier this month, IT executives picked up a few details about Microsoft's database strategy. First, the company said it would add reporting services for SQL Server 2000; they will appear sometime later this year. And, second, officials said that Microsoft's next-generation database, code-named Yukon, will ship six months later than originally planned. It's now due out in late 2004, and it's probably going to be a few years beyond that before most IT shops consider installing the software. Nonetheless, Stan Sorenson, director of SQL Server product management, offered a few tips for customers interested in knowing how to prepare for Yukon

An Overview of SQL Server Yukon for the DBA
Eric Brown
The next version of Microsoft SQL Server code named "Yukon" provides the Windows Server System with a database platform for the next generation of connected, scalable and reliable enterprise applications. The breadth and depth of innovation is in response to the needs of many customers. After reading this paper, database administrators will have an understanding of the new features and capabilities found in SQL Server Yukon. From many enhancements to existing features to an entirely new security model, database administration is now more productive and in tune to the needs of the administrator

Introducing Microsoft SQL Server "Yukon"
Organizations today are facing several unique data challenges: the proliferation of data and systems across their enterprise; the need to provide employees, customers, and partners with consistent access to that data; the desire to better equip information workers with meaningful information to drive informed decisions; and the mandate to control costs without sacrificing application availability, security, or reliability
Microsoft's Revised Road Map Includes Slips For Yukon, Jupiter
Barbara Darrow & Paula Rooney
Microsoft provided a revised product road map at Tech Ed 2003 on Monday, including a slip of its Yukon version of SQL Server until the second half of 2004.

News about Yukon (SQL Server .NET / SQL Server 2004 / SQL Server 2005)
Seit fast zwei Jahren spannt Microsoft uns mit dem neuen SQL Server auf die Folter, der unter dem Namen "Yukon" entwickelt wird. Einzelne Informationen sind dabei immer wieder durchgesickert, insbesondere die Integration der CLR in den SQL Server, sodass Stored Procedures in Managed Code geschrieben werden konnen. Auf der TechEd 2003 in Barcelona hat Euan Garden mehr Details zur Programmierung des neuen SQL Servers verraten. Hier eine Stichwortartige Zusammenfassung des Vortrags "DBA234".
Microsoft Hopes New Features Will Warm Up End-Users to Yukon
Joe McKendrick
10/1/03 — The wait for Yukon – the code name for the next release of SQL Server – is on, but, unfortunately, it’s going to take longer than first thought. The new database is now scheduled to ship in the second half of 2004, timed to coincide with the release of next version of Microsoft's Visual Studio toolkit

Remarks by Eric Rudder, Senior Vice President, Developer and Platform Evangelism
Well, good morning. Everybody awake? Everybody using Visual Studio .NET? By show of hands, just I like to know who I'm talking to and especially since I come from a VBITS tradition, I'm kind of curious on language, how many of you use VisualBasic.NET as your primary language in Visual Studio? That's a good chunk. How many use Visual C# as their primary language? That's pretty good. How many use C++? Smaller. J#? COBOL? Fortran? OK. This language independence thing, we can go on for 27 questions
Web Services Land in Yukon
Darryl K. Taft
SAN FRANCISCO—Web services will play a key role in Yukon, the next version of Microsoft Corp.'s SQL Server database, a company executive said

Eric Brown Discusses SQL Server—Past, Present, and Yukon
It's been a busy year for SQL Server. Not only did it celebrate its 10th anniversary last winter, Microsoft is preparing a new version, code-named "Yukon," that's currently undergoing a round of early beta testing. MSDN Magazine recently talked to Eric Brown, a product manager for SQL Server, about the product's past and future
Get Ready for Yukon
Roger Jennings
The next release of SQL Server promises increased developer productivity and reduced DBA workload. For This Solution: SQL Server "Yukon" Beta, Visual Studio .NET "Whidbey" Beta, InfoPath Beta, SQL Server Reporting Services Beta (when available)

Об SQL Server Yukon
Поль Тюрро
Испытание первой бета-версии разрабатываемой Microsoft новой редакции SQL Server под названием Yukon назначено на середину 2003 г., а выпуск продукта ожидается в начале 2004 г. Это событие по своему значению приравнивается к выходу Windows Server 2003, поскольку Yukon станет для пользователей новым сервером баз данных и платформой, на которой будут строиться новая служба каталогов Active Directory (AD) и версии Microsoft Exchange Server, файловая система Windows и другие продукты. По словам представителей Microsoft, технология Yukon обладает расширенными возможностями программирования, усовершенствованной корпоративной базой данных, а также развитой бизнес-логикой

What's new in SQL Server Yukon
Euan Garden
Yukon is Microsoft's codename for the next version of SQL Server, due to be released in 2004. Tim Anderson talks to Euan Garden, Microsoft's Product Unit Manager for SQL Server Tools

'Yukon' Enters Beta Territory
Mary Jo Foley
At long last, Microsoft is providing testers with its next-generation SQL Server code

VSLive! Speaker Interview
David Campbell, product unit manager, SQL Server Engine and Tom Rizzo Group Product Manager in the SQL Server Product Unit on the Upcoming release of Yukon
Yukon will appear in the middle of 2003 ...
Svetlana Kuvshinkova
The Microsoft corporation prepares a 64-bit DBMS and the DBMS of the following generation, which was given the title Yukon, and is offered first of all as the base of data repositories and will allow to reduce to minimum periods of idle time of a database server. The release of Yukon beta-version and 64-bit SQL Server version which was given the title SQL Server 2000 64-bit, is scheduled at the beginning of 2003

SQL Server Needs Incremental Updates
Brian Knight
As you may have heard, the next version of SQL Server (code named ?Yukon¦) has a name. The release is now formally called SQL Server 2005 to match Visual Studio 2005. A new schedule was announced that pushes the beta cycle out as well. Beta 2 will be widely shipped in the summer of 2004. Beta 3 will be shipping in the late 4th quarter and the GA release will ship in the first half of next year

[TOP]

[NEXT]

Rambler's Top100 Рейтинг@Mail.ru  Administrator: Обратная связь 
Copyright: SQL.Ru 2000-2013