Showing posts with label SQL Server 2014. Show all posts
Showing posts with label SQL Server 2014. Show all posts
0

Short Review on Microsoft SQL Server 2014 Community Technology Preview 1

Posted by Danielle Smith on 20:20 in
Good afternoon everyone I hope you all had a great weekend!

So, carrying on from where I left off on Friday last week... I installed SQL Server 2014 on my home machine and seized the opportunity to investigate the software. Note that this is only a preview version, so really I am just going to give a general overview of how easy it was to install on my machine, what it was like to create/run simple queries in comparison to the performance in SQL 2012 and the overall experience.

Download and Installation

Downloading the installation package took just over 10 minutes, which is fairly reasonable considering the size of the download (around 3GB zipped). This was using a wireless Internet connection with speeds of up to 40Mbps. But please note that slower Internet connections will mean that the file will take longer to download.

As for the installation process, it was pretty much exactly the same as installing any other version of SQL Server. Steps and guides were there to help you configure the SQL Server instance correct for your machine. I must say though, for a junior, it can be quite difficult to install so make sure you read the help guide first. It took around 50 minutes to install in total from executing the package file (and that involved installing everything in the package).

Total Set Up Time: 1 hour 

Speed

I was experimenting last night and I did notice a difference in the speeds of even running my short queries. Unfortunately, I only had time to look at this for an hour or two, however I ran queries to:

  • Set up a new database.
  • Create 5 tables in 1 script with up to 10 columns in each. 
  • Inserted data into my tables (1 at a time). 
  • Updated data. 
  • Deleted an entire table with data contents. 

Hardly ground breaking stuff I know and these queries shouldn't take long to run on SQL 2012 anyway, however they were still remarkably quicker. This proves that the real-time database updates can be a This may not matter so much for smaller queries, however larger queries really will benefit.

Visually

Visually, SQL 2012 and SQL 2014 are pretty much identical! This is a good thing as I know where to find all of my tools, the new Visual Studio really confused me with the new commenting icon! A screen grab of the new version is shown below:


Overall

Overall, I am really impressed with the new version despite it only being a preview. I feel that the new version could potentially be ground breaking in terms of speed, as real-time data updates can be performed with the smaller queries that I used.

Personally, I feel that the new functionality could prove to be a winner for Microsoft. Watch this space!

As A Final Word...

Thanks everyone for reading today's blog post! If you have any questions/comments/feedback, please leave them in the comments section below and I will get back to you as soon as I can. Alternatively, please like my SQL Genius Facebook Page and leave a message on there. :)

0

Microsoft SQL Server 2014 Community Technology Preview 1

Posted by Danielle Smith on 12:30 in
Microsoft have released a preview of Microsoft SQL Server 2014, boasting a range of new features including in-memory data capabilities and easier methods of making your database suitable for the Cloud.

The main new features include:

Vastly Increased Performance (Using In-Memory)

In-Memory means that the entire database is stored within the server's working memory, rather than stored on the hard disk of a server. Why is this a benefit?
  • It's much quicker to INSERT, UPDATE and DELETE from data in the memory rather than data on the hard disk.  
  • Every single one of your database tables can have their performance increased without having to buy new expensive hardware. This increase in speed will bring way to "real-time" data management, where queries can be run in fractions of a millisecond.
  • Paging will be faster as the SQL Server in-memory buffer pool has been extended to include solid state drives, which also increases query performance.


Improved Reliability, Security and Scalability

Reliability

  • Enhanced AlwaysOn means that there will no longer be downtime during online indexing operations.

Security

  • It is now possible for the administrator of the database to maintain its contents without looking at personal and confidential data.

Scalability

  • A new tool called the Resource Governor provides a new way of evaluating query cost, which will make it easier to predict performance and therefore easier to predict performance as the database increases in size.
  • You can have up to 640 logical processors and 4TB of memory on a physical server.
  • You can have up to 64 virtual processors and 1TB of memory on a virtual machine. 

Cloud Capabilities

  • SQL Server 2014 uses a step by step wizard to makes it easier to migrate your database and application onto Windows Azure. 
  • Backups of your system can also be created and stored on the Cloud, even if the database itself is on a physical machine. 
  • Microsoft will also be providing support for moving to a Cloud based environment as well as a physical environment (seeing as trends show that more and more people are switching to the cloud as a way to store their data). 
For more information and to download the trial, take a look at the Microsoft website:

http://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspx

At A Glance...

Seeing as these are only the main announcements I've listed here in this blog post, it appears that the next release of SQL Server could be quite major. Some would argue that it's only been 14 months since 2012 was released, would it be too soon (and a waste of time and resources) to upgrade? Well if you're thinking of database scalability and especially moving to the cloud, it could be too early to tell but keep an eye on this release as I feel it may be beneficial.

What Next...

Over the weekend, I am going to install the 2014 CTP on my home computer and check out the new features. On Monday, I will write a short review on ease of installation, ease of use and give a quick low down on how positive my experience with the software was. Stay tuned!

As A Final Word...

Thank you for reading today's blog post! If you have any questions/comments/feedback, please leave them in the comments section below and I will get back to you as soon as I can. Alternatively, please like my SQL Genius Facebook Page and leave a message on there.

Have a great weekend everyone! :)

Copyright © 2009 SQL Genius - Personal Development of a Junior All rights reserved. Theme by Laptop Geek. | Bloggerized by FalconHive.