Quoted in InfoWorld about Azure Storage

Posted · Add Comment

I got quoted in InfoWorld last week about Windows Azure Storage and how it relates to typical relational database development.  Here’s the link to the article: “Developing cloud apps: What’s different” by Paul Krill Also, if you haven’t seen it already, shortly after article came out, the SQL Server Data Services (SSDS) team announced a […]

Oracle For SQL Server Developers, Vol. 3

Posted · 1 Comment

Here’s another post in the Oracle For SQL Server Developers series (vol1, vol2).  The goal with this post is to help you get a feel for some common column data types in Oracle. Tip #16: Data Type Equivalents for Numbers SQL Server Oracle int NUMBER float, real NUMBER(precision, scale) In Oracle, a number can be […]

Oracle For SQL Server Developers, Vol. 2

Posted · 1 Comment

Here’s another post in my Oracle for SQL Server Developers series.  Tip #7: What is SQL*Plus and how do I connect to Oracle with SQL*Plus? SQL*Plus is a command-line client for talking to Oracle.  It’s similar to SQL Server’s sqlcmd.exe.  It’s usually installed in $ORACLE_HOMEBINsqlplus.exe so on my machine with a default install that path […]

Oracle For SQL Server Developers, Vol. 1

Posted · Add Comment

When I first started working with the Oracle database back in 2001, I remember how difficult it was to figure ANYTHING out.  I had plenty of experience managing SQL Server, designing databases with SQL Server, and implementing applications with SQL Server but getting even the most basic tasks done in Oracle was a major feat. […]

SQL Server Backup Command with a Variable

Posted · Add Comment

A few weeks back I blogged how to do CONTAINSTABLE() and FREETEXTTABLE() using SQL variables.  This weekend, I was working on creating a backup script for a client and ran into a similar problem where the SQL Server 2005 documentation says you can use a variable but it didn’t actually work because of a crucial missing […]