(Lewis Cunningham) I work in an environment that is not really a database shop. The DBA and I are really the only Oracle people on site. The rest are mostly business people and .Net developers. This is kind of weird since we’re a data warehousing and BI shop.
Author: SSWUG Research
.NET Internationalization: Using Custom Cultures
(Guy Smith-Ferrier) The CultureInfo class is at the heart of .NET’s internationalization solution. In Chapter 6, “Globalization,” you saw that in the .NET Framework 2.0, the list of available cultures is a combination of those cultures known to the .NET Framework plus those known to the operating sy
Practical tips for deploying Oracle and open source
(Mark Brunelli) If you’re choosing between “open source” and “closed source” to meet your company’s needs, stop — because there’s no need to differentiate the two anymore, according to speakers at the Oracle OpenWorld conference. (R)
Optimization Hints: the Story Continues
(Willie Favero) It’s nice to know that someone does actually read my post. I know because 1) I get some very nice comments when I speak at different events (Thank you all), and 2) I have received a couple of private e-mails with a few questions (and concerns) about using optimization hints. Question
Testing for Security in the Age of Ajax Programming
(Bryan Sullivan) Ajax programming is one of the most exciting new technologies in recent history. Ajax (Asynchronous Javascript and XML) allows a web page to refresh a small portion of its data from a web server, rather than being forced to reload and redraw the entire page as in traditional web pro
FIX: Error message when you configure an immediate updating transactional replication in SQL Server 2000: ‘Implicit conversion from datatype ‘text’ to ‘nvarchar’ is not allowed’
Consider the following scenario. You configure an immediate updating transactional replication in Microsoft SQL Server 2000. The replication contains a table, and the table has hundreds of columns. In this scenario, the Distribution Agent may report the following error message: Msg 257 Implic
Making connections more manageable
(Jeremy Cole) For the past few weeks off and on, as part of Proven Scaling’s project to improve the MySQL server, I’ve been helping Joel Seligstein to really dig into the MySQL source code and add some features, in preparation for a much bigger feature coming up (more on that at a future date). He h
Real Web 2.0: Bookmarks? Tagging? Delicious!
(Uche Ogbuji) In this article, you’ll learn how to work with del.icio.us, one of the classic Web 2.0 sites, using Web XML feeds and JSON, in Python and ECMAScript. When you think of Web 2.0 technology, you might think of the latest Ajax tricks, but that is just a small part of the picture. More fund
Creating GridView Columns Dynamically (Part 1)
(Bipin Joshi) Many months back I wrote three articles – Creating DataGrid Programmatically, Creating DataGrid Templated Columns Dynamically – Part I and Creating DataGrid Templated Columns Dynamically – Part II. Even today these are amongst top viewed articles. This indicates how commonly developers
Data warehouse based on operational data model
(Mike Lampa) When trying to design a data warehouse, we often try to model the database on the operational data model. Are there any guidelines in trying to create a data warehouse based on the operational data model? (R)