News (25)

SQL Server 2005 updated

Service Pack 1 is here, and includes mirroring tools as well as new features for the Express edition. 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 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 says new database coming by end '05

After numerous delays, the next editions of Microsoft's main software development products SQL Server 2005 and Visual Studio 2005 will be available in November. Read more »

SQL Server 2008 delayed until third quarter

Microsoft said on Friday that it has pushed back the delivery date of its SQL Server database until the third quarter of this year. Read more »

Partners frustrated by Microsoft launch delays

Insiders broadly welcome Microsoft's virtualisation push but voice some frustration at the fact some products are later than expected. Read more »

Windows Server 2008 RC1 available for download

Microsoft has kicked off what it claims will be the "largest enterprise launch" in the company's history by releasing Windows Server 2008 RC1. 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 readies embedded database

Microsoft is set to release an embedded database for small devices, taking its first step in a plan to bring updates to its flagship SQL Server database every two to three years. Read more »

Features (25)

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 »

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 »

Create your own SQL Server views

Follow this step-by-step process from Dan Seewer to build views using Enterprise Manager in SQL Server 7.0/2000. Read more »

More New SQL Server 2008 Features

Microsoft updates SQL Server on a pretty regular basis. Its newest version, SQL Server 2008, includes some new features not found in older versions. Here's a list of some of them. 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 »

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 »

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 »

Using Grouping Sets in SQL Server 2008

A neat new feature in SQL Server 2008 is the GROUPING SETS clause, which allows you to easily specify combinations of field groupings in your queries to see different levels of aggregated data. This article looks at how you can use the new SQL Server 2008 GROUPING SETS clause to aggregate your data. Read more »

New Date Datatypes in SQL Server 2008

SQL Server 2008 provides new data-types for storing wider ranges of dates with more precision. Heres how you can use these new data types to your advantage in SQL Server 2008. Read more »

Microsoft SQL Server 2005 uncovered

SQL Server 2005 has finally hit the market and brought with it significant new features and changes from previous versions. We'll explain the various editions of SQL Server 2005 take a look at the new management console. Read more »

Blog (2)

Service Pack or Market Attack?

David McAmis [blogs:theneteffect] -- I will give it to Microsoft. When they want to capture a particular market, they go hard or not at all. And with SQL Server 2005, they have their sights set firmly on the Business Intelligence market. And their strategy makes sense—they are moving to become the "one stop shop" for database servers, data management tools, reporting and analysis, eliminating the need to spend more money on third-party tools. Read more »

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?

  • 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?