(Naufel Basheer) In this tip, I’m explaining how we can convert XML into an object using XML Serialization.
Other News
Oradebug hanganalyze with a prelim connection and ‘ERROR: Can not perform hang analysis dump without a process state object and a session state object.’
(Tanel Poder) Back in the (really) old days, systemstate dumps had to be used for diagnosing hangs and finding blockers of hung databases. Basically you just identified which resource your waiting sessions were waiting for and then scanned through the rest of the system state dump to see which sessi
Select XML Nodes Into IXMLNodeList Using XPath In Delphi’s XmlDom
(Zarko Gajic) XPath is a language for addressing, searching, and matching pieces of (an XML) document.
Using ImagePunch() And ImageIntersect() With ColdFusion
(Ben Nadel) Earlier today, Evagoras Charalambous asked me about cropping a ColdFusion image on a diagonal. Cropping wasn’t really what he wanted; but, since ColdFusion’s list of native image functions doesn’t have some advanced functionality, “cropping” is the terminology we’re most comfortable with
Download free DB2 Express-C 10.1 database with NoSQL, RDF, and Time Travel Query
A major new release of the free edition of the IBM DB2 database is now available for download. DB2 Express-C 10.1 comes with Time Travel Query for improved historical reporting as well as SPARQL and an RDF triplestore for NoSQL data storage.
Create MySQL Databases and Tables from a PowerShell Script
(Rob Gravelle) There are times when you need to create databases and tables from a batch file. Whether it’s part of an automated application deployment, or you need to repeat the process on many workstations, a batch process is usually the easiest and fastest solution available. Since the emergence
Improvement to Keyboard Shortcuts in SQL Server 2012 Management Studio
(Ashish Kumar Mehta) A new feature in SQL Server 2012, code named Denali, is the ability to reset keyboard shortcuts in SQL Server Management Studio to match Visual Studio 2010. In this tip we will take a look at how easily you can change keyboard shortcuts in SQL Server Management Studio using the
Final CLR Response
Final CLR Response Today one of our readers digs into a topic I connect with every once in a while regarding the role of your database server. The key question is, “what kinds of roles do you want your database server performing?” As I work with larger and larger databases, my tendency is to put the least amount of extraneous […]
Installing SQL Server Express 2012 and managing the LocalDB
Introduction Sql Server Express 2012 the latest free version of SQL Server from Microsoft has five options of download from a small foot print version (SQL Express 2012 LocalDB or simply LocalDB) to the full version with all bells and whistles. The product comes in both (32 bit) and (x64bit) versions in several European and Asian Languages. LocalDB, an embeddable...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
IOT Secondary Indexes – The Logical ROWID Guess Component Part II (Move On)
(Richard Foote) Having mentioned a couple of dangers associated with IOT Secondary Indexes, thought I might discuss a couple of their nicer attributes.