In this post, we are going to cover another T-SQL enhancement in SQL Server 2008. We will be using the same set of tables that we did in one of our previous blog post in which we had talked about the MERGE command in SQL Server 2008.
Other News
Microsoft Moving Forward for Virtual Environments
New Show Posted (Live After 2:30a MST) Today’s show has a LOT of information. Interviews with some tools makers, information about protecting your holiday time, 60 second tip of the day, our SQL Server discussion list watch and a whole lot more. > Watch Now Featured Article(s) Find the list of SQL objects which got modified – SQL Server 2005 […]
A Guide to Basic Computer Forensics
(Tom Cloward and Frank Simorjay) There are countless ways malicious people can use a computer to perform illegal activity—hacking into systems, leaking trade secrets, unleashing new viruses, using phishing messages to steal personal information, and so on. And we are constantly hearing about new exp
Dissecting ASP.NET Version 3.5’s Web.config File
(Scott Mitchell) In November, Microsoft released the final version of ASP.NET 3.5 and Visual Studio 2008. As discussed in An Overview of ASP.NET 3.5 and Visual Studio 2008, version 3.5 is not a major reworking of the .NET Framework. Rather, it adds new classes and functionality on top of the existin
Crystal Reports in ASP.NET
Crystal Reports is the standard reporting tool for Visual Studio .NET used to display data of presentation quality. You can display multiple-level totals, charts to analyze data, and much more in Crystal Reports. Creating a Crystal Report requires minimal coding since it is created in Designer inter
Automated .NET Hang Analysis
(Tess Fernandez) In my constant effort to make my job obsolete, I have created an “add-in” for windbg that automatically checks for hang conditions in a .NET memory dump.
Wrap the Result of an XQuery Query into an XML Document
(Anghel Leonard) Wrapping the result of an XQuery query into an XML document is very useful if you’re working with atomic values. The following Java program uses the net.sf.saxon.om.SequenceIterator and net.sf.saxon.query.QueryResult classes to do this:
Tip: Make the best use of asynchronous callbacks
(David Mertz) It takes some finesse to make the best use of asynchronous callbacks for Ajax data sources in JavaScript applications. This tip discusses why you should use asynchronous callbacks for Ajax data sources and gives examples of coordinating the readiness of mutually dependent application d
WCF and XML serialization helper classes
(MarkGwilliam) This is a very short article simply to describe some useful serialization helper classes that I’ve used for quite a while and thought I would share. The classes allow single line calls to serialize and deserialize using either the XML or the WCF serializers. Nothing special or tricky
What Are Your Plans for DB2 for z/OS Stored Procedures
(Robert Catterall) If your organization runs DB2 on a mainframe server, are you using stored procedures? If so, good – plan on using them more extensively. If you’re not using DB2 stored procedures, get moving with respect to putting an implementation plan in place.