(Ted Jardine) Back in the summer I described an issue with ASP.NET AJAX. The session solution dealt with things well enough (and note the update to simply disable session in a page-by-page basis for all but the pages requiring reading or writing to the session), but I’m still getting the occasional
Other News
Recommended reading list: DB2 for Linux, UNIX, and Windows database administration
(Samuel Poon and Fraser McArthur) Learn about IBM DB2 for Linux, UNIX, and Windows with this reading list, compiled especially for the database administrator community. This popular article is updated to cover DB2 9, formerly codenamed “Viper.” There is also an application development reading list t
Oracle 11g – Virtual Columns – to publish derived column values without storing them. And more…
(Lucas Jellema) Oracle 11g introduces Virtual Columns. “What do we need Virtual Columns for, aren’t real ones more useful?” you might wonder. And what are they to begin with?
SQL Server Transaction Isolation Models
(Mike Chapple) Normally, it’s best to allow SQL Server to enforce isolation between transactions in its default manner; after all, isolation is one of the basic tenets of the ACID model . However, sometimes business requirements force database administrators to stray from the default behavior and ad
Database backup: insufficient resources for cache withdrawal
(Brian Donahue) Sometimes SQL Server can pose conundrums of such complexity that even the Riddler couldn’t conceive of. In my mind’s eye, a SQL Server is in fact its’ own operating system, running on another operating system. For instance, SQL Server has a task scheduler to manage threads running wi
Data Compression: Why Do we need it?
(Sunil Agarwal) As announced in Tech-Ed 2007, data compression is a new and exciting feature targeted to be available in SQL Server 2008. This is a huge topic to be covered in one BLOG post, I have decided to break it into a series of posts, each building on the previous ones. If you are interested
PHP and SQL Server, SQL-Geek Humor
Watch the Latest: SQLonCall: Security and SQL Server – Best Practices SelectViews: Software + Service, Book Look and More Featured Article(s) Who do you Hire: The Decision You Need to Make I was talking to a director that I know and he mentioned to me that he has a scale that he measures prospective employees on. If you evaluate these […]
The Challenge of New Systems
New SQLonCall Show Live Now Basic Security Practices – Learn about mistakes commonly made when working with security and SQL Server. Lost consumer data, encryption, hacker attacks and much more – find out where to start looking and what to consider. > Watch The Show Here Featured Article(s) Troubleshooting SQL Server 2005 Snapshot Replication In this article, Alexander Chigrik explains […]
Introduction to ASP.NET 2.0 SqlDataSource Control
(Michael Youssef) The SqlDataSource control is one of the new controls introduced in ASP.NET 2.0. It provides developers with a declarative way of accessing data in databases for code-free retrieving and updating operations. In this article, and the next few articles, we take a deep look at the SqlD
Integrating the Oracle Designer Legacy Table API with Oracle JDeveloper 11g ADF Business Components
(Chris Muir) Oracle Designer is now firmly in maintenance mode, but it is still common to encounter legacy database schemas that have Designer’s fingerprints all over them, with generated Table APIs and good old cg_ref_codes. Such constructs may be unfamiliar to the newer Oracle developers in the cr