The script below (I called xxml) read (just one file, don’t work with meta characters), and show all lines inside specified.
Author: SSWUG Research
SCNs and Timestamps
(Gary Myers) The function ORA_ROWSCN returns an SCN from a row (or more commonly the block, unless ROWDEPENDENCIES has been used).
XSLT for creating a subject index
(Ben Chadwick) Today I’ve been doing some documentation, storing up my archives of knowledge. I decided to write it up in the structured format of XML.
Xp_readerrorlog in SQL Server 2012
(Nagaraj Venkatesan) I have always been a big fan of Xp_readerrorlog. The simple reason is that it much faster to read errorlog using the script compared to using SSMS. xp_readerrorlog gives more options to filter the log for specific dates or containing specific string etc
SQL Server JOIN Hints
(Derek Colley) You, as a SQL Server data professional, are looking for ways to improve your queries. You’ve done the usual – avoided cursors and loops, used locks effectively, examined execution plans – what else can you tweak?
Modeling created global temporary tables for DB2 with InfoSphere Data Architect 8.5, Part 1: Getting started
(Ajith Kumar Punnakula, Rahul Jain and Balaji Kadambi) Business applications commonly need to reuse aggregated or processed data from a set of data sources over a single series of operations. An example for this could be generation of reports for analysis and decision making. In order to support thi
SQL Server 2012 FileTable, My first experience
(Dan Kearney) A Line-Of-Business app, previously using SQL Server 2005, manages patient’s medical bills documents, as well as supporting and output documents related to the processing of those bills. Once a document is generated, no modifications are allowed, and only in rare cases is a delete allow
Find duplicate records in MySQL
To find duplicate records you can use GROUP BY and count on the attributes which you want to check for duplicates and use HAVING to select all records with a count greater then one:
Introducing MicroXML, Part 2: Process MicroXML with microxml-js
(Uche Ogbuji) MicroXML is a simplification of XML that is compatible with earlier versions. Part 1 of this two-article series covers the basic principles of MicroXML. MicroXML is designed with a straightforward grammar that can be processed with many modern general-purpose parsing tools.
AngularJS Abstractions: Controllers
(K. Scott Allen) In MVC web programming server side controllers are responsible for reacting to an external stimulus (an HTTP request), and then building a model and possibly rendering a view in response to the stimulus. In a client app with AngularJS, the controller has an easier job.