(Robert Hamel) I was very pleased when I heard about Oracle adding pivot functionality in select statements. Finally — we wouldn’t have to copy the data to a spreadsheet or code a ton of sum(case when col1 = ‘X’ then amount else 0 end) total_X for each column we would want to display.
Other News
Comparing the result of two queries using set operators
(Flavio Casetta) As you certainly know, set operators (intersect, union, union all, minus) allow to perform powerful tasks in an Oracle database.
Managing MySQL Table Relations with Rails’ Active Record Association Types
(Jason Gilmore) In last week’s article, I showed you how Rails’ powerful migrations feature eliminates the long-standing chasm separating the way databases and code are maintained by offering a way to programatically manage table structures. Combined with Rails’ Active Record implementation, program
Storing XML Data in a Relational Database
(Ivan Pepelnjak) Unless you work in a highly rigid, well-structured environment, you’ve probably had situations in which you have to store objects with widely different descriptions (properties, attributes, fields… whatever you call them) into the same relational database table.
Forcing Termination of User SQL Sessions so I can ‘DROP DATABASE’
(Euan Garden) Once again from the internal dbtalk alias. The person in question recreated their database from scratch as part of a batch job every night and had GO USE MASTER GO DROP DATABASE FOO GO in their script and obviously it was not working. The basic problem here is anothe
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 9
(Muthusamy Anantha Kumar) This installment of the series illustrates how to use PowerShell in conjunction with SMO to Generate an SQL Server Script. Generating SQL Server Scripts is an essential task for SQL Server Database administrators and developers.
NULLs Part II: NULL usage of NULL
(James Luetkehoelter) In my previous post on NULLs I discussed (rather replied to Hugo Kornelis) some more academic concepts and definitions when it comes to NULL. It is very sad for me to admit that, while interesting to me and many others, that sort of discussion is all but useless the instant you
Don’t Forget: Sometimes It’s The Easy Stuff…
Don’t Miss the Latest SQLonCall: Basic Security Best Practices (new show posts tomorrow!) SelectViews: Software as a Service, Data Archive Challenge and more Featured Article(s) Diagnosing Poor Data Access Code Using SQL Profiler I created this article to assist DBAs and application developers who need to optimize data access code in their applications. This document covers a few cases where […]
SQL Server server and Databases Health check process
Featured Article(s) SQL Server server and Databases Health check process The following stored procedure is really a collection of several TSQL system procedures designed to monitor server and databases configuration values and keep the DBA Informed about databases health Want to manage multiple implementations of the same database? Want to build stored procedures in seconds? Auto generate SQL Delete, Update […]
Working with Compression
(Jim Mischel) With 500 megabyte disk drives well under 100 dollars, it’s easy to assume that you’ll always have enough disk space for whatever program you’re building. Unless you’re crawling the Web and downloading every music or video file you can find, you’re unlikely to fill up that 500 megabyte