Posts Currently viewing the tag: "SQL"

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…(Read More)

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…(Read More)

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…(Read More)

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…(Read More)

This time I’m genuinely surprised that no one has tackled this and posted it on a blog or to the DBPro or Team System forums. When you add a unit test for a stored procedure in Visual Studio Team System for Database Professionals (DBPro) for the first time, you get the dialog asking how…(Read More)

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…(Read More)