Tags: database, sql server 2005
News (36)
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 »
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 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 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 »
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 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 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 »
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 »
Features (59)
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 »
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 »
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 »
Finding dependencies in SQL Server 2005
This tutorial will show how you can write a procedure that will look up all of the objects that are dependent upon other objects. Read more »
How to import an Excel file into SQL Server 2005 using Integration Services
Integration Services, which replaces Data Transformation Services (DTS) in SQL Server 2005, is a tool for extracting, transforming, and loading data. Read more »
Simplify SQL Server 2005 queries with a Dates table
Learn what a Dates table is and how to create one, and then try it out for yourself. 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 »
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 »
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 »
Using Object Dependencies in SQL Server 2008
Tracking object dependencies has always been difficult with SQL Server. SQL Server 2008 makes it easier because it tracks dependencies by the object's name rather than ID. Here's how it works. Read more »
Blog (2)
Database pros get tools in the know
-- 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 »
Service Pack or Market Attack?
-- 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 »
Filter Tags
News and features
- Latest
- Popular
- Features
- Most Discussed
-
This blog post covers some of the technologies available for creating applications for the Semantic Web. Read more »
-
Bridging the gap between programmers and the visionA successful project will have a hard time flying if you don't walk through the game plan before writing a line of code. Read more »
-
Social news start-up Streem shuts downSydney social news start-up Streem will shut down this afternoon, according to a heartfelt notice posted on the site this morning by its founder Elgar Welch. Read more »
-
How to Reset Windows passwords
2008/10/01 14:31:09
-
Five things to consider when choosing a Linux distribution
2008/10/01 15:50:33
-
Cyber-terrorism 'a big threat'
2008/12/01 12:43:32
What's on?
-
Space pr0n, patent karma and Yang out -- Club Builder
On Club Builder this week: how NASA plans to get the Internet into space, Jerry Yang is out the door at Yahoo and Brendan Eich discusses javascript engine competition.