t-sql
SQL Azure Incompatibilities list
While 99% of what you do in SQL is supported in SQL Azure, there is a small list of things you'll have to redesign, or at least reconsider before implementing
sql
t-sql
SQL Azure DATETIME Functions
Microsoft SQL has always included a number of date and time functions. These results of these functions were always based on the operating system for the
Posted in: Microsoft SQL
SQL 102-SELECT * Overhead
How many of you have heard me rant against using "SELECT * FROM tableName"? If you have I'm sure you've heard me mention the following reasons why SELECT * is
sql
Microsoft SQL Azure FAQ
I was searching for news on Microsoft SQL Azure when I cam across this new FAQ. It answers a lot of the questions you may have, and several that I hadn't
microsoft sql
What is SQL Azure?
I've been getting this question or some variant of it for weeks now. Some people are confusing SQL Azure with SQL 2008 R2, and some are thinking it's SQL 2010.
dev
Equals Sub Queries Versus Exists Sub Queries
I'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
t-sql
Microsoft SQL Reporting Services for PHP
In an outstanding move on Microsoft's part, Developers have released an open-source project to help PHP developers integrate SQL Server Reporting Services from
microsoft sql
Azure Tables or SQL Azure?
I'm beginning to see questions come up over which should I use, SQL Azure or Azure Table Services? The answer for now seems to be, it depends. Azure
t-sql
Introducing Microsoft SQL Server 2008 R2 eBook
With the release of SQL 2008 R2 (Artoo), there's plenty to learn in order to upgrade your skills. Microsoft Press has released a free eBook that can help you
microsoft sql
Sorting Numbers in VarChar field
Over at Experts-Exchange, I saw a question I get every once in a while. It all has to do with how SQL Server orders data in a VARCHAR column. SQL Server
microsoft sql
Migrating Databases to Azure
When converting a database from an older version of Microsoft SQL to Azure, there will be many gotchas along the way. I'd like to help you learn from the
microsoft sql
SQL Injection License Plate
While it would be nice to put my knowledge of SQL to work in such a way, I highly doubt this injection attack would do much to prevent getting a