News (22)

Microsoft releases SQL Server 2008

Microsoft said on Wednesday in the US that it had finished work on SQL Server 2008, the latest version of its database software. Read more »

Microsoft slips out Yukon test release

Microsoft has released another test version of its forthcoming SQL Server 2005 database and has introduced a free management tool. Read more »

Microsoft planning add-on to SQL Server

Microsoft wants SQL Server to scale new heights, and it is hoping an add-on code-named Kilimanjaro will help. Read more »

Microsoft readies revamped database, security software

Microsoft says it's set to release near-final versions of its key database server and other business-oriented software. Read more »

Microsoft kills stand-alone WinFS project

Microsoft has decided to initially use technology from its WinFS project in the SQL Server database, rather than directly in its Windows operating system. Read more »

Microsoft to hand out early code

Looking to drive demand for a wave of forthcoming products, Microsoft will fill the pockets of developers this week with early versions of several programs, including the latest "build" of Windows Vista. Read more »

Microsoft may offer peek at SQL Server code

Will the software industry's wave of open-source databases spill onto Microsoft's turf? Read more »

Beta on tap for Visual Studio, SQL Server

Read more »

IBM fires up new Stinger

IBM today quietly released an update for the beta program of their upcoming DB2 release, code-named "Stinger". Read more »

Microsoft whiffs on tools, database betas

Microsoft has missed its deadline for sending out the latest test versions of its flagship development products, SQL Server and Visual Studio. Read more »

More Code, Sql Server 2005 News Results

Features (39)

Using Mirrored Media Sets in SQL Server 2005

Mirrored Media Sets is a new feature in the Enterprise Edition of SQL Server 2005. It enables the creation of redundant copies of a backup file to reduce the possibility of a backup device malfunction. Here's how you make it work. Read more »

Easily correct data casing with SQL Server

In this tutorial, I will create a function that will be useful in terms of updating data or just displaying data to end users in a pleasing manner. Read more »

Advantages of the new PIVOT operators in Yukon

The next version of Microsoft's SQL Server, code named Yukon, will include new PIVOT operators. See what PIVOT operators can do for your next database project. Read more »

Audit data using SQL Server 2005's COLUMNS_UPDATED function

This article looks at how the SQL Server 2005 COLUMNS_UPDATED function works and then discusses how to parse out the field names. Read more »

Implement custom paging with SQL Server 2005

In previous columns, I covered the basics of using the .NET 3.5 ListView control and explained how to pair it with the DataPager control. Now I'll show you how to use these controls with a SQL Server 2005 backend to implement custom paging, in which only a subset of the data is retrieved for display. Read more »

Capturing SQL Server 2005 database file size information

It's very important to capture trends of the sizes of your SQL Server 2005 database because it allows you to plan for future space needs, notice types of problems, and plan for time periods of heavy volume. I'll show you the simple method that I use to capture this information. Read more »

Build directory structures using SQL Server 2005

If you store directory structures in the database, you are aware of what it takes to retrieve the data. Writing queries to pull this information is sometimes difficult to achieve and inefficient. You can use the recursion and XML features in SQL Server 2005 to build a file location on the fly. Read more »

Find blocking processes using recursion in SQL Server 2005

Blocking occurs in SQL Server 2005 when one process has one or more records locked, while another process tries to acquire locks on the same set (or subset) of records. This can create a daisy-chain of processes waiting to complete their work. Read more »

Write your own sp_lock system stored procedure in SQL Server 2005

The sp_lock system stored procedure is a great tool for checking the amount of locking that occurs on your database system. It returns the number and types of locks that are being held by current active SQL Server sessions. Read more »

SQL Server 2005 secrets

There's plenty of hype about the new SQL Server 2005. Here's a list what's important about the pending release, and what you can plan on using SQL Server for in the near future. Read more »

More Code, Sql Server 2005 Features Results

Blog (1)

Database pros get tools in the know

David McAmis [blogs:theneteffect] -- Microsoft has just released the eagerly anticipated Visual Studio 2005 Team Edition for Database Professionals (TEDB) which allows developers to build database applications in a team environment. Read more »

Log in


Sign up | Forgot your password?

Blogs

RSS feed

  • Staff Crying, mooning and leaving

    In this week's roundup we see that continuous whining can get results, Linux users get 64-bit Flash and Moonlight previews, the latest in the Yahoo/Microsoft relationship and Senator Conroy ducks and weave in Senate Question Time. Read more »

    -- posted by Staff

  • Brendon Chase Sun eye Web developers with Netbeans 6.5

    Despite the recent employment axe hitting Sun the company has pushed out a new release of its Netbeans open source IDE with an eye to appeal more to Web developers. Read more »

    -- posted by Brendon Chase

  • Renai LeMay BarCamp buzz: Let the hacking continue

    Attending last weekend's BarCamp in Sydney, it was hard to escape the conclusion that a certain "dot-com bust" flavour had seeped into the kool aid previously being drunk by Australia's web 2.0 and early stage start-up sector. Read more »

    -- posted by Renai LeMay

What's on?