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 […]
Other News
Compliance, Even If You Are Not REQUIRED To?
The Weekly SQL Server Show – Watch Now The current show is an interview with Kim Tripp and Paul Randal. We got together at DevConnections in Las Vegas and talked about everything from the famous board game to SQL Server 2008. > Watch Here Browser-Based Compare, Synchronize and Audit Tool This is pretty cool – this tool will compare and […]
We don’t need no stinkin’ backups!
(Willie Favero) Forgive the gruffness of today’s title. I’m actually paraphrasing Mel Brooks (Blazing Saddles) who was actually spoofing a line from Bogart’s “The Treasure of the Sierra Madre”. And no, I am not opposed to running backups. I think a sound backup strategy is the foundation of any succ
Parsing XML documents using DOM
Parsing XML documents using DOM is easy and simple. Let do this with example.
Opinion: Preparing for XBRL Reporting and Beyond
(Michael Ohata) Last month, the U.S. Securities and Exchange Commission established the Office of Interactive Disclosure, to which companies and mutual funds can submit data and reports in Extensible Business Reporting Language, better known as XBRL.
Linked List
(Jim Mischel) A linked list is a fundamental data structure that is often used to implement other data structures. The traditional linked list consists of a sequence of nodes, each of which contains arbitrary data fields and two additional references: links to the previous and next nodes in the list
Save time with Visual Studio 2005 project templates
(Tony Patton) While application development provides plenty of opportunities to be creative, there are numerous aspects of every project that require developers to perform the same tasks over and over again. Automating such tasks provides you with more time to concentrate on the more challenging asp
HTML V5 and XHTML V2
(Adriaan de Jonge) While the intention of both HTML V5 and XHTML V2 is to improve on the existing versions, the approaches the developers chose to make those improvements is very different. And with differing philosophies come distinct results. For the first time in many years, the direction of upco
Establishing an IBM DB2 database connection in IBM Rational Functional Tester
(Fariz Saracevic) Learn how to establish an IBM DB2 database connection using IBM Rational Functional Tester Java scripting. All you need to do is to follow these three simple steps and use the sample code provided.
Visual Studio 2008 and .NET 3.5 Released
(Scott Guthrie) Visual Studio 2008 and .NET 3.5 contain a ton of new functionality and improvements. Below are links to blog posts I’ve done myself as well as links to videos you can watch to learn more about it: