News (76)

SQL Server 2005 gets second service pack

Microsoft has released a second free service pack -- a large, recommended update -- for its popular SQL Server 2005 database application. 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 releases goals for updated SQL Server

Microsoft disclosed on Wednesday the main design goals for the "Katmai" edition of its SQL Server database, which is due next year. 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 »

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 »

Multicore move cuts Oracle database cost

In a move designed to counter Microsoft's growing database influence, Oracle has quietly cut software prices on some lower-end servers using multicore processors. Read more »

Database-maker Sybase reaches terabyte league

Database specialist Sybase has launched version 15 of its flagship Adaptive Server Enterprise (ASE) product in Australia, touting several new features such as the ability to support several terabytes of data. 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 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 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 »

Features (232)

Iterating through tables and databases in SQL Server

We look at two very useful stored procedures that live in the master database but are not mentioned in SQL Server Books Online. These system procedures come in very handy for jobs such as determining the space used, the number of rows, the indexes on the user tables, and so on. Read more »

Moving the Tempdb and Master Database in SQL Server

This article walks you through the process of moving the Master and Tempdb databases to different drives. 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 »

Speed up SQL Server database queries with these tips

If you've worked with SQL Server databases for any amount of time, it's practically a given that you've run into slow running queries. Learn how you may be able to improve performance by knowing what to look for in your query designs. Read more »

Restore your SQL Server database using transaction logs

Most DBAs dread hearing that they need to restore a database to a point in time, especially if the database is a production database. However, knowing how to do this is of the utmost importance for a DBA's skill set. I'll walk you through the steps of how to restore a SQL Server database to a point in time to recover a data table. 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 »

Reviewing SQL Server Permissions

This article looks at the importance of database permissions and how you can use internal SQL Server system views to easily which users have access on your system. 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 »

Introduction to Policy-Based Management in SQL Server 2008

New to SQL Server 2008 is Policy-Based Management. This new technology allows for defining polices to ensure your database guidelines are met. This article gives an overview of this new technology. Read more »

Blog (5)

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 »

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 »

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 »

Microsoft's two faces of SharePoint

Staff [blogs:syslog] -- One way or another, proprietary and open-source companies need an answer to SharePoint. Content is the center of the enterprise ecosystem, when all is said and done. SharePoint is Microsoft's answer for controlling the next decade of IT. Read more »

Log in


Sign up | Forgot your password?

What's on?