Other News

Editorials

SelectViews – The Weekly SQL Server Show

New SQL Server Show Posted SelectViews – The Weekly SQL Server Show – SelectViews: SQL Server 2008 Release Thoughts, Microsoft TechEd Split, 60-Second SQL Server Tip and More. Also: Upcoming Events, Our Drawing Winner for Feb., Current Release Versions, The Discussion List Watch and Other Goodies about SQL Server. > Watch the show here Webcast Tuesday – Register Now! Managing […]

Uncategorized

SQL Server Data Services Announced

New Approach to Backup Acronis has been working hard to address some traditional issues with backup and recovery approaches for SQL Server. While it’s possible to do the whole database and transaction log dump and restore cycle to recover a system, Acronis has gone a step farther. They’ve created tools that help you recover to the point of failure – […]

Community

Building Queries Visually

(Sue Harper) I’m often asked to describe the difference between Oracle SQL Developer and Oracle SQL*Plus. Their feature lists are indeed similar: both let you query the database objects you have access to; insert, update, and delete data by using data manipulation language (DML); add, alter, and del

Community

The Performance Woe of Binary XML

(Jimmy Zhang) Since its inception, XML has been criticized for the overhead it introduces into the enterprise infrastructure. Business data encoded in XML takes 5 to 10 times more bandwidth to transmit in the network and proportionally more disk space to store. While most agree that verbosity is inh

Community

Useful Extension Methods

(Brian Mains) Extension methods are very useful. They help extend the existing objects of .NET by attaching methods to it that it appears that it’s a part of the object, but it’s really not. Let’s look at some extension methods and how they can be useful.