(Flavio Casetta) I am a great fan of IOTs aka Oracle’s Index Organized Tables.
Other News
Database Programming in C# with MySQL : Using OleDB
(A.P.Rajshekhar) Persisting the data processed by an application has become the norm. The data can be stored either in a file system using normal files or in databases. The functionalities provided by database packages make them a more attractive proposition. With the advent of open source database
An Approach or Three to Categorization with SQL Server
Watch the Latest SelectViews Here > Watch Now – The Weekly SQL Server Show from SSWUG.ORG Featured Article(s) Troubleshooting error 3628 In this article, Alexander Chigrik explains how you can troubleshoot error 3628. Managing SQL Server-Based Email? If so, you may have come to realize how difficult and what a pain it can be to manage the bounce emails and […]
Taxonomies and Tagging – Are They The Same?
Featured Article(s) Understanding Windows Management Instrumentation Microsoft has come up with Windows Management Instrumentation (WMI); a COM based technology that can be used to retrieve system-related information from a computer system. This is a component of the Windows OS that can be used to retrieve hardware information from a system of any kind. You can use WMI to retrieve both […]
DB2 9 and Microsoft Excel 2007 – Part 1: Getting the Data…
(Paul Zikopoulos) Without a doubt, Microsoft Excel, is the world’s most ubiquitous reporting and data analysis tool. Quite often I see clients export massive amounts of data from their enterprise systems into another data server (guess which one) for the sole purpose of supporting Excel reporting.
DB2 Locking – Success or Failure in Managing DB2
(Bill Arledge and Judy Quenet) DB2 for z/OS incorporates unique relational characteristics with traditional database capabilities, including robust locking mechanisms that ensure data integrity while maximizing concurrency for the world’s most sophisticated DB2 applications. DB2 locking is a broad
SQLCLR Security and Designing for Reuse
(Adam Machanic) An important principal of software design is that of “least privilege.” Basically, in any given layer of a program, you should grant only minimal access such that the code has rights to only exactly the resources it needs to get its job done—and nothing more.
Improving Performance using ODS Custom Paging
(Bipin Joshi) Displaying database records in paged fashion is a common requirement in web applications. ASP.NET 2.0 controls such as GridView and DetailsView have inbuilt paging capabilities. Many developers rely on inbuilt paging to speed up their job. However, inbuilt paging comes with its own pri
Flat File Parsed to XML Using C#
(Matthew Cochran) I ran across an interesting problem today where I had to parse a flat file (csv or tab delimited) into an xml document. The solution I arrived at is flexible enough for reuse so I though I’d share the library along with some of my development notes.
Performance Impact of Procedure Calls without Owner Qualification
(Linchi Shea) It has been widely recommended that a stored procedure should be owner qualified when it is called. When it comes stored procedure best practices, this gotta be the most recommended practice. Do a Google search, and you’ll find this is recommended in books, conference presentations, Te