(Susan Visser) The Version 9 books are slowly arriving, so now is your chance to pick up any Version 8 books that you may want for 50% off the usual price.
Author: SSWUG Research
ASP.NET DropDownList and Unexpected Data
(Matt) You are data binding to a table. One of the columns, say US state, should have a limited domain, but for various reasons, values outside of that range appear. For example, you might be importing the data from a second system that uses the state field for country and state.
Magic Innodb Recovery self healing
(Peter Zaitsev) We have certain type of the table corrupting with Innodb, as it is limited to only one particular index on one particular table type it is likely to be Innodb bug but Heikki currently could not find what could be causing it.
Using NOLOCK and READPAST table hints in SQL Server
(Tim Chapman) When data in a database is read or modified, the database engine uses special types of controls, called locks, to maintain integrity in the database. Locks basically work by making sure database records involved in a transaction cannot be modified by other transactions until the first
SQL SERVER – 2005 Comparison EXCEPT operator vs. NOT IN
(Pinalkumar Dave) The EXCEPT operator returns all of the distinct rows from the query to the left of the EXCEPT operator when there is no matching rows in the right query. The EXCEPT operator is equivalent of the Left Anti Semi Join. EXCEPT operator works the same way NOT IN. EXCEPTS returns any dis
Online Indexing in SQL Server 2005
Online Indexing is a new feature available in SQL Server 2005. In SQL Server 2005, DBAs can create, rebuild, or drop indexes online. The index operations on the underlying table can be performed concurrently with update or query operations. This was not possible in previous versions of SQL Server. I
Use Table-Valued Functions as Arrays in SQL Server
(Mark J. Miller) The SQL IN statement allows a set of records to be returned based on a variable (unknown at design time) number of keys. However, IN doesn’t allow parameters and this leaves us with the choice of using either fixed lists or dynamic SQL statements. The problem with fixed lists is tha
plan_table changes
(Andrew Fraser) In versions 10g, plan_table exists as a public synonym of the global temporary table sys.plan_table$. That is all created automatically at database create time and when a database is upgraded to 10g (creation is in catplan.sql, which is called from catproc.sql and u*.sql scripts in $
Serving up Server Alerts
(Steve Callan) How and when do alerts or informational messages about what’s taking place inside your database make their way out to you, the DBA par excellence? There are several ways, some free and some hand-crafted, to expose alerts and messages. Let’s face it, as the Oracle RDBMS engine becomes
Signing, encrypting, and decrypting Atom
(Nicholas Chase) Atom is a great format for relaying information, but what about security concerns? XML Digital Signatures can ensure that data comes from a trusted party and that it is unaltered, and XML Encryption can obscure sensitive information from prying eyes. But how can you use these techno