(Ben Nadel) As I talked about last week, LAB.js is an asynchronous JavaScript loader that loads and executes remote scripts in an extremely efficient, non-blocking manner. With that efficiency, however, comes the complexity of working outside the “normal” top-down page flow of the document.
Other News
Update day to second interval column in selection from time gaps table by parsing strings containing time differences using REGEXP_SUBSTR
(Lucas Jellema) An apparently trivial challenge that still took me bit longer than expected. What is the situation: I have a table with two columns (of interest). One is a column called gap, with values like these:
SQL Server – Restore Full Database Backup from SSMS
(Paresh Prajapati) Everyone know about the database backup restoration. This is one need for every developer or DBA. I want to demonstrate here as we have a database backup and how can we restore it with Management Studio. Because somebody don’t the database backup restoration process with TSQL scri
SQL Server 2008 and 2008 R2 Integration Services – Analysis Services Processing Task
(Marcin Policht) The primary purpose of SQL Server 2008 Integration Services is to deliver extraction, transformation, and loading (ETL) functionality that supports core features of the SQL Server database management system.
BI For Environmental Reporting
(jmorourke) I’ve written before about the increasing use of EPM and BI tools for environmental and sustainability reporting. As organizations outgrow spreadsheet approaches to collecting and reporting environmental metrics they are looking to software vendors for special purpose tools, or extension
Securing the SQL Server Platform, Part 2
(Buck Woody) As I mentioned in the last tutorial in this series, security in the context of SQL Server deals with multiple areas including the physical access to the system, the operating system, the platform (SQL Server and its configuration), Principals (users) and Securables (database objects), a
Introducing Fulltext Statistical Semantic Search in SQL Server code name ‘Denali’ Release!
(Naveen Garg) We are very excited to introduce a new Statistical Semantic Search feature with Fulltext Search in Denali. With an optional new parameter ‘statistical_semantics’ you can now augment your Fulltext keywords index with two new indexes – one that captures top 100 statistically relevant wor
Using NULL as default values
(Shinguz) It is common practice in MySQL table design that fields are declared as NOT NULL but some non-sense DEFAULT values are specified for unknown field contents. In this article we show why this behavior is non optimal an why you should better declare a field to allow NULL values and use NULL v
Mainframe prospects are looking good today
(Willie Favero) It looks like IBM’s second quarter earnings were announced on July 18. If you missed them, you can read all the nitty-gritty details HERE.
Querying XML Files using XPATH in ASP.NET
(Vishal Gilbile) At times we need to access certain parts of xml file this concept can be done by using a special language known as XPATH. This article basically will help you to know about xpath and how to query and xml file so that we can read only certain parts of it.