(Manish Kapoor) Recently in my project, I had a requirement to validate XML file against XSD schema file and list all validation errors. XSD (XML Schema Definition) is a way to specify metadata (schema, constraints, etc) about the xml data.
Other News
Bind Gridview using AJAX
(Nirav Prabtani) In this tip, I am going to write about binding of a gridview using Ajax post method.
12c: USE_SID_AS_SERVICE_listener_name
(Anju Garg) In an Oracle 12c container database, the client must specify a service name in order to connect to the PDB. Many Database clients with earlier releases of Oracle Database might have hard-coded connect descriptors to use SID to connect to the database. Now if they choose to plug in their
It’s All About CPU But There Is NO CPU Bottleneck! What?
(Craig Shallahamer) Diagnosing Oracle Database performance is like solving a puzzle. But what I really enjoy is coming up with performance solutions that are anti-intuitive for most people. You know, the ones when you can see people stop talking and actually think, “Why would Craig say that!?” In th
_single_process Initialization Parameter
(Andrew Reid) The _single_process initialization parameter allows you to start an instance in single process mode. As it begins with an underscore, you should only use it when Oracle tell you to.
Looking At How scope.$evalAsync() Affects Performance In AngularJS Directives
(Ben Nadel) In any JavaScript web application, one of the causes of user-perceived slowness can be unnecessary browser repaints. This got me thinking about AngularJS and about how directives are linked to the DOM (Document Object Model). I have seen (and have written) many directives that modify the
Templates Rock
There have been a few responses to the Code Generation editorial from the 17th of june. Most have emphasized the benefits of code generation as being useful. There were a few pitfalls, however. Developers were not maintaining their understanding of the layers of code that were automatically generated Custom modifications to the code were lost when classes were re-generated Sometimes […]
Maximum amount of memory to SQL Server is 8TB, is it really consuming 8TB?
(Dinesh Priyankara) “As per MSDN, the maximum memory can be consumed by SQL Server is 8TB, Will SQL Server surely use 8TB if the box is configured with 8TB?”. This was a question raised by an enthusiast.
Off-Box Copies of SQL Server Backups with RoboCopy
(Michael K. Campbell) In some ways, this post outlines a bit of what I’d call a poor man’s approach to getting copies of your backups off-box and to a secondary (or tertiary/etc.) location. And that’s because there are lots of great ways to do this in most cases, ranging from using the MIRROR TO cla
Automating Flat File SQL Server Imports With PowerShell
(Tim Smith) We’re looking to minimize ETL costs by importing as much data as possible using a automated system. A data provider sends us flat file data and we extract, analyze and report on these data. Due to our limited budget and time, how can we automate this?