(Marko Sutic) In this post I will describe how to change Oracle SID using utility DBNEWID. As I can see DBNEWID is available from 9i version but I’ve never heard about it. Till now, I have used procedure where I’m manually editing and re-creating control file.
Author: SSWUG Research
Unpack an Integer with SQL Server Recursion
(Frank Solomon) Starting with SQL Server 2005, developers have had recursion available as a T-SQL language feature. This article will describe recursion and its SQL Server implementations, complete with examples. It will also include SQL Server functions and a stored procedure that unpacks, or parse
Encrypting and Decrypting application config sections
(David Giard) The .NET Framework provides configuration files – app.config and web.config – to store application-wide configurable information.
Looking At Prototypal Inheritance To Determine Data Types In JavaScript
(Ben Nadel) Yesterday, I was working on some JavaScript that needed to execute slightly different actions when a given value was either an Object or an Array. Typically for this, I would use something like Underscore.js or Lodash.js, which converts the value to a String and looks at the result; but,
Introducing EclipseLink JPA-RS
(Blaise Doughan) In a previous series of posts I covered how to create a JAX-RS service that leveraged JPA for the persistence layer. EclipseLink contains a component called JPA-RS that can be used to easily and automatically expose a persistence unit as RESTful service (that supports XML and JSON
Get your JavaScript in order
(Mike Byrne) In my last article, back in August 2011, I discussed a method I use to modularise CSS in a website build. In this follow up I’ll introduce a means of modularising your JavaScript to make it easier for you and your teams to develop and maintain.
SSWUGtv: How do you talk yourself out of your dream job, and why shouldn’t you do that?
Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.
Blocking SQL Server db_datareader, db_datawriter, and db_owner Permisions
(K. Brian Kelley) I’m in a dilemma. In a database I currently support, the application makes use of db_datareader and db_datawriter to give permissions to the tables. In a different database, it’s even worse as the application uses db_owner. We’re adding new tables to both databases and we don’t wan
Advanced security hardening in WebSphere Application Server V7, V8 and V8.5, Part 2: Advanced security considerations
(Martin Lansche and Keys Botzum) Security consists of more than just some firewalls at the edge of your network protecting you from the outside. It is a difficult and complex set of actions and procedures that strive to strengthen your systems as much as is appropriate. Part 1 of this two-part artic
How to Map a Document Library in My Computer
(Alexandru Dionisie) Before we start, you should know that I wasn’t able to get this working in Windows XP. It only worked in Windows 7.