News (48)

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 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 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 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 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 »

Visual Studio, SQL Server delayed again

Microsoft said new versions of its Visual Studio development tools and SQL Server database, expected before August, have been delayed until later in the year. Read more »

Microsoft to reveal more Longhorn details

Microsoft is expected next month to disclose more details on Longhorn, its planned upgrade to Windows, as the company looks to drive demand for the forthcoming operating system. Read more »

Beta on tap for Visual Studio, SQL Server

Read more »

Features (179)

Managed code in SQL Server Yukon: a big deal?

One of the big features of Microsoft's next release of SQL Server is the ability to run managed code. How does it work, and is it a good idea? 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 »

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 »

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 »

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 »

Take advantage of undocumented SQL Server iteration procedures

Here's a look at how you can use two built-in system stored procedures -- sp_msforeachdb and sp_msforeachtable -- to iterate through SQL Server tables and databases. 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 »

Help! My SQL Server Log File is too big!

Overgrown transactional log files can turn into real problems if they are not handled properly. This article discusses the perils of not handling SQL Server log growth properly, and what can be done to correct the problems. Read more »

Running totals in SQL Server queries

This article demonstrates how running totals are simple to create in SQL Server queries once you understand the requirements. Read more »

Blog (3)

In a world of Goliaths, who's got a stone?

David McAmis [blogs:theneteffect] -- It seems like it is that time of year again... the days are getting longer, the weather is getting a bit warmer and the top-tier software vendors are on a buying spree. Will you get lost in the shuffle? Why not support your local software developer! 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 »

Microsoft services VS2008 & .NET 3.5

Staff [blogs:syslog] -- Microsoft has just announced the release to manufacturing of the .NET Framework 3.5 Service Pack 1 (SP1) and Visual Studio 2008 SP1. Read more »

Log in


Sign up | Forgot your password?

What's on?