News (15)

Microsoft fires up free tools for developers

Microsoft on Thursday launched its WebsiteSpark program, intended to encourage web developers to use the company's tools and technologies. Read more »

Microsoft releases preview for next SQL Server

Microsoft has delivered the next iteration of its flagship database product, SQL Server 2008 R2, to developers for review. Read more »

Microsoft warns of SQL Server vulnerability

Microsoft issued an advisory late Monday confirming a remote code execution vulnerability affecting its SQL Server line. Read more »

Microsoft fixes DNS flaw but warns of Word attacks

Microsoft is warning that a Word flaw is being used for targeted attacks, and has also issued four 'important' patches, including one for a potentially serious DNS flaw in the latest Patch Tuesday bulletin. Read more »

Zend Web tools adapted for Windows

Zend has signed a partnership with Microsoft to improve its open-source PHP software for creating dynamic Web pages, the companies announced Tuesday. Read more »

Microsoft: No more five-year waits for SQL Server

Microsoft's SQL Server development team learned a hard lesson from its work on SQL Server 2005: Customers do not want to wait five years for an upgrade. Read more »

Microsoft XML guru sees power for the people

For some insight into how Microsoft plans to drive upgrades of its nearly ubiquitous Office desktop application suite, talk to Jean Paoli. 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 »

Microsoft announces free multi-core support

Microsoft has announced that it will not charge more for software licences for machines with multi-core processors than it will for those with one core. Read more »

IBM to make Java database open source

Raising its stakes in open-source software, IBM plans to create an open-source project around Cloudscape, a specialised Java database, CNET News.com has learned. Read more »

Features (60)

Comparing cursor vs. WHILE loop performance in SQL Server 2008

This article discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. Read more »

Setting up Change Data Capture in SQL Server 2008

Change Data Capture (CDC) is a new native feature in SQL Server 2008 Enterprise Edition. This article shows how to use CDC to easily set up data auditing on your SQL Server system. Read more »

Filtered Indexes in SQL Server 2008

Filtered indexes are a neat feature in SQL Server 2008 that allows you to define indexes on subsets of data. Read more »

Avoiding cursors with SQL Server 2005

Sometimes cursors are necessary when executing queries in SQL Server, but most of the time they can be avoided entirely. This article shows where cursors can traditionally be used, and how you can use features packaged in SQL Server 2005 to avoid them. Read more »

Introduction to Change Data Capture in SQL Server 2008

This article takes a look at the great new auditing features available in SQL Server 2008. Read more »

What is in your toolbelt?

As a DBA, you probably have several tools to help you in a bad spot. Have you heard of SQL Professional Toolbelt? It can be a handy addition to keep your SQL Server humming. Read more »

How do I assign permissions to users to see SQL Agent Jobs?

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server. Read more »

How do I run code automatically when SQL Server starts?

The need to run a stored procedure or SQL Agent Job when SQL Server or SQL Agent starts is a common requirement in the world of SQL Server administration. This article gives an overview of the ways to execute SQL stored procedures or SQL Agent jobs on startup. Read more »

Script Table definitions using TSQL

Generating scripts in SQL Server using TSQL has never been easy. This article will show you how you can use TSQL in SQL Server 2005 code to script a table's definition. Read more »

Implementing the Soundex function in C#

For years Microsoft SQL Server has provided developers with a method called Soundex that is used to retrieve an encoded string. Words that sound alike have similar encodings, so you can use this functionality to provide some flexibility in searches. This article shows how to implement Soundex completely in C# without having to use the SQL function. Read more »

Log in


Sign up | Forgot your password?

  • Staff Microsoft shows off IE9 preview

    This week, highlights from Microsoft's MIX10 conference and more in the Roundup. Read more »

    -- posted by Staff

  • Chris Duckett IE9's H.264 vote killed Ogg

    In a split decision by the judges, the winner of the W3C/WHATWG video codec consensus is H.264, taking home the future of video playback on the internet while loser Ogg goes home with nothing but thoughts of what might have been. Read more »

    -- posted by Chris Duckett

  • Staff Google launches Apps Marketplace

    Google launches and app store, while Mozilla plans to re-write its open-source license. More of this week's news in the Roundup. Read more »

    -- posted by Staff

What's on?

  • Optus Deal

    Broadband + home phone + PlayStation®3 in a single package price!