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