News (41)

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

Ruling threatens developers' wallets

In a ruling that could force royalty fees on some developers working with Microsoft's SQL Server 7 data-management software, a Washington state judge said Microsoft could not sublicense another company's patents to SQL Server customers. Read more »

Microsoft releases new Visual Studio and .NET

Microsoft has this week made its top development tool, Visual Studio 2008, available for download to its professional developer subscribers. Read more »

Oracle joins Microsoft developer program

Oracle has pledged to make its database software work better with Microsoft's development tools. Read more »

Microsoft extends tool giveaway

Microsoft has decided to continue indefinitely a free development tool offer it launched last year to better attract hobbyists and students to Microsoft's software. 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 »

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 »

More Coding, Developer, Sql Server News Results

Features (151)

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 »

Handle errors in the data tier with SQL Server

Exception handling is a standard part of every .NET application. The try/catch block allows you to catch exceptions and control application execution from that point. Many errors occur during database interaction, but a lot of developers are unaware of handling errors within the database tier. This week we examine error handling in your database code with SQL Server and T-SQL. 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 »

Generate synchronisation scripts in SQL Server with TableDiff

DBAs often have to find the differences between lookup tables in different database environments. SQL Server comes with a tool called TableDiff that allows you to easily compare the data in tables. Read more »

Passing table valued parameters in SQL Server 2008

I have always wanted to be able to pass table variables to stored procedures. If a variable is able to be declared, it should have the functionality to be passed as necessary. I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass table variables (and the data in them) into stored procedures and functions. 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 »

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 »

Oh, my--MySQL!

MySQL is great for energising your Web site, managing personal data, or any of the average everyday uses of a database. Read this article to learn more about this system, and discover when, where, and why you should use MySQL. Read more »

Strategies for approaching null values with SQL Server

Dealing with null values is a fact of life for every database developer. Take advantage of these tips to properly deal with them in SQL Server for your next project. Read more »

More Coding, Developer, Sql Server Features Results

Blog (2)

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?

Blogs

RSS feed

  • Staff Opera's new SDK: Better browsing on the Wii?

    Opera has thrown a little more love at device developers by announcing an updated version of its software development kit on Wednesday at CES. Read more »

    -- posted by Staff

  • Staff 2008: Time to call stumps

    It's another year down but some things never change. That was shown this week as Internet Explorer remained under fire from yet another zero-day exploit. In other news, we set a hard drive on fire and Apple cans its involvement with MacWorld. Read more »

    -- posted by Staff

  • Staff Unlocking Android

    In this week's roundup we take a look at Google's new technology -- Native Client, its Android phone, news from the world of web browsers and more. Read more »

    -- posted by Staff

What's on?