NoSQL in Windows Azure

You may have questions like these – What are my NoSQL options in Windows Azure? Can I run MongoDB on linux on Windows Azure? Why would I want to do that? Which one of the NoSQL options are available as managed services? Are all kinds of NoSQL databases available? Are there any limitations? What are options for data analytics? Or may be you have questions like these – Is it true that NoSQL databases don’t have schema? Do they have indexes? What about Views? Should I choose MongoDB or Redis? What is eventual consistency?¬† In this presentation, you will learn all about NoSQL technologies in Windows Azure Cloud Platform. And you will get get answers to questions like these. Carolina […]

SQL Azure Notes

My¬†invitation code for SQL Azure CTP finally arrived. I had been waiting for this. You can create a database in from the SQL Azure Management page, shown above. After you have created the database, of course, you can use DbUpdater with your SQL Azure databases. Here is the command-line : DbUpdater.exe ..\SqlScripts /server:”tcp:SERVER.ctp.database.windows.net” /db:DATABASE /user:”USER@SERVER” /password:PASSWORD /confirm:true And you will need this DbUpdater.exe.config file : <?xml version=”1.0″ encoding=”utf-8″ ?> <configuration> <appSettings> <add key=”file-prefix” value=”db” /> <add key=”file-extension” value=”sql” /> <add key=”schema-versions-name” value=”schema-versions-table.sql” /> <add key=”baseline-name” value=”baseline.sql” /> <add key=”post-script-prefix” value=”post” /> <add key=”post-script-always-apply” value=”true” /> <add key=”exe-file” value=”C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE” /> <add key=”exe-args” value=’-U %UserName% -P %Password% -S “%ServerName%” -d %DbName% -i “%SqlFile%”‘ /> <add key=”dialect” value=”NHibernate.Dialect.MsSql2000Dialect” /> <add […]