(Jan Stenberg) Many of the presumptions of how slow and resource-demanding “Fat” XML is compared to JSON’s lightweight payload do not hold up to a test David Lee, lead engineer at Marklogic, states after running an experiment with 33 different documents and almost 1200 tests on the most commonly use
Author: SSWUG Research
Using XML layout references in Android
(Lars Vogel) Android supports resource selectors based on qualifiers. For example to use a special layout file for activity_main.xml on a tablet in landscape mode you would typically define a layout file also called activity_main.xml in the layout-sw600-land folder.
Correlating XE query_hash and query_plan_hash to sys.dm_exec_query_stats in order to retrieve Execution plans for high Resource statements.
(Denzil Ribeiro) Extended events is a powerful feature that allows us to troubleshoot performance issues within SQL Server. One of the ways you can utilize extended events to aggregate statements is described in a blog post below by Bob Dorr SQL Server 2012: RML, XEvent Viewer and Distributed Replay
Eight Steps to Effective SQL Server Monitoring
(Tony Davis) A good DBA friend of mine recounted to me the tale of his first day at a new job. He received an Excel spreadsheet, containing a list of server names, color-coded according to their purpose or availability level, and a pager. That was it. All of these servers and their databases were no
SSWUGtv: How do you quantify goals with intangible goals?
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.
Understanding the WebSphere Application Server SAML Trust Association Interceptor
(Martin Lansche and Paul Glezen) Recent fixpacks to IBM WebSphere Application Server versions 7.0, 8.0 and 8.5 include a new SAML Trust Association Interceptor (TAI) that introduces new advanced single sign on capabilities. The TAI includes many properties, and understanding what these options do an
Function in JavaScript
(Ankur Mishra) All of us know that a function is a collection of statements executed when it is called at some point in a program.
SharePoint: A Program Management Office…in a Team Site
(Ellen van Aken) The risk of a set of projects, managed in different ways, is that the Program Manager has to chase everyone for updates, will receive these updates in various formats, and spends a lot of time turning these diverse bits of information into a proper report.
Check for Changes Between Collections with SequenceMatch
(Peter Vogel) You’d prefer not to execute any update code more often than you absolutely have to. If you only have one object to deal with, checking to see if an update is required is simple: retrieve the corresponding object from the database, check to see if the two objects have different values i
Materialized geometry_columns using Event Triggers
(Leo Hsu and Regina Obe) One of the big changes in PostGIS 2.0 was that the geometry_columns table became a read only view. This change was not without sacrifice. On the plus it meant a table no longer needed to be maintained which was a relief for those who had to constantly ensure the sideline tab

