(Eddie Awad) In his post titled learning foreign languages with Oracle SQL, Matthias Rogel shares the following query (I slightly modified and formatted it for clarity):
Other News
SQL Patch IV – Why is the SQL Patch applied but not effective?
(Dom Brooks) In a comment on one of my previous articles about SQL Patches, a reader (hurrah!) effectively asks the question “Why is my SQL Patch being applied but the hint not obeyed?”
To make a title about recursion, you’ve got to understand recursive titles.
(Scott Wesley) Recursion, that’s right, recursion, that’s right, recursion. Best I stop that…
SQL SERVER – Online Index Rebuilding Index Improvement in SQL Server 2012
(Pinal Dave) Have you ever faced a situation where you see something working but you feel it should not be working? Well, I had similar moments a few days ago. I knew that SQL Server 2008 supports online indexing.
SharePoint 2010: Connecting to SQL Server Using the External Content Type Feature
(Mahesh Sabnis) As a SharePoint 2010 developer, I have come across various requirements from clients on connecting to external data sources e.g. Direct Connectivity to Database, Windows Communication Service (WCF) and External .NET type from a SharePoint Web Site. By considering its need in portal d
How FLUSH TABLES WITH READ LOCK works with Innodb Tables
(Peter Zaitsev) Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In many cases the period for which server has to be made read only is very short, just few seconds, yet the impact of FLUSH TABLES WITH READ LOCK
ColdFusion 10 – Creating A Simple Expression Evaluator
(Ben Nadel) Yesterday, I was looking at ColdFusion 10’s native WebSocket filtering functionality. It uses the special data key, “selector,” as a way to define message filtering criteria. Last night, I started to think about how I could replicate this behavior in my WSApplication.cfc WebSocket proxy
IBM Cognos Proven Practices: Use Case: Tracking Down an IBM Cognos Power Cube Connection Issue
In this particular scenario, a support analyst is presented with a situation where all IBM Cognos Power cube data sources are failing after the IBM Cognos BI application was migrated from one physical server to another.
New FORMAT and CONCAT Functions in SQL Server 2012
(Ashish Kumar Mehta) SQL Server 2012, code named Denali, has new String functions such as FORMAT and CONCAT that can be used to perform an operation on a string input value and return a string or numeric value. In this tip we take a look at some basic examples of how this could be used.
Get Index Definition with Include Column List
Get Index Definition with Include Column List One of my favorite features added to SQL server was the ability to create indexes and have additional columns included in the index, not participating in the key values. This capability increases the capability of creating useful covering indexes. Because you can include columns not participating in the key of the index, you […]