The 3rd SQL PASS Keynote was given by David J. DeWitt of the Data and Storage Platform Division. IT was a brilliant insightful session.
The session started explaining the definitions of Big Data. It is a massive collection of records. To some, “Big Data” means using a new a NoSQL system like Hadoop and Map Reduce or the old traditional parallel relational DBMS to manage the data. Data is the currency of this generation with the realization that data is too valuable to delete.
NoSQL
Not Only SQL - It's about recognizing that for some problems other storage solutions are better suited. NoSQL has a flexible data model, faster time to deliver, relaxed consistency model such as eventually consistent, the willingness to trade consistency for availability, low upfront software costs. Some data is just not worth storing in a relational databases, validating, cleansing, ETL, analyzing or controlling the quality.
There are 2 types of NoSQL:
Key/Value Stores
Examples: Mongo, CouchBase, Cassandra, Windows Azure.
This is single value retrievals based on key - Think NoSQL OLTP.
Hadoop
This is large volumes of data stored in a distributed file system - Think NoSQL data warehousing.
SQL is sometimes termed 'schema first' and NoSQL 'schema later'.
The other idea that was presented throughout the session was the idea that
there are two universes in the new reality. Structured Vs Unstructured.
This is not a paradigm shift. The world has changed and the new reality is the RDBMS and NoSQL databases need to work together to address the current requirements in a complementary fashion.
The rest of the session went on to explain about Hadoop and its ecosystem and how the 2 technologies work together.
Hadoop = HDFS (file system store) + MapReduce (programing paradigm, process)
Some applications need data from both universes in the new world. Where this is the case Sqoop is used to connect the Unstructured (Hadoop) to Structured (RDBMS).
Chaos, complexity, curiosity and database systems. A place where research meets industry
Welcome
Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP
"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein
"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein
Showing posts with label SQL Server Denali. Show all posts
Showing posts with label SQL Server Denali. Show all posts
Friday, 14 October 2011
Wednesday, 12 October 2011
SQL Server 2012
The Day One Keynote Wednesday 12 October for SQL Pass keynote was given by Ted Kummert, Senior VP, Business Platform Division, Microsoft Corp PASS Summit 2011
The keypoints annouced were:-
The name for SQL Server Denali is SQL Server 2012.
SQL Server Data Tools is the name for Project Juneau. It brings a new paradigm for database development within the familiar toolset of Visual Studio for T-SQL development.
Power View is the name for Project Crescent. It provides an ad-hoc reporting tool for business users.
SQL Server 2012 is to support Hadoop. Oracle and EMC will also release a distribution of Hadoop and the Greenplum database and Hadoop will run on the same platform.
The Hive ODBC driver will be available next month
Data Explorer was announced. The Data Explorer tool allows you to browse data sources in the cloud. Has phases of discovery, enrichment and sharing. It can handle Big Data joining multiple data sets from say the cloud, excel, market place, sql etc.
The PASS Summit 2011 Live Keynote Streaming is
http://www.sqlpass.org/summit/2011/Live/LiveStreaming.aspx
Taken from the SQL Server UK Tech Days, the features include
The keypoints annouced were:-
The name for SQL Server Denali is SQL Server 2012.
SQL Server Data Tools is the name for Project Juneau. It brings a new paradigm for database development within the familiar toolset of Visual Studio for T-SQL development.
Power View is the name for Project Crescent. It provides an ad-hoc reporting tool for business users.
SQL Server 2012 is to support Hadoop. Oracle and EMC will also release a distribution of Hadoop and the Greenplum database and Hadoop will run on the same platform.
The Hive ODBC driver will be available next month
Data Explorer was announced. The Data Explorer tool allows you to browse data sources in the cloud. Has phases of discovery, enrichment and sharing. It can handle Big Data joining multiple data sets from say the cloud, excel, market place, sql etc.
The PASS Summit 2011 Live Keynote Streaming is
http://www.sqlpass.org/summit/2011/Live/LiveStreaming.aspx
Taken from the SQL Server UK Tech Days, the features include
Monday, 11 July 2011
SQL Denali links
Microsoft Tech Days UK 2011
A webcasts from uk tech days sharing details about Denali features
http://www.microsoft.com/showcase/en/gb/details/f3cf3282-efca-478c-bb74-cd3e588c4733
SQL Server Denali CTP3
Download at: http://technet.microsoft.com/en-gb/hh225126.aspx
SQL Server Denali Resource Center
http://msdn.microsoft.com/en-us/sqlserver/denali_resource_center.aspx
SQL Server Denali Upgrade Assistant
http://social.technet.microsoft.com/wiki/contents/articles/sql-server-upgrade-assistant-tool-for-denali.aspx
What's New (SQL Server Denali)
http://msdn.microsoft.com/en-us/library/bb500435%28v=SQL.110%29.aspx
A webcasts from uk tech days sharing details about Denali features
http://www.microsoft.com/showcase/en/gb/details/f3cf3282-efca-478c-bb74-cd3e588c4733
SQL Server Denali CTP3
Download at: http://technet.microsoft.com/en-gb/hh225126.aspx
SQL Server Denali Resource Center
http://msdn.microsoft.com/en-us/sqlserver/denali_resource_center.aspx
SQL Server Denali Upgrade Assistant
http://social.technet.microsoft.com/wiki/contents/articles/sql-server-upgrade-assistant-tool-for-denali.aspx
What's New (SQL Server Denali)
http://msdn.microsoft.com/en-us/library/bb500435%28v=SQL.110%29.aspx
Thursday, 11 November 2010
Denali - The next SQL version
The first CTP has been released for Denali, the next version of SQL Server, likely to be released to Manufacturing in 2012. Microsoft
SQL Server isn’t just a database, but an entire "information platform", stated Ted Kummert from Microsoft.
Denali will introduce holistic data integration and a management solution focusing on data with new Data Quality Services for knowledge-driven data cleansing and Impact Analysis and Lineage.
SQL Server AlwaysOn will provide a set of capabilities to help businesses maximize uptime of their mission critical applications and simplify high availability deployments.
This version will be the largest SQL Server Integration Services (SSIS) release.
Microsoft codename Atlanta is a secure cloud service that proactively monitors your Microsoft SQL Server deployments. It will capture configuration information that may later be required for troubleshooting and allow tracking of changes nightly.
SQL Server 2008 R2 Parallel Data Warehouse was also just launched.
SQL Server isn’t just a database, but an entire "information platform", stated Ted Kummert from Microsoft.
Denali will introduce holistic data integration and a management solution focusing on data with new Data Quality Services for knowledge-driven data cleansing and Impact Analysis and Lineage.
SQL Server AlwaysOn will provide a set of capabilities to help businesses maximize uptime of their mission critical applications and simplify high availability deployments.
This version will be the largest SQL Server Integration Services (SSIS) release.
Microsoft codename Atlanta is a secure cloud service that proactively monitors your Microsoft SQL Server deployments. It will capture configuration information that may later be required for troubleshooting and allow tracking of changes nightly.
SQL Server 2008 R2 Parallel Data Warehouse was also just launched.
Subscribe to:
Posts (Atom)

