(Corrie Haffly) This article is not going to go through the details of making your own master page, as there are plenty of resources on creating custom master pages in SharePoint 2010. Instead I’ll cover what you need to know to successfully create a themable master page.
Author: SSWUG Research
MySQL Cursors and Loops
(Rob Gravelle) A loop is a programming construct that executes a block of code repeatedly based on a condition. Cursors, on the other hand, are utilized to process each row returned by a SELECT statement. In today’s article, we’ll be learning about various loop types supported by MySQL as well as g
SQL SERVER – The Story of a Lesser Known Startup Parameter in SQL Server
(Balmukund Lakhani) During my last session in SQL Bangalore User Group (Facebook) meeting, I was lucky enough to deliver a session on SQL Server Startup issue. The name of the session was “SQL Engine Starting Trouble – How to start?” From the feedback, I realized that one of the “not well known” sta
Simple Unit Tests With AngularJS
(K. Scott Allen) One of the benefits of using AngularJS is the ability to unit test the JavaScript code in a complex application. Unit testing is incredibly easy for trivial cases when controllers and models are declared in global scope. However unit testing is slightly more challenging for objects
Changing DB2 database pagesize
(Jack Vamvas) Question: Analysing an application stack trace , I noticed references to the database pagesize. What is the DB2 database pagesize and how can I change the pagesize value?
Slowly Changing Dimensions (Type 2) and Historical Facts-Part 1
(Jeffrey McDaniel) This is going to be a two part series. In part 1 we’ll cover what is a SCD (slowly changing dimension) and how is that determined in the P6 Reporting Database. In a future blog part 2 will cover from the database side how to determine which is the most up to date row, and how to
Using DBMS_XPLAN to display Cursor Plans for a SQL in all RAC nodes
(Carlos Sierra) Just sharing a lightweight script that uses DBMS_XPLAN.DISPLAY_CURSOR to display Execution Plans for a given SQL_ID out of all RAC nodes. Nothing fancy, just a workaround to the lack of “instance” parameter on this API.
Data Security: What Does it Mean to You, to Your Customer, to Your Auditor and to DB2?
(Kurt Struyf) Next to performance and new features, the topic of security and security improvements might not be flashy. That doesn’t mean it shouldn’t be important to a database administrator. Determining who has and maybe more importantly, who does not have access to data, is vital to the integrit
Mini-Icon Settings Menu with the jQuery Toolbar Plugin
(Jake Rocheleau) Some dynamic user profile layouts have been implementing more complicated JavaScript features. Notably the dropdown settings menu has been a staple of social networking websites. This is a great method for allowing easy access to updating the user profile, or even posting new conten
Serializing XML nodes in XSL
(Steve Anderson) Using XSL as a templating engine for projects is something that I’d like to think has disappeared, in favour of things like Twig and Smarty that can do the job a lot better.