Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
SQL Server

Home >Search > Articles & Samples > SQL Server > SQL Sever 2005
What's New - What's Hot
Listings for Administration Administration (21)
Listings for Configuration Configuration (84)
Listings for Data Management Data Management (109)
Listings for DTS Packages DTS Packages (16)
Listings for Exception Handling Exception Handling (22)
Listings for Functions Functions (37)
Listings for Installation Installation (8)
Listings for Migration to SQL Server 2005 Migration to SQL Server 2005 (131)
Listings for Miscellaneous Miscellaneous (206)
Listings for Performance/Optimization Performance/Optimization (90)
Listings for Reports Reports (40)
Listings for Scripting Scripting (6)
Listings for Security Security (25)
Listings for Service Broker Service Broker (46)
Listings for SQLXML SQLXML (33)
Listings for T-SQL T-SQL (13)

The 'Secure by Default' Features of SQL Server 2005     
Total Hits: 24  |  Today: 0Author: Klaus Aschenbrenner      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 2005 offers improvements in authentication and authorization, as well as native support for cryptography—features that enable more secure database application design and implementation than previous releases....

Big SQL Server 2005 News     
Total Hits: 115  |  Today: 0Author: Steve Jones      Rating:  
Read Reviews | Write Review |  Your Rating: 

Confidential until the official release at 9:00am Pacific Time today. Check back after that time to get the big news! It's a big announcement from Microsoft that's only valid after 9:00am PST on September 14, 2005. Therefore we have to hold this content until then. But check back after 9. Since we're on Mountain time, this server is one hour ahead of Pacific time....

Writing and Executing Your First Yukon CLR Procedure     
Total Hits: 27  |  Today: 0Author: Suhil Srinivas      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article explains the various steps involved in writing and executing a Yukon CLR Procedure. This article also is a starting point to develop complex data crunching SQL procedures....

SQL Server Yukon - New Possibility     
Total Hits: 12  |  Today: 0Author: Michael Youssef      Rating:  
Read Reviews | Write Review |  Your Rating: 

I consider Yukon a new way of supporting Microsoft. NET. In fact, when I heard about Yukon I begun to ask myself many questions like "How Yukon supports .NET?", "What makes me go for Yukon?" and "What are the Yukon features?", after some research on my own, I found the answers and I'd like to share with you....

A Visual Tour of SQL Server Yukon     
Total Hits: 84  |  Today: 0Author: Suhil Srinivas      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article has been written with keeping in mind of the large number of developers who do not have access to the SQL Server beta 1. Often, I feel that there are plenty of developers who hear and read about the new yet to be released products but have not means to look at them. Although this article would not give the reader an experience as enriching as working with Yukon but will surly make the new developer more comfortable to the SQL Server Yukon beta1....

A Visual Tour of SQL Server Yukon - XQuery Editor     
Total Hits: 15  |  Today: 0Author: Suhil Srinivas      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article is the second in a series of articles giving developers a visual tour of Yukon. The previous article was aimed at giving a developer a tour of the SQL Workbench. In this article the primary focus would be on the XQuery designer....

Understanding SQL Server Yukon Service Broker     
Total Hits: 16  |  Today: 0Author: Jesus Rodriguez      Rating:  
Read Reviews | Write Review |  Your Rating: 

The new version of Microsoft SQL Server "Yukon" comes together with a set of technologies capable of enlarging the horizon for database applications. One of the most remarkable technologies is the Service Broker that makes it possible to build database-intensive distributed applications. The Service Broker actually implements a set of distributed communication patterns to add messaging capabilities to SQL Server applications. In this article we explore the core concepts of the Service Broker and...

SQLCLR Debugging     
Total Hits: 19  |  Today: 0Author: Amit Anajwala      Rating:  
Read Reviews | Write Review |  Your Rating: 

In SQL Server 2005, CLR integration allows you to write stored procedures, triggers, user-defined types, and user-defined functions using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#. In this article, I will explain how to debug SQLCLR stored proecdure or SQLCLR user-defined function....

The 'Secure by Default' Features of SQL Server 2005     
Total Hits: 16  |  Today: 0Author: Klaus Aschenbrenner      Rating:  
Read Reviews | Write Review |  Your Rating: 

Software security is a very important topic, because not a single day passes without the discovery of some new exploit. Windows 2003 Server was the first product Microsoft shipped under the motto "secure by default." The whole server is locked down by default, and you have to activate each service you want to use separately. Therefore, attackers have to hard work to gain access to the system. The same policy applies to SQL Server 2005: the complete database server is also locked down by default ...

SQL-CLR Best Practices     
Total Hits: 95  |  Today: 0Author: Simon Robinson      Rating:  
Read Reviews | Write Review |  Your Rating: 

