With all this talk about Windows Azure, SQL Azure, Amazon services and moving to the cloud, I start thinking to myself this all sounds somewhat familiar. Not quite Déjà vu, but it feels a little like that. Back in 1998, That ’70s Show went on the air. It made what was old seem new again.…
Read More How Will Cloud Computing Affect You?Microsoft continued their support of PHP by releasing a Community Technology Preview for the SQL Server Driver for PHP 2.0. With this release PHP developer can use PHP Data Objects with the SQL Server driver! This will serve to reduce the complexity of targeting multiple databases on the back end. As I’ve noticed before, Business…
Read More Microsoft Continues to Support PHPI’d like to introduce you to the idea that you can replace an equal sub query with an exists sub query. Doing this can change a seek operation to a scan operation. This usually results in a faster query, with fewer resources used. Check out this example using the adventureworks database. USE AdventureWorks GO –…
Read More Equals Sub Queries Versus Exists Sub Queries