(James Koopmann) Grouping and in particular gathering aggregates across groups often brings confusion to many practitioners. This does not need to be the case if approached from a systematic fashion. This article will approach gathering aggregates from a simple GROUP BY operation and then extend
Other News
Flattening Data into a List in SQL Server
(Paul Litwin) Normalization to 3rd normal form (or higher) is a good thing. For example, in the pubs database, in order to model the fact that a given author can write more than one book, and that a given book can have multiple authors, you have to model the many-to-many relationship between author
Take Total Control Of Your Networking With .NET And UDP
(Yaniv Pessach) You’ve probably made use of Transmission Control Protocol (TCP) in your applications at some point, whether directly or indirectly—after all, HTTP runs on top of TCP, so every Web application is built atop it. But maybe you’ve wondered whether its brother User Datagram Protocol (UDP)
Improved Debugging with Visual Studio 2005’s Debugger Visualizers
(Scott Mitchell) When debugging a project in Visual Studio .NET 2002/2003, you can view the current values of a variable by simply entering the value into the Watch window, or by hovering your mouse over the variable in the code window. While this approach worked wonderfully for simple types with sh
Primary Keyvil, Part I
(Josh Berkus) Two actual conversations I had on IRC, handles changed to protect the ignorant, and edited for brevity (irc.freenode.net, channel #postgresql): newbie1: schema design: http://www.rafb.net/paste/results/Bk90sz89.html agliodbs: hmmm … why do you have an ID column in “states”? You’r
Extending PL/SQL with Java Libraries, concluded
(Ron Hardman and Michael McLaughlin) Building a procedure will follow very similar rules to building functions. PL/SQL procedures have an IN or IN and OUT mode. However, you cannot use an IN and OUT mode in PL/SQL when wrapping a Java method.
Weaving WebSphere: Oh, Domino!
(Joe Pluta) It’s that time of the year: New Year’s resolutions are made and thoughts of change swirl through our minds (although for those of us with little ones, change is more likely changing diapers, but I digress).
Automate SQL injection testing
(Kevin Beaver) SQL injection is a security exploit in which the attacker adds SQL code to a Web form input box to gain access. Manual testing for SQL injection — as described in this tip and this paper — used to be the only way to determine if your database was vulnerable. Rooting through returned
A Visual Studio Add-In That Converts C# Code To Visual Basic
(Scott Swigart) The “Paste as…” functionality in applications like Microsoft Word has become indispensable for me. I often copy something from the Web and want to paste it into a document without all of the HTML formatting. Paste as is the tool for the job.
RDF Data Model in Oracle
(Nicole Alexander, Xavier Lopez, Siva Ravada, Susie Stephens and Jack Wang) The Resource Description Framework (RDF) is a language for representing information about resources in the World Wide Web. To describe information in RDF, statements are essentially broken into triples: {subject/resource, p