Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 of data...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: [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...
  • Blog Post: 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...
  • Blog Post: Data Mining Virtual Hands-on Lab Now Available!

    I wrote about the Data mining Addins previously - Data Mining for the rest of us... and now you can test it out via the Virtual hands-ons lab...glad to see this post by JamieMac... Data Mining Virtual Hands-on Lab Now Available! For those of you who have been dying to try out the data mining addins we...
  • Blog Post: Galaxy Zoo - Help classify a million galaxies

    Thanks to Alex Szalay (JHU) for pointing me to GalaxyZoo - now you can help classify galaxies. This really neat... Welcome to GalaxyZoo , the project which harnesses the power of the internet - and your brain - to classify a million galaxies. By taking part, you'll not only be contributing to scientific...
  • Blog Post: Reporting@Home: Delivering Dynamic Graphical Feedback in Community Computing Projects

    I meant to do an entry on this paper by Stuart Ozer (MSR) and David Kim & David Baker ( Rosetta@Home ) months ago...it's a great way to integrate SQL Reporting services w/ something like Rosetta@Home, and provide really great service for not only the community users - but also for the researchers...
  • Blog Post: Virtual Labs - giving away a Camera

    Just saw that the Virtual Labs folks are giving away a camera for using the labs... I'd recommend the Business Intelligence: Excel 2007 PivotTables and Analysis Services Creating a Distributed Application with C# Introducing Content Types for Microsoft Windows SharePoint Services 3.0 Automating Windows...
  • Blog Post: Dynameomics - Protein folds by Molecular Dynamics Simulation

    Valerie Daggett and her team at UW have put up a site with their simulations of over 300 proteins for a combined simulation time of more than 35 microseconds. This site contains information for their top 30 targets. The other interesting part is that they have built this using SQL Server and use SQL...
  • Blog Post: Data Mining Addins for Office 2007 (Excel & Visio)

    I think of the Data Mining Addins for Excel 2007 , as data mining tools for common man - they allow anyone to use SQL Server Analysis Services without having to know how to program the backend. It allows you to look for Key Influencers, Detect Categories, Highlight Exceptions, etc. This can be a real...
  • Blog Post: SQL Server Starter Data Schema

    Very cool - it would be great to see some scientific reserach schemas added to the list... SQL Server 2005 Express Data Schemas Deploying SQL Server Express in real-world environments This data schema series is designed for new database administrators and enthusiasts to quickly get started learning the...
  • Blog Post: SQL Server Data Mining Add-ins for Office 2007 CTP

    So glad to see the CTP of Data Mining Add-ins available - I see this is as Data Mining for the rest of us... Microsoft SQL Server 2005 Data Mining Add-ins for Office 2007 (Data Mining Add-ins) allow you take advantage of SQL Server 2005 predictive analytics in Office Excel 2007 and Office Visio 2007...
  • Blog Post: Mundie: Science as a Web Service

    I realized I forgot to post about Craig Mundie's article in the March/April Technology Review - Science as a Web Service XML can supercharge research. <...> XML is also one of the enabling technologies for grid computing and Web services, which will revolutionize the scientific community in the...
  • Blog Post: Sim Water at UC Berkeley using OLAP cubes

    I really like to see this collaboration between the researchers at UC Berkeley and Catharine van Ingen from MSR's eScience group - they are using data mining and cubes to help with the scientific research. This is really neat stuff... SIM WATER Environmental science has enjoyed an explosion in data collection...
  • Blog Post: Data Mining for the rest of us...

    If you've ever been interested in using datamining tools - but don't have the time to figure out how it all works...take a look at these add-ins for the Excel2007. With the data in a spreadsheet - you can kick off an analysis. I can see this a great way to clean and analyze data...especially scientific...
Page 1 of 1 (21 items)