(Vinod Kumar) SQL Server 2005 is loaded with features and in this article we will look at yet another function introduced in SQL Server 2005 . This function is called as NEWSEQUENTIALID().
Other News
Banish Security Blunders with an Error-prevention Process
(Adam Kolawa) Security can be a complex and often overwhelming issue. To ensure application security, not only must you prevent hackers from entering the system, but you need code in place that safeguards security should those preventive measures fail. There is no room for error. You can anticipate
Speed Up Your Hibernate Applications with Second-Level Caching
(John Ferguson Smart) High-volume database traffic is a frequent cause of performance problems in Web applications. Hibernate is a high-performance, object/relational persistence and query service, but it won’t solve all your performance issues without a little help. In many cases, second-level cach
Use of custom attributes to serialise objects to/from SQL Server tables
(Duncan Edward Jones) This class library is a quick implementation to use custom attributes to marshal a .NET class to/from an SQL Server database table. It is fairly simple in that it assumes a one-to-one mapping between the class and the table.
FIX: You receive an ‘unexpected data length’ error message when you run a query and you are using Host Integration Server OLE DB Provider for DB2
When you are using Microsoft Host Integration Server 2004 OLE DB Provider for DB2 or Host Integration Server 2000 OLE DB Provider for DB2, you may receive an error message that is similar to the following when you run a query: OLE DB provider ‘DB2OLEDB’ returned an unexpected data length for the
MySQL and high volume data storage
(Mike Hillyer) We currently use Oracle 8i to house a database that stores around 10 million rows a day. We currently store the most current 7 days, partitioned by day. We have 15 tables and of those 15 tables 2 main tables are accessed the most. One of these tables has 44 columns — data types r
Developing a Custom Web Part, Part 1
(Paul Schaeflein) Although Microsoft provides many examples in the software developer’s kit, most developers who are starting to work with Web Parts still have questions. When I am starting with a new technology, I search for many examples. By comparing the examples, I believe that I get a better un
Oracle users question roadmap
(Martin Veitch) Oracle users are catching on to the latest versions of the firm’s software although many remain on pre-9i editions, according to the UK Oracle User Group (UKOUG) annual survey, published in October.
Secrets Of The Masters: Core Java Interview Questions
(Yakov Fain) If you are planning to hit the job market, you may need to refresh some of the Java basic terms and techniques to prepare yourself for a technical interview. Let me offer you some of the core Java questions that you might expect during the interviews.
Enhanced SQL Server Security Auditing
(Daljit S. Saini) Security audit in SQL Server captures only successful and failed logins. It does not capture the application that uses the login. The login used by an application may have full read and write access on all of the tables and procedures but the application itself restricts the users