(Tim Chapman) The sp_lock system stored procedure is a great tool for checking the amount of locking that occurs on your database system. It returns the number and types of locks that are being held by current active SQL Server sessions. One of my previous articles describes how you can use sp_lock
Other News
Oracle Data Pump 11g: Little-Known New Feature
(Babette Turner-Underwood) While perusing the Oracle 11g Data Pump documents recently, I noticed a new parameter that was introduced in Oracle 10g, but I had missed it there. The parameter is TABLE_EXISTS_ACTION, and it applies only to the Data Pump Import.
SQL Server 2005 Express Edition – Part 14 – Replication Support
(Marcin Policht) In our series dedicated to SQL Server 2005 Express Edition, we have been focusing mainly on characteristics that emphasize its unique capabilities, making it a preferred choice in variety of scenarios, despite the apparent superiority of its full-featured counterparts. However, it i
ADF 11g Rich Faces: focus on field after button press or PPR – Including JavaScript in PPR response and ClientListeners (Client Side programming in ADF Faces Rich Client Components Part 2)
(Lucas Jellema) In this second part of a series on ADF 11g Rich Faces Client Programming, I will talk about the option to include JavaScript in a PPR response, to execute on the client once the processing of the PPR response is complete. There can be several good reasons for such client side operati
Adding or dropping identity property for an existing column
One nice feature of SQL Server that is used quite a bit is the use of identity columns. This function gives you a simple way of creating a unique value for every row in your table. Adding a new column and making it an identity column is an easy thing to do as well as dropping an existing column th
Applying SQL Server Updates? Not So Fast…
SQL on Call Show Available Now The latest SQL on Call show is live now and you can watch it on the site – in today’s show Chris closes out the series of top 10 SQL Server thoughts about 2007. > Watch here Also available: [Watch] SelectViews, the SQL Server Show – Keeping up with technology, Microsoft interviews and more. […]
More on SQL Server Service Pack Installation Practices
SQL on Call Show Available Now The latest SQL on Call show is live now and you can watch it on the site – in today’s show Chris closes out the series of top 10 SQL Server thoughts about 2007. > Watch here Also available: [Watch] SelectViews, the SQL Server Show – Keeping up with technology, Microsoft interviews and more. […]
Queriable Binary XML Encoding
(Fred Mikkelsen) The format for binary XML is an extension of UTF-8 encoding. Starting with how UTF-8 is encoded, additional shadow formats are inserted to allow encoding primarily of integers and XML tag structure.
Intel Aims To Boost SOA With XML Solutions
(Kurt Mackie) Intel Corp. released a new software product suite that is designed to enhance the performance of XML in service-oriented architecture (SOA) environments, or other environments where XML handling needs optimization. Intel XML Software Suite 1.0, which was announced earlier this month, p
Creating AJAX Enabled Multi Keyword Database Search Engine
(Habiburahman Khaled) This article will show you how to develop a simple multi-column, multi-keyword, and multi option search engine; it can be used for any database driven application that requires search engine facility.