Columns


Microsoft SQL Server Turns 17

After 17 years of non-stop development, SQL Server 2005 now has what it takes to give Oracle 10g and IBM DB2 a run for the money in the enterprise-scale, multiterabyte database market. But the SQL Server team didn't abandon its traditional small- and medium-size business customers.

Save Time With LINQ Queries

See how the LINQ syntax, specifically DLinq and XLinq, can increase your productivity and reduce the possibility for error.

Powerful Laptops Alter Mobile Landscape

New boon for mobile computing.

SQL Server 2005 Mobile Edition Goes Everywhere

A forthcoming Win32 upgrade to SSM joins SSE with SSX and Jet in Microsoft's new triumvirate of freely distributable database engines.

Eclipse Foundation Launches Community Portal

This week the Eclipse Foundation launched a community portal called Eclipse Plugin Central (EPIC), which helps software developers find Eclipse plug-ins, tools, and products that enhance the Java software development lifecycle.

Implement a File Transfer Web Service

Implement a Web service that performs a binary file transfer using Web Service Enhancements 3.0 and MTOM.

Tricks for Processing SQL Scripts

Discover how SQL Server 2005's SQLCMD tool can enhance your scripting processes.

Integrate XML Into Your Reporting Environment

You'll find several areas of interest regarding XML usage in SQL Server Reporting Services.

WSIT Components Are Made Available

Sun's Web Services Interoperability Technology is a 2006 JavaOne Conference-opening highlight. Sun and Microsoft move another step forward to fulfill the promise of interoperability.

Using Data Integrity

Ensure that your data is accurate, and find undetectable bugs in your applications with SQL Server's Data Integrity feature.

Secure Your Data With SQL Server

Learn how defining levels of database access, for both nonsensitive and sensitive data, can help protect you from system failure.

Database Dev a Cinch With DDL

Database Definition Language (DDL) makes maintaining changes between your databases easier.

Build Better Collections With Generics

Take advantage of .NET 2.0's addition of generics to provide better collections functionality in your applications.

Understand Variable Scoping and Definite Assignment

Learn how to scope your variables correctly, as well as the rules governing definite assignment in C#.

Make a SQL-to-Java Connection

SQL Server 2005's Type 4 JDBC driver provides database connectivity from a Java application. Though the driver class and connection URL are a bit different in this version, connectivity is a snap.

Don't Neglect Your Skills

A reader concurs with Peter Varhol about the need to keep up your skills; also, a reader argues that technology isn't an end in itself, although developers often forget this.

SQL Server Resources

Check out these publications, tools, SDKs, and community sites for additional information about SQL Server.

Happy Trails at JavaOne:

Today and tomorrow were front and center at the technical general session of Sun's mega-event, the 2006 JavaOne Conference in San Francisco.

SQLCLR for the .NET Developer

Learn about SQLCLR, writing database objects in managed code, and configuring SQL Server to use code located within .NET assemblies.

Install SP-1 for SQL Server 2005 and Express

Microsoft posted on April 18, 2006 the RTM version of Service Pack 1 for SQL Server 2005 Developer, Workgroup, Standard, Enterprise, and Express editions. Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express.

Subscribe on YouTube