Tal Olier

Tal Olier is married to Yael and father to Itai, Ori and Adi, he is also a database expert currently working for HP (originally Mercury Interactive acquired by HP). For the past 15+ years Tal held various positions in IT and R&D departments practicing programming, design and team management. For the last 10+ years Tal served as the system architect and a database authority inside an R&D core unit creating database methodology, solving database related dilemmas and helping developers extract the best out of the RDBMS world. While perusing his passion for database technologies Tal turned to teaching and co-founded yaeldana which specializes in “Database for Developers” teaching materials; in addition, Tal is sporadically publishing articles and consulting for companies in RDBMS related matters mainly related to design and performance. You can reach Tal at tal.olier@gmail.com and via http://www.linkedin.com/in/talolier.

Articles: 3

Temp Tables

Create SQL Server temporary tables with the correct collation

When we write code, we sometimes use temporary tables. Using a temporary table is a convenient way to store intermediate results, and then use them at a later phase in our application logic. When using temporary tables without specifying a collation (for

Tal Olier
July 6, 2011

Query Optimization

Lengthy SQL Server Queries Will Consume Your CPU

As far as data management and RDBMS rules are concerned, relational databases are the most adoptable way for maintaining data with a reasonable level of concurrency and while supporting data management activities such as backups, mass purges, changing dat

Tal Olier
May 16, 2008

Locking and Blocking

Using SQL Server Indexes to Bypass Locks

One way to get around SQL Server blocking is by using different indexes to cover the queries that may be running, learn how in this article.

Tal Olier
April 25, 2008