Tag: SQL

  • Quoted in InfoWorld about Azure Storage

    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

    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

    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

    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.…

  • Run Unit Tests With Automatic DBPro DB Deploy from a Team Build

    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 you…

  • SQL Server Backup Command with a Variable

    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…