Continuing our series reporting on news from TechEd Europe 2005, this column piece summarizes Gert Draper's talk on SQLCLR vs T-SQL Best Practices. The talk covers issues about when you should or shouldn't use the CLR to write SQL code, and along the way presents examples of code that shows how to write managed code to execute inside SQL Server 2005....

SQL Server 2005 .NET Integration     
Total Hits: 33  |  Today: 0Author: Robin Dewson      Rating:  
Read Reviews | Write Review |  Your Rating: 

In the final article of the series introducing SQL Server 2005 Robin Dewson examines the new support for .NET and the ability to write stored procedures and other items using managed code. The article also covers a couple of other related topics, including new ADO.NET notification support, multiple active results sets (MARS) and SQL Server Integration Services (SSIS)....

Microsoft SQL Server 2005: Should Developers Care?     
Total Hits: 130  |  Today: 0Author: Andrew Binstock      Rating:  
Read Reviews | Write Review |  Your Rating: 

Despite being one of the giants of the database industry, Microsoft's SQL Server has gone four years without a face-lift. This lull is in part attributable to planned features that depended on now-postponed aspects of the next Windows release—notably the new WinFS filesystem—which were going to provide necessary technology underpinnings. As a result, the release of SQL Server 2005 (code-named Yukon) has been redefined several times....

An Intro to CLR Integration in SQL Server 2005     
Total Hits: 19  |  Today: 0Author: Sahil Malik      Rating:  
Read Reviews | Write Review |  Your Rating: 

T-SQL has been the conventional method of writing database objects such as stored procedures, triggers, aggregates, and so forth. SQL Server 2005 introduces a new array of possibilities because of its tight integration with the .NET Framework. It allows you to write stored procedures, triggers, and other such objects in a .NET-compliant language such as C# and VB.NET, compile them as a dynamic link library, and register them inside SQL Server....

Query Notifications in ADO.NET 2.0     
Total Hits: 27  |  Today: 0Author: Bob Beauchemin      Rating:  
Read Reviews | Write Review |  Your Rating: 

Learn how to use the new notification technologies in ADO.NET 2.0 and SQL Server 2005 to handle ad-hoc data refreshes....

Encrypt and Decrypt Data in Yukon     
Total Hits: 207  |  Today: 0Author: Roger Jennings      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, I'll explain how to take advantage of SQL Server 2005's new native encryption features to reduce the risk of exposure of confidential information to unauthorized individuals or organizations and to potential civil or criminal penalties. SQL Server 2005 Express Edition (SQLX) supports the same set of data encryption features. Sample code and a downloadable VS 2005/VB Express project deliver production-grade data encryption examples (see Figure 1). Live encryption examples compens...

Admin Benefits of SQL Server 2005     
Total Hits: 43  |  Today: 0Author: Danielle Ruest and Nelson Ruest      Rating:  
Read Reviews | Write Review |  Your Rating: 

It's been a long ride and it's not over yet. Microsoft has been working on the next release of its flagship database for more than five years now. A first beta of the new version was released as far back as the summer of 2003. One year later, the beta was extended to a larger community of testers. In late October last year, Microsoft revised its release schedule for SQL Server 2005 ("Yukon") and stated that the product would not ship until the second half of 2005. Finally, a launch date was anno...

Yukon Tempts Database Developers     
Total Hits: 13  |  Today: 0Author: Roger Jennings      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes what VS database developers can expect from Microsoft's investment of 4,000+ person-years in SQL Server 2005. (4,000+ person-years assumes that the SQL Server 2000 team numbered 700 at release and grew at a constant 60-person/year increment to 1,000 over the past five years.) To learn what benefits database administrators (DBAs) can expect from SQL Server 2005, check out the Database Administration track's 23 breakout sections and "Admin Benefits of SQL Server 2005" by Dan...

Easy Web Services with SQL Server 2005 HTTP Endpoints     
Total Hits: 30  |  Today: 0Author: Randy Holloway      Rating:  
Read Reviews | Write Review |  Your Rating: 

By leveraging HTTP endpoints and SOAP in SQL Server 2005, developers can bypass IIS and use SQL Server directly to expose Web services and simplify their applications....

Using SQL Server 2005's New Web Services Capability     
Total Hits: 30  |  Today: 0Author: Martin Heller      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server 2005 lets you expose specific stored procedures, user-defined functions, and SQL queries for use via HTTP or secure HTTP, making SQL Server databases more accessible to non-Windows clients, and improving security by eliminating the need to open TCP ports for SQL Server....

Yukon, Our New Possibility     
Total Hits: 133  |  Today: 0Author: developerland      Rating:  
Read Reviews | Write Review |  Your Rating: 

This tutorial will give you a brief look at SQL Sever 2005 (Yukon) from a developer's perspective.
"Yukon will change the world of database development"...

Disclaimer - Privacy
© 2002-2017