Tags: development, sql server
News (80)
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 relaxes virtualisation rules
Microsoft has eased up its server licensing rules so that organisations can make more efficient use of servers in virtualised environments. 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 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 »
Partners frustrated by Microsoft launch delays
Insiders broadly welcome Microsoft's virtualisation push but voice some frustration at the fact some products are later than expected. Read more »
Windows Server 2008 RC1 available for download
Microsoft has kicked off what it claims will be the "largest enterprise launch" in the company's history by releasing Windows Server 2008 RC1. 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 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 whiffs on tools, database betas
Microsoft has missed its deadline for sending out the latest test versions of its flagship development products, SQL Server and Visual Studio. Read more »
Microsoft frees Visual Studio 2005 Express
The stripped-down version of Microsoft's development tool will be available at no cost indefinitely. Read more »
Features (193)
Developer Spotlight: Greg Low
Builder AU interviewed Greg via e-mail before the start of Tech.Ed 06 to talk about beta software, free databases, and the future of database development. Read more »
New Date Datatypes in SQL Server 2008
SQL Server 2008 provides new data-types for storing wider ranges of dates with more precision. Heres how you can use these new data types to your advantage in SQL Server 2008. 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 »
Bulk importing data into SQL Server
If you work with databases, at some point, you'll deal with inserting data into SQL Server from outside data files. This tutorial shows how to import data using the BULK INSERT command and explains how changing some of its options can make it easier and more efficient to insert data. 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 »
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 »
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 »
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 »
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 »
Blog (5)
Microsoft says "open sesame"
-- While you may have been out last night watching the latest Rambo adventure with Sly Stallone making war for war's sake, Microsoft was busy declaring a truce with the open source community. Read more »
Will Microsoft build native Mac and Linux tools?
-- If the future is in Microsoft's online services why isn't the company building native tools for Mac and Linux developers? Read more »
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 »
Microsoft services VS2008 & .NET 3.5
-- 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 »
In a world of Goliaths, who's got a stone?
-- 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 »
Filter Tags
News and features
- Latest
- Popular
- Features
- Most Discussed
-
In this week's roundup we see that continuous whining can get results, Linux users get 64-bit Flash and Moonlight previews, the latest in the Yahoo/Microsoft relationship and Senator Conroy ducks and weave in Senate Question Time. Read more »
-
Sun eye Web developers with Netbeans 6.5
Despite the recent employment axe hitting Sun the company has pushed out a new release of its Netbeans open source IDE with an eye to appeal more to Web developers. Read more »
-
BarCamp buzz: Let the hacking continueAttending last weekend's BarCamp in Sydney, it was hard to escape the conclusion that a certain "dot-com bust" flavour had seeped into the kool aid previously being drunk by Australia's web 2.0 and early stage start-up sector. Read more »
-
Interplanetary Internet a possibility
2008/11/21 10:32:55
-
Conroy ducks, Ballmer evades and Android Fails -- Club Builder
2008/11/20 10:58:20
-
Yang's resignation: The talk of Silicon Valley
2008/11/19 16:10:33
What's on?
-
Conroy ducks, Ballmer evades and Android Fails -- Club Builder
Club Builder this week takes a long look at Senator Conroy's recent attempt to explain his Great Firewall of Australia, we chase Steve Ballmer over Sydney, and find Google's biggest bug of the year.