We have been blogging for quite some time now on the new feature sets of the upcoming release of SQL Server – SQL Server 2008. You can search for SQL Server 2008 on this blog and get to those posts. In this post, we wil cover another new feature called “Change Data Capture”. Using this feature, one
Other News
More From the You-Can’t-Know-Everything-Dept: A TSQL tidbit
(Julia Lerman) I was recently creating a stored procedure in SQL Server for a client to do reporting on. THey wanted the ability to decide at report time how many records should be returned. I knew the “hack” in SQL Server 7 and 2000 (using ROWCOUNT) but discovered that with SQL Server 2005, you can
Continuing the Exposed Server Debate
Virtual Conference Update We’ve started posting our first pass at sessions – take a look! If you’d like to be involved in reviewing and commenting on the sessions and other aspects of the virtual conference, get signed up today and we’ll be sure you’re included. Remember, 3 days of outstanding content, from your computer – NO travel, NO out of […]
One Possible Reason for On-The-Net SQL Servers
Available on SSWUGtv: A wide-ranging interview with Microsoft’s Matt Nunn about Visual Studio 2008, what it does, what he likes about it, and so much more. Also, a bit about update stats, discussion list watch and a whole lot of other great SQL Server information. > Watch the show here Also, don’t miss: Watch: Handling a DBA interview. A Mock […]
The Attributes of an XML Element
So far, we have used only one attribute per element. Fortunately, you can create as many attributes as you judge necessary in an element. To do this, type the name of each attribute, assign it a double-quoted element and separate the attribute from the next with an empty space. Here is an example of
jQuery Demo: Working With XML Documents
(Ben Nadel) As we learn about AJAX (Asynchronous Javascript and XML), our first thought is that it is very cool. Our second thought is usually that XML sucks and it’s such a pain in the butt to work with. With that discovery, many of us turn to using AJAX purely as a text/HTML delivery system or we
Web Services with Ruby on Rails
(William Brogden) Ruby was a rather obscure object-oriented dynamically typed "scripting language" until it suddenly got a lot of notice due to the appearance of the Rails Web application framework. The combination quickly became known as Ruby on Rails, I suppose because that creates a better image
.NET Web Product Roadmap (ASP.NET, Silverlight, IIS7)
(Scott Guthrie) Last week we shipped Visual Studio 2008 and .NET 3.5. This release is a big one for .NET, and delivers a ton of new capabilities and improvements for web, client, office and mobile development.
Creating Custom Label Controls
(Brian Mains) The label control is a simple control for rendering output or other HTML-based content. Overall, the label is somewhat limited in what it can do, as compared to the other .NET controls. For instance, a label can only render the text it has been given, and can show/hide that text. What
Using Partial Methods
(Paul Kimmel) First the architect created partial classes. Partial classes were deemed good, so next the architect created partial methods.