(Paul D. Sheriff) Developers constantly face problems brought on by changing technologies. When Microsoft releases a new version of a data provider, or a customer decides to switch databases from Oracle to SQL Server, you may have to rework code you’ve already written. But you can avoid much of this
Other News
Data Manipulation using ListView Server Control with ASP.NET 3.5
(Jesudas Chinnathampi (Das)) In order to use the ListView control, we need the ASP.NET 3.5 Framework. All examples mentioned in this article were created using Visual Web Developer 2008 Express Edition. You could use SQL Server 2000/2005 or the free SQL Express to try out the examples explained in t
Encoding and Validation of Binary XML Storage of XML Schema-Based Data
(Marco Gralike) One of the new things in 11g is the possibility to set the method of how to enforce the validation / encoding of your XML document, straight away via embedding these options in your binary XML storage structure. It is just a small entry in the manual, but I think an important one. Th
Differences between Unique and Non-Unique Indexes (Part II)
(Richard Foote) The most significant difference between a Unique and a Non-Unique index is of course the simple fact that in one index, all index entries MUST be unique and in the other index there can be duplicates of an index entry.
Basic SQL Server security principles you can’t afford to miss
(Kevin Beaver) Where did the good old days of security go? I remember learning about the basic information security principles of least privilege, delegated administration and separation of duties way back when security wasn’t cool. They were the cornerstones of effective IT administration and secur
Server Sizing for SQL Server 2000 and 2005
(Joe Chang) Server sizing strategies using requirement driven approaches tend to go in to inane details involving substantial effort with no clear conclusions at the end. By considering only the systems most suitable for line-of-business database servers, there are just a few meaningful choices, mak
FORCESEEK Table Hint in SQL Server 2008
In prior versions of SQL Server, there was a way to force the optimizer to consider an index in the execution plan – however, there was no way to always force it to do a seek operation. That has now been added in the next release (tested against CTP5). A point of caution here – don’t be trigger happ
SQL Server At CES! (Sort of)
Featured Article(s) Review: SoftTree SQL Assistant SQL Assistant is a tool that integrates into your environment of choice, offering to help with your SQL coding. The hope is that you will end up with standardized code, better, more efficient coding time since the tool would help you create the code and more. One reason to use Cursors than Set based […]
Hot skills: DB 9.5
(Nick Langley) IBM’s DB2 is a relational database management system (RDBMS), widely used in enterprises. In recent years, IBM has been working to widen the range of platforms its flagship relational database runs on, and also to deepen its capabilities. Recent additions to DB2 9.5 included substanti
MySQL Table Prefix Changer Tool in PHP
(Nilpo) If you are a web developer, you are undoubtedly aware that there are constant threats to your site. SQL injections are one type of threat that you must be aware of and make every attempt to prevent.