New SQLonCall Show Posted Mock Interview, Part I. Go through the interview process, questions, answers and interpreting the responses. Find out how you can approach the interview, from both the interviewer and interviewee standpoint. > Watch The Show Here Featured Article(s) Troubleshooting SQL Server 2005 Merge Replication (Part 3) In this article, Alexander Chigrik explains some problems that you can […]
Other News
SQLonCall: Mock Interview, Part I. Go through the interview process, questions, answers and interpreting the responses.
Pro-Center Video Programming for IT Professionals
Security and Distraction with SQL Server
Featured Article(s) Dynamic TSQL pivoting procedure The following TSQL Stored procedure simplified the usage of the PIVOT operator presented in SQL SERVER 2005. it accepts parameters for the pivoted column, the aggregate function, the group column and the group column values range It constructs the PIVOT statement and executes it dynamically using EXEC function Managing Change with SQL Server We’ll […]
XML namespace prefix ‘xmlns’ is not defined
(Bill) When working with VB9 you may get this cryptic error : XML namespace prefix ‘xmlns’ is not defined
New Data Types in DB2 9 for z/OS
(Craig S. Mullins) DB2 9 for z/OS offers a plethora of new features, but sometimes what seems like one of the more mundane new features can actually be quite beneficial. Such is the case with data types. DB2 9 for z/OS offers five new data types, so let’s examine each of them in a little detail.
Basic XML Syntax
XML is a language that was developed for a very specific purpose. The purpose of XML is to provide a compliment to HTML and therefore allow you to store your data outside of the actual HTML document. As you get more advanced in your programming, you will realize that there are times when this can be
More Compression Enhancements
(Chris Eaton) In a previous posting from late last month I talked about the new automatic compression capabilities in DB2 9.5 as well as the compression for in-lined XML. There are two other compression enhancements that you should be aware of in DB2 9.5.
An Overview of ASP.NET 3.5 and Visual Studio 2008
(Scott Mitchell) On November 19, 2007, Microsoft officially released the ASP.NET version 3.5 and Visual Studio 2008. Like with the progression from ASP.NET 2.0 to 3.0, the features in ASP.NET 3.5 are additive, meaning that the core assemblies installed from the .NET Framework version 2.0 are still u
IBM Tivoli Common Data Model: Guide to Best Practices
(Vasfi Gucer, Ron Baker, Elizabeth Edmiston, Ben Jeffcoat and Ling Tai) The Common Data Model (CDM) is an information model that provides consistent definitions for managed resources, business systems and processes, and other data, and the relationships between those elements. CDM is based on the un
Maximize Productivity With ASP.NET
(Dan Wahlin) Microsoft’s release of the .NET Framework and ASP.NET in 2002 sparked a revolution in Web development, making it possible to create event-driven, compiled, and object-oriented Web applications rapidly. If you use ASP.NET, you no doubt appreciate its power and are eager to know what the