(Bertrand Le Roy) I’m not very satisfied with traditional database backup solutions. It seems like almost no progress was made since SQL Server 6.5 (at least for the built-in tools).
Other News
Extending JavaScript Arrays While Keeping Native Bracket-Notation Functionality
(Ben Nadel) In JavaScript, we can sub-class native data types by extending the native prototypes. This works perfectly with the native String object; but, when it comes to native Arrays, things don’t work quite so nicely.
Waiting for table metadata lock and PECL/mysqlnd_ms
(Ulf Wendel) The MySQL administration SQL command SHOW PROCESSLIST may read “Waiting for table metadata lock” in its “State” column for a statement.
A Computed Column Defined with a User-Defined Function Might Impact Query Performance
(Kun Cheng) A computed column is computed from an expression that can use other columns in the same table. The expression can be a noncomputed column name, constant, function, and any combination of these connected by one or more operators, but the expression cannot be a subquery. A simple example o
SQL SERVER – Solution to Puzzle – Simulate LEAD() and LAG() without Using SQL Server 2012 Analytic Function
(Pinal Dave) Earlier I wrote a series on SQL Server Analytic Functions of SQL Server 2012. During the series to keep the learning maximum and having fun, we had few puzzles. One of the puzzle was simulating LEAD() and LAG() without using SQL Server 2012 Analytic Function.
Bitemporal modeling with InfoSphere Data Architect, Part 1: Modeling application period temporal requirement
(Balaji Kadambi and Rahul Jain) Industry regulations and competitive pressures are prompting IT departments to maintain more data for longer periods of time and to provide better ways for business users to analyze past, current, and future events. In order to achieve these goals, firms are developin
Legacy Tools
2012 Class Development Survey – Last Day to Get in When you complete our survey it helps us determine the content areas that are most important to you, as we will develop classes for our Expo next year. In exchange for your time, we are offering 25 free class registrations and/or DVDs at random to those who complete the survey […]
A Balanced Career
Incorporating jQuery into SharePoint 2010 Webcast – Starts Tomorrow On Wednesday, December 7th, you have the opportunity to participate in the SSWUG Webcast for jQuery in SharePoint 2010. What a great way to increase dynamic content display, and add interface enhancements. You’ll also see client-side script development improvements over MOSS 2007, using jQuery and the new ECMA scripting capabilities. Register […]
How do I read an attribute from an LDAP directory, and place it into a SAML Assertion?
(Mark O’Neill) Looking up user information from an LDAP directory is a common usage of the Vordel Gateway. Sometimes it’s used for Message Enrichment in front of an applications server.
How to Setup an XML Sitemap Video
(Total Bounty) The easiest way to get indexed in search engines (and determine which pages get indexed) is to setup an “XML Sitemap”.