Additional Articles

An Overview of SQL Server 2005 for the Database Developer

by Additional Articles

MSDN Communities

Development

With the release of Microsoft SQL Server 2005 Beta 2, the world of database development is changing. As a database developer, you now have the option to appropriately locate your code in relation to its functionality, to access data in native formats such as XML, and to build complex systems that are driven by the power of the database server. Database development is becoming more integrated than ever before, and all of the tools that you need are available right at your fingertips.

2004-11-02

3,856 reads

Discuss

Writing Managed Stored Procedures in SQL Server 2005

by Additional Articles

DevX

.Net

Are you tired of struggling with T-SQL to encapsulate the logic your applications need to get data into and out of SQL Server? Now you can bypass SQL altogether, and write logic that runs directly within SQL Server in your favorite .NET language.

2004-11-01

4,360 reads

Discuss

SQL Server 2005 Hands-On Labs

by Additional Articles

MSDN Communities

Development

Manuals for all SQL Server 2005 hands-on labs are now available for download. See the Hands-On Labs Manuals section of this page for links

2004-10-29

3,935 reads

Discuss

Securing Your SQL Server 2005 Express Edition Server

by Additional Articles

MSDN Communities

Get introduced to SQL Server Express, learn how to install and configure it in a secure manner, plus get information on the basics of SQL Server security.

2004-10-28

1,125 reads

Discuss

Work with XML Data Type in SQL Server 2005 from ADO.NET 2.0

by Additional Articles

Other

Development

One of the excellent features of the next release of SQL Server, known as SQL Server 2005, is its deep XML integration with the SQL Server database engine. This integration goes well beyond the simple relational-to-XML mapping layer that SQL Server 2000 provided. SQL Server 2005 will feature a native XML data type that will allow you to store native XML data in SQL Server itself.

2004-10-25

2,377 reads

Discuss

sp_lock with order by and object name

by Additional Articles

SQLServerCentral

Lock and Connection Management

A kind of sp_lock with an ORDER BY possibility. It gives also the name of the locked object (table) if executed in the same database.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-10-22 (first published: 2004-07-26)

725 reads

Discuss

Working with Image Objects in InfoPath 2003 and SQL Server 2000

by Additional Articles

MSDN Communities

Miscellaneous

You can use features in Microsoft Office InfoPath 2003 Service Pack (SP) 1 to work more efficiently with image objects and other data. Learn how to use BLOB data types to work with data stored in a Microsoft SQL Server 2000 database from an InfoPath form. InfoPath 2003 provides a robust and rich interface to store and access data in SQL Server databases. Learn about best practices for integrating SQL Server databases and InfoPath form data, with an illustrative example.

2004-10-22

1,146 reads

Discuss

MDX Essentials: Basic Set Functions: The EXTRACT() Function

by Additional Articles

ASPToday

Analysis Services (SSAS)

This is the twenty-fourth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs.

2004-10-21

1,747 reads

Discuss

Restore multiple DTS packages

by Additional Articles

Database Journal

This article examines how to take advantage of VB Script and MS-DOS batch files to restore multiple DTS packages stored in the form of structured storage files from one folder to a SQL Server box.

2004-10-20

1,987 reads

Discuss

SQL Server 2000 Security - Part 13 - SQL Injection attack

by Additional Articles

Database Journal

Security

Typically, access to data is provided via client applications, which increases the range of potential vulnerabilities and places an equal share of responsibility for data security on software developers. This is especially important since application flaws can have just as catastrophic implications as a misconfigured or unsecured SQL Server installation.

2004-10-19

2,337 reads

Discuss

All authors

Additional Articles

An Overview of SQL Server 2005 for the Database Developer

Writing Managed Stored Procedures in SQL Server 2005

SQL Server 2005 Hands-On Labs

Securing Your SQL Server 2005 Express Edition Server

Work with XML Data Type in SQL Server 2005 from ADO.NET 2.0

sp_lock with order by and object name

Working with Image Objects in InfoPath 2003 and SQL Server 2000

MDX Essentials: Basic Set Functions: The EXTRACT() Function

Restore multiple DTS packages

SQL Server 2000 Security - Part 13 - SQL Injection attack

Blogs

Ramblings about data communities and your contributions, no excuses

SQL Server Journey till 2025 (brief)

Building Power BI Reports: Desktop vs Fabric

Forums

2026 Guide to Multi-State Payroll Tax Issues and Compliance

Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE

Having a Little Fun at SQL Server Central

Question of the Day

String Similarity I