Windows Azure and SQL DB materials–curriculum and development

I just saw that some new Curriculum materials for Windows Azure and SQL Databases in the Faculty Connection – those are great resources for helping with teaching students, especially since no knowledge of Cloud Computing is required. Windows Azure and SQL Database Windows Azure and SQL Database (Instructor Supplement) It’s also good to see all…

0

SQL Server 2012 FILETABLE for managing data in scientific, heterogeneous, idiosyncratic computing environments

The FILETABLE feature, available in SQL Server 2012, solves a problem that has bedeviled our research group for years. It is especially useful for people who combine SQL Server for data management with other tools (e.g., MATLAB, Python, R, C code) for data analysis and modeling. Problem: Our work combines remote sensing with climate and…

0

Science Analytics – look to use Project “Gemini”

When I first saw and heard details about Project “Gemini”, I was blown away by the technology and innovation created by SQL and Excel teams and that held up when I was able to test it out on my own.  It will be especially useful for scientists that want to not only analyze large amounts…

0

Project Trident: A Scientific Workflow Workbench available for download

Project Trident CTP is now available for download.  Project Trident is a scientific workflow workbench MSR External Research has been working on for the past few years, which allows scientists to analyze large, diverse datasets.  It’s built on Windows Workflow and utilizes SQL Server (Express or Server).  Download it and try it out… Project Trident…

2

Graywulf Takes Byte Out of Data Overload

Graywulf is the natural evolution of Beowulf Clusters – it brings together HPC clusters and databases to do efficient processing and data management.  It’s name and design also pays homage to Jim Gray – who helped  champion the use of relational databases in the scientific projects. At it’s simplest form Graywulf is having a database…

0

OLAP and Scientific Data

While I’ve been pushing the ideas of using OLAP data cubes to evaluate scientific data for awhile, I thought it might be a good time to pull together some relevant papers and links. I believe OLAP is ideal to help analyze large quantities of data including time series information…making it easier for the scientist/researcher to…

1

SQL Server 2005 Driver for PHP – Released

PHP developers can now integrate data from SQL Server now that the driver is available for download.  Also glad to see that it works with SQL Server Express edition. It is my pleasure to announce that version 1.0 of the Microsoft SQL Server 2005 Driver for PHP has released!  This release marks another step in…

0

Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet

Always looking for interesting papers that educate you on domains – really enjoyed this paper… Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet SQL Server Technical Article Writers: Isaac Kunen Summary: This paper is an introduction to Earth-oriented coordinate systems, projections, models, and mapping. While not specific to any technology, this information…

0

[Papers] Supporting Finite Element Analysis with a Relational Database Backend; There is Life beyond Files

In a discussion I had today around ways to advance a scientific problem I was reminded of Jim Gray and Gerd Heber’s trilogy – Supporting Finite Element Analysis with a Relational Database Backend.  The three papers are really a good resource for understanding how databases can be used in scientific challenges. Part I: There is…

1

SQL Server 2008 info

The latest version of TechNet Flash has some good pointers to details on SQL Server 2008 and the CTP available for download.  Some of the things scientists might find interesting are: Language Integrated Query (LINQ) enables developers to issue queries against data by using a managed programming language such as C# or Visual Basic.NET, instead…

0