Find Communities by: Category | Product

To redefine means you have to deliver increased IT agility.  By implementing EMC technologies, customers just like you have redefined their IT environments - experiencing 5X faster deployments and 4X less staff time and driving the overall cost 3X lower.  What’s more – with EMC Converged solutions, the process is repeatable and heavily automated; the Microsoft application availability increased 83X.  EMC solutions include VCE, VBLOCK and VSPEX to deliver tried and tested solutions for Microsoft environments.

 

EMC’s infrastructure products, services, and integration points provide improved productivity, eliminate risk, transform IT and maximizes the customer IT investment for Microsoft applications and SQL Server environments. Businesses are facing new, tougher IT challenges, as their customers and end-users become more demanding.  Business customers running Microsoft applications now require greater access to data on more platforms for more hours of the day. Many businesses struggle to provide the solutions their customers want.  Not to worry…. EMC enables you to satisfy your Microsoft SQL Server requirements through innovative products, services, and support options that work together to create end-to-end solutions.

 

Check back often to learn how you can leverage the latest SQL Server functionality with robust EMC Infrastructure solutions Microsoft SQL Server and Applications Infrastructure Redefined.

 

 

Screen+Shot+2014-05-01+at+2.40.56+PM.png


EMC's SQL Server 2014 Story

The rapid evolution of the SQL Server platform means that customers will be looking to EMC to provide advice on the infrastructure to support SQL Server and the applications that run on top of it.  Here is what’s most likely to impact our conversations around SQL Server:

 

Apppppp.JPG.jpg

 

Self Service SQL Protection for DBAs

EMC's AppSync makes it easy for DBAs to manage protection of SQL Server databases, independent of the storage system. Learn more about how to provide SLA-driven, self service capabilities for maximizing and simplifying data protection and reliability.

 

 

sqlvid2.png

Why EMC for SQL Server 2012 Video

With explosive data growth for both structured and unstructured data types, customers need real time decision making and business intelligence with high performance and availability protection.  Watch this short video to learn how EMC provides comprehensive solutions to gain the maximum benefits of Microsoft SQL Server 2012.

 

 

 

EMC Solutions for SQL Server 2012

 

sqlsolutions.pngLearn how EMC technologies can assist a Microsoft SQL Server and infrastructure administrator through simple and easy to use management and protection of data. EMC tools such as Unisphere and EMC Storage Integrator (ESI) are demonstrated to highlight how easy it is to manage an EMC array in a Microsoft environment. EMC's AlwaysOn Availability Groups are highlighted to help ensure failover of SQL databases between SQL nodes. Finally, performance improvements can be realized through the use of EMC's FAST Cache including performance metrics highlighting the advantages of using EMC FAST Cache with a Microsoft SQL Server workload.

 

 

 

 

 

ESG.pngThis Enterprise Strategy Group (ESG) Whitepaper discusses the new features found in Microsoft SQL Server 2012 and key EMC technologies that assist SQL and infrastructure administrators for improved performance, scalability, data protection and services. Technologies discussed includes EMC VNX and VMAXe; Fully Automated Storage Tiering (FAST) including EMC FAST VP, FAST Cache and VFCache; Backup and Deduplication; AlwaysOn High Availability; and EMC Consulting Services for Business Intelligence (BI) and Microsoft SQL Server

 

 

 

 

 

multisiteDRsql.png

SQL Server 2012 AlwaysOn Availability Groups provide the flexibility to protect specific databases, individually or collectively, in either synchronous or asynchronous availability modes. These configurations allow SQL Server 2012 the ability to replicate data to a secondary replica over distance.

 

This solution clearly shows the ability of EMC FAST Cache to significantly boost performance of the VNX Series storage array. Testing shows how enabling FAST Cache on a heavily utilized storage pool not only alleviated pressure, but allowed the same storage pool to service over four times the I/O (from 11,500 IOPS to 50,000 IOPS), while returning incredibly low SQL Server datafile average latencies times of 3 ms and less for reads and writes. The ability of FAST Cache to automatically react to the changes in OLTP workload I/O patterns is an invaluable tool for administrators.

 

 

 

 

 

 

 

 

Alwayson.png

SQL Server AlwaysOn Availability

 

SQL Server 2012 introduces two high availability configurations as part of SQL Server AlwaysOn, which provides availability at either the application database or instance level:

  • AlwaysOn Failover Clustering
  • AlwaysOn Availability Groups

 

Visit this overview page to learn more about Microsoft's new high availability configurations and EMC's support and integration for Microsoft SQL Server AlwaysOn!

 

 

 

 

 

 

 

 

throughput.png

EMC FAST Cache with SQL Server 2012

 

The testing of this solution validated the ability of the VNX5700 storage array to support SQL Server 2012 in instances running OLTP-like workloads that generated over 50,000 IOPS.

 

 

 

 

 

 

 

Customer Success Stories

 

 

brainshark.pngLearn how EMC helps meet the performance needs for Brainshark’s cloud offering based on Microsoft SQL Server.
ha.pngThe world's largest collectibles auctioneer, Heritage Auctions uses EMC to enable dramatic gains in performance and scalability for Big Data using Microsoft SQL Server.
loomis.pngInternational cash handling leader Loomis uses EMC to help manage their rapid growth of mission-critical applications such as Microsoft SQL Server for data mining and Business Intelligence including significantly reducing backup windows.
ht.pngHawaii's leading communications provider brought in EMC Consulting to use Microsoft SQL Server Integration Services (SIIS) to stream performance data to a SQL Server Analysis Services cube and present the data in a dashboard using Microsoft SharePoint Portal.
crutch.pngEMC helps electronics retailer Crutchfield deploy key Microsoft applications such as Microsoft SQL Server in a Hyper-V based Private Cloud.
      edgenetlogo_footer.pngSoftware provider trust its Big Data business to EMC and Microsoft and manages terabytes of virtualized SQL Server databases.

 

 

Consulting

Overcoming the Barriers to Business Intelligence Success

ESG Research: EMC Consulting Big Data Advisory Service

Consulting Services for Microsoft SQL Server

Full list of Enterprise Information Management Consulting Offerings

 

 

More Information

Follow the Everything Microsoft at EMC Community for up to date discussions, documents and other information!

 

 

I was just asked if EMC Marketing had a competitive slide deck covering the differences between Windows File Services in Windows Server 2012R2 and the EMC File Portfolio of products.  Hmmm, I thought… What ARE the differences?  There are so many, I'm not sure where to start.  So let's do this: let's start with an old expression; "the mother of invention is necessity".  In this context, that means, "what was the initial set of requirements?"  Let's take a look at a potential list:

  1. Store "home" directories
  2. Store high-performance VHDx files in a Hyper-V Server Cluster
  3. Replicate advertising content (videos, PowerPoint docs, and graphics files used for placing ads in our magazines and web sites) to another site 120-miles away so they can use the unified file space
  4. Link a bunch of file servers together using DFS-R (Distributed File System - Replication) Services
  5. Store a single department's files in a single remote location
  6. Store user files so that they can access them on any mobile device anywhere in the world without using VPN

Ok… that's a diverse set of requirements.  So many use cases, but all of them using file servers to reach the goals.  What should we do?

Here's where it gets easy, but also gets interesting. By clearly defining what you need to accomplish, you can easily match needs to features or offerings.  For example: 1. Store Home Directories: how large are they?, are there capacity quotas?, are they scanned for corporate governance compliance (data that might contain credit card numbers)?, are the directories synchronized to laptops using My Documents redirection?  If all these are true, you may need the advanced features offered by an Isilon Scale Out file system. Check out Isilon Family - Big Data Storage, Scale-out NAS Storage - EMC

What about #2. Store high performance VHDx files for use in a Hyper-V Cluster?  Well, now we are in a completely different place, eh? All of a sudden we have concerns for performance, availability, clustering support, metadata handlers, snapshots, recoveries, potential replication concerns, we need to arrange VSS backups of individual files.  It's like we aren't talking about a file server anymore.  We are finding more and more customers clamoring for the advanced, scale-to-fit, extremely efficient, and trusted VNX Family - Unified Storage Hardware and Software for Midrange - EMC.

#3 - Replicated and shared file spaces have been a challenge for IT professionals since the dawn of IT.  Microsoft's Distributed File System Replication is an extremely evolved solution for highly specific use cases.  Sharing replicated file spaces is a tricky task, Windows Server 2012R2 delivers a unique and highly optimized set of tools to allow small sets a data to be replicated among sites efficiently.  There are complex setup steps, but Virtualizing your Windows File Servers can ease management headaches and reduce costs!  Our paper on Microsoft Private Clouds is great starting place for your journey. http://www.emc.com/collateral/whitepaper/h11228-management-integration-cloud-wp.pdf  Likewise, #4, specifically calls for DFS-R -- EMC technologies, when working WITH Microsoft technologies will lower costs, reduce downtime, reduce support issues, and allow you to reach your business goals faster.

#5 -- Store a single departments files in a single location? This is one of the requirements that can go in so many directions because it seems as if the requirement is simple.  The problem here is latent -- it doesn't present itself at first.  At first blush, you might think, "hey, no problem: stick a VM out at the remote office.  Back it up with Avamar - Backup and Recovery, Data Deduplication - EMC , and I'm done.  Maybe you are, maybe you're not.  What if the remote location has power issues, physical security issues, the staff constantly deletes files and needs point-in-time recoveries routinely?  The simple problem just consumed your week.  EMC knows that these little "ankle biter issues" are detailers for IT shops. Handling remote file usage has become the bane of so many IT shops and IT managers.  EMC sees that there is more to remote file access than placing a VM at a remote location; that's why we introduced leading technologies to assist you and your users get what they want when they want it.  My ol' pal Paul Galjan has posted an article to get you thinking about the possibilities: http://flippingbits.typepad.com/blog/2014/05/mobilize-sharepoint-with-syncplicity.html

#6.  Access anywhere files.  Oddly, sometimes Dropbox just isn't good enough.  That's why EMC launched Syncplicity.  Please take a moment to see all you can do for your increasing group of remote and mobile users. Features

The summary to all this is that File doesn't mean File Server anymore.  It means storage.  Every storage scenario is different and that's why EMC has a proud portfolio of offerings.  Not just services, not just products, not just software.  EMC has become the answer to an ever increasing number of questions and scenarios.  Thanks for reading.

Attractive and Collaborative Business Intelligence with Microsoft Power BI and SharePoint

Rafal Lukawiecki, Irland

 

Rafal Lukawiecki  delivered a an exceptional keynote on on BI and SharePoint with some impressive online demos using some of the tools on Microsoft Excel and also some of the new functionalities of Microsoft Office 365 and Microsoft Power BI

The main message is leverage BI for analyzing and processing data from multiple data sources, of course including SharePoint. We are involved in the data explosion and there is a transformation opportunity that it is ideal for technology and economics

 

The main purpose of Business analytics is extract knowledge from data, validate, simplify and visualize. Microsoft business analytics platform uses different tools to achieve this: Excel, Power BI and SharePoint and SQL Analytics Platform system PDW

The future of BI starts now using strategic hybrid cloud platforms to facilitate data processing and management Power BI SharePoint Online and Office 365 will help us to work in this environment.

 

Microsoft Power BI for Office 365 offers a collection of features to visualize, discover, process and manage data in a collaborative environment in your organization. Some of the Excel services available as Power Query, Power Pivot, Power View and Power Map along with new features as Power BI Sites, Power BI Windows Store App and Query and Data Management bring a complete collaborative online environment.

Screen Shot 2014-05-11 at 12.25.44 PM.png

I have attended to different sessions about Power BI and SharePoint Online with demos of collaboration between SharePoint and Yammer, creating reports after collecting and analyzing email data.

Very interesting to see how we can collect data from different tools like Twitter and how are processed, managed and visualized in a report for the final user using Analytics for Twitter and Office 2013.

analytics twitter.png

 


Making Sharepoint strategic delivered by Eric Riz, SharePoint MVP. Interesting vision about SharePoint as Enterprise System in an organization using as   productivity and collaboration tool.

 

Think about IT strategy in this transformation period, it is the key of a successful business application implementation. SharePoint is a pillar in your IT strategy but is not your strategy.

 

Meet with your internal departments and discuss business strategic with the application owners: HR, Marketing, IT, Business apps, etc..

 

  • Define your principles and goals
  • Create value for your business
  • Classify business information
  • Develop an education strategy
  • Develop an ongoing plan with metrics after your analysis

 

Defining and creating value for our business will be ono of the most important steps in our SharePoint implementations, we need to identify the pains, asks questions to the lead solutions, classify the needs and expectations and develop a success strategy. Setting metrics after our data content analysis based in the expectations will create impact in the results.

 

Data migration from On-Prem to the Cloud is not the answer, we have to analyze, and identify what are the most relevant data, if our data are not strategic, our SharePoint implementation will not be strategic.

Screen Shot 2014-05-11 at 12.28.32 PM.png

 

Communication is also very important in a strategic plan. We have a bunch of social tools that might help in create the value, analysis and process the relevant data content and communication.

 

  • Yammer
  • Twitter
  • LinkedIn
  • My Sites/Team Sites

Enterprise Social and Content Management

 

The topic for today has been Make Social successful, during the Keynote Christian Buckley, Metalogix,US and Mark Kashman, Microsoft, US have been delivering an interesting session talking about the Social value in our companies.

 

People, Collaboration and Technology make possible a successful Social environment, which increase productivity and reduce cost.

SharePoint and Yammer working in different scenarios: on-premises, in a cloud or in a hybrid environment facilitate our Enterprise Social Collaboration solution creating a social network in our company.

 

IT transformation brings new challenges and opportunities. IT has to drive the business process to increase revenue with advance innovation.

Social deployments are very important to improve our internal communications. Many companies are working to deploy different process internally to find the best influencers; this methodology brings the value of the best people using social collaboration technology in the internal network. Of course this can be used for external communication and enterprise collaboration.

 

They introduced the newest member of Office 365: codename Oslo and Office Graph that allows you to connect people, documents and conversations.

Oslo is a search solution that enables teams to work together as a network; you can see information that is associated with your current work and people in your work network.

Oslo highlights key information based in your work and the people in your work network.

 

With Oslo you can find everything in your network easily just typing the name of the person who was working on it.

oslo.png


What is New with SharePoint 2013 SP1

 

This Service Pack includes performance, reliability and security fixes. It also brings new features to help migrations to the cloud. It includes:

  • Hybrid connection to OneDrive for Business in Office 365
  • Support for Yammer
  • Support for JSON Light in OData v3 request

 

hybrid cloud.png

 

Files and content

 

Deliver lower TCO and increase agility with the flexibility of OneDrive and Sites to Office 365 while retaining on-premises investments

Simple coexistence

Redirect Ondrive Pro and Sites to Office 365

 

Social

SP1 will make easy for IT to replace Yammer newsfeed

Configure Yammer as social experience, easy configuration with SharePoint 2013 Central Administration

 

 

Tomorrow sessions for Solutions and Devices

With the growing trend of customers leveraging Windows Server 2012 Hyper V in the field, there is an expected corresponding trend in inquiries around data collection and identifying the performance requirements of Hyper V deployed on CSV targets.


At the time of this writing, the usual EMC SE reporting does not accurately report on the disk performance characteristics of CSV targets. The way these engagements typically go is:

  • PERFCOLLECT is collected from the Hyper V host
  • The  data is then uploaded for analysis
  • The report returned returns data only for the LOGICAL DISK counters identified in the PERFMON file (namely, the C: drive)

 

By golly, where is all that IO that I KNOW is there? The quick response is that there IS performance data in the collect. We are presently working to streamline the rendering that we are used to getting.


In the interim....

 

I am processing the BLG file collected via perfcollect using PAL (http://pal.codeplex.com/) – which will give  IOPS and response times. If you’d like to try, install PAL and open it. It’s wizard based. Point it at the PERFMON file and select the desired BLG file.

 

This will at least get us IOPS, read/write splits and the performance characteristics of the host in a pretty easy-to-read format. Probably something wrong with the way Mitrends is parsing the data – at least PAL will give us the state of the hosts.

 

Download and install PAL, and run it.

 

In the Counter Log page, browse to the BLG file in the PERFMON subfolder of the PERFCOLLECT data.

browsetothefile.gif

Then click Next.

 

Then select the Threshold File that you want to use. It has profiles for most of the Microsoft applications that PERFMON grabs counters for – in this case you are looking at a Microsoft Windows Server 2012 Hyper V host – so select that one.

PAL_Profile.gif

If you keep hitting Next through the rest of the Wizard it will start processing the BLG and generate an HTML report with alerts and data in a report. It works pretty nicely – and each area of the report explains what the counter MEANS in the context of the application selected in the Threshold File that you selected.

 

Physical Disk\Disk Transfers Per Sec

 

This is probably the best counter (for now) to estimate IOPS. Check queue depths to see if the workload is being met – if there are sustained queue depths there may be a choke point – either with HBA queue settings or the spindles are not meeting the load.

 

Physical Disks/Bytes per Sec will give you the throughput.


There is a fantastic reference for Hyper V Performance Guidelines available for download from Microsoft. Storage gets interesting at around page 65...


http://msdn.microsoft.com/en-us/library/windows/hardware/dn529133

 

Please remember that IOPS are CUMULATIVE for the cluster - capacity is NOT!

 

How are YOU doing it today for your Hyper V environment? Feedback and discussion is welcome - I would love to hear how the rest of the EMC Microsoft Community (customers, partners, and colleagues) is answering the call!


Cunningham's Law states: The best way to get the right answer on the internet is not by asking a question. It's to post the wrong answer!

I have been attending during this week (6-8 May 2014) to the European SharePoint Conference in Barcelona, Spain.

 

This is the largest European event covering Microsoft SharePoint, Microsoft Office 365 and other cloud and social technologies, it is a great opportunity to meet with different IT Professionals.

More than 1200 people coming from almost 50 countries, over 100 technical sessions, provided by 80 of the most expert and recognized speakers of the Worldwide SharePoint Community.

 

 

ESPC2.png

 

There are three main topics: Cloud and Microsoft Office 365 on Tuesday, Enterprise Social&Enterprise Management on Wednesday and Solution Devices on Thursday

 

During first day I have been attending to the Keynotes and different breakout sessions focus on SharePoint in the Cloud and Office 365.

 

Keynote. Simon Skaria, Microsoft Program Manager. He was talking about new capabilities and features of Office 365, SharePoint Online and OneDrive for Business.

They show some demos about Office 365 productivity and workflows using different devices as iPad and Windows Phone.

 

They highlighted some the new features of OneDrive

 

  • 1TB
  • Standalone Subscription
  • Office Online
  • Mobile Apps
  • Yammer integration
  • Sharing documents

 

 

Keynote. Dan Holme,MVP, IT Unity. He was presenting IT transformation, how everything is changing and how we have to adopt and transform to the new technologies. Migration plans and business decisions will be the key to have a successful transformation.

 

Moving to the Cloud bring us new opportunities and challenges:

 

  • Increase value and decrease risk
  • Define Business requirement
  • Governance and Compliance concerns
  • Lack of flexibility
  • Security
  • Data sovereignty
  • Data availability and data loss

 

 

This is one of the most interesting sessions I have been attending today.

 

SharePoint Online Vs On-Premise Vs Hosted Making the Right choice

Rene Modery, MVP, Switzerland

 

During this session we learned the benefits and drawbacks for the different platforms: On-line, On-Premises and Hosted SharePoint.

 

Moving to the Cloud will impact in our business, it is crucial to evaluate the risks and choose the right model depending our business and applications. Of course, IT will drive analyzing the current infrastructure and taking the next step to get the best flexible architecture reducing cost and improving the user experience.

 

We have mentioned before some of them but here we have a list of the most important concerns when we are moving to the Cloud.

 

  • Security
  • Availability
  • Stability
  • Compliance constrains
  • Accessible from anywhere from any devices
  • Governance
  • Simplicity
  • Low cost

 

Choosing the best model for our Business applications. Depending our business and applications we have to evaluate which model will fit with our requirements. Sometimes we are not migrating all the applications, we have to consider the business benefits moving to the Cloud

 

On-Premise

  • With great power comes great responsibility
  • Hardware and Software maintenance
  • Management
  • Big investment
  • Knowledge and skills

           

Hosted SharePoint

  • Low of upfront costs
  • Reliable
  • Perceived loss of security and control
  • Integration possible?
  • Still need internal resources for support the environment

 

Office 365

  • Innovate and flexible
  • Little control
  • Simple price model
  • Difficult governance
  • Security by MS

 

What should you look out for?

 

Functionality

  • Business requirement, think if your applications are in the right platform.
  • Respond business demands quickly

 

SLA

  • You must guarantee the required availability
  • Plan for disaster recovery
  • Which one is more likely to go off line, your own server or the cloud?

 

Security

  • You must to fulfill security requirements
  • In your data more security in-house than somewhere outside?

 

Company readiness

  • Can your company keep up with the pace of SharePoint Online?
  • Do you want to have complete control of your environment?
  • Do you have the internal knowledge to run or support the preferred environment

 

Consider Hybrid environment to keep legacy applications reduce costs, minimize maintenance efforts and leverage the latest technology from Microsoft.

Include IT and Business in your evaluation, prioritize your requirements and verify different options.

 

I will continue tomorrow with Enterprise Social and Enterprise Management sessions

Much has been written of Microsoft’s transformation, most recently the naming of Satya Nadella as the third CEO in Microsoft’s history.  In reality, the foundation for the most visible of these changes has been laid over the course of years.  You can look at the development focus and release pace over the last couple of SQL Server versions to see the effect the Microsoft transformation is having on their database product line:

 

Screen Shot 2014-05-01 at 2.40.56 PM.png

A quick look at this will show two features:

  1. The pace of development is far more aggressive.  It used to be somewhat sleepy – releases every 5 years, speeding to every 3 years at the middle of the decade, and now every two years.
  2. The releases are now far more audacious.  The enhancements between SQL 7 and SQL 2008 were evolutionary, but the improvements in SQL 2012 and 2014 are potentially revolutionary.  In two years, they’ve introduced several new forms of in-memory processing with ColumnStore and In-memory tables (Hekaton), a very nearly completely overhauled replication and HA mechanism, not to mention the adaptation of SQL Server into a truly cloud-oriented database platform.

The rapid evolution of the SQL Server platform means that customers will be looking to EMC to provide advice on the infrastructure to support SQL and the applications that run on top of it.  Here’s what’s most likely to impact our conversations around SQL Server:


In Memory Optimization

In-memory OLTP is one of the most impactful features in SQL 2014.  There’s tons of material out on the web for you to research.  The thing that jumps out to me is that it’s rarely referred to as an “in-memory database”. “Whole-hog” migration of a database to in-memory is going to be a very rare beast with SQL 2014.  Instead, tables and stored procedures are individually identified as candidates for in-memory optimization. 

This means that a high performance database (HPDB) will likely continue to require access to storage with predictably low latency to maintain performance, even while using in-memory tables and SPs to increase performance.  Look for some upcoming EMC white papers to guide you around the best practices for in-memory optimization on EMC infrastructure.


Buffer Pool Extension

This neat little feature in SQL 2014 allows administrators to leverage low latency persistent storage devices (usually flash) to extend the buffer pools available to SQL Server.  Using this feature means both increased performance in read-intensive workloads (write-intensive and DW workloads will have limited performance increases), as well as an improved achievable consolidation ratios – always a concern given the cost of licensing.  Look to XtremSF to enable this feature for EMC customers.


Resource Governor

This utility has been in SQL Server for some time now, but has become more critical to the operation of SQL in the context of cloud computing.  It’s not a full quality of service implementation, but it allows the DBA to limit resources that a database can consume.  In SQL 2014, the Governor has been extended to allow control of IOPs per volume.  Look for this feature to be implemented to reduce risk of performance issues in Database as a Service deployments.


Hybrid Cloud

Aside from the in-memory OLTP capabilities, Hybrid Cloud support is the most talked about new feature in SQL 2014.  This paper has a variety of different use cases and illustrates how easy Microsoft is making it to move SQL databases into Azure.  I think one of the most popular options will be the simple integration of AlwaysOn Availability Groups with Azure, allowing customers to run production on-premises, while a secondary used for disaster recovery, reporting, or both can reside in Azure.  As Microsoft does not charge for data ingestion, disaster recovery to Azure becomes a very inexpensive option.

 

Screen Shot 2014-05-01 at 4.45.44 PM.png

In this scenario being able to control things like backup and transaction logs on all copies becomes more interesting to customers  EMC DPAD customers will be happy to find that Avamar and Networker supports these scenarios.

 

Continued Consolidation pressure

With SQL Server 2012, Microsoft dropped the Server+CAL licensing option for SQL Server Enterprise edition, and it appears there will be no change for SQL 2014.  The silver lining in this policy is that the per-core licensing makes smart virtualization a viable method for controlling licensing costs.  If you plan out your deployment with an understanding of your resource needs and how SQL is licensed, you can use converged infrastructure like vBlock or VSPEX to minimize your licensing cost exposure.


More storage options

SQL 2012 introduced the ability to leverage direct attached storage while retaining high availability features (by leveraging AlwaysOn Availability Groups).  It also introduced the ability to storage SQL databases on SMB shares (in the same manner that Oracle DBAs may choose to leverage NFS). SQL 2014 introduces support for cluster shared volumes (CSVs) with block storage devices.  This will allow more manageable block environments, with faster failover between nodes.

To illustrate the difference between CSVs and traditional cluster disks, consider the following diagram showing the latter:

 

Screen Shot 2014-05-01 at 4.44.58 PM.png

In the figure above, we have a two node cluster with an active and passive node.  Only one of the nodes in the cluster can write to the NTFS volume at any given time.  The NTFS volume itself is part of the same cluster resource group that holds the SQL services.

 

Screen Shot 2014-05-01 at 4.45.14 PM.png

Contrast that with the cluster shared volume.  Both nodes have read and write access to files in the volume (although it’s important to remember SQL itself does not allow RAC-style multi-writer access to the same file).

Support for cluster shared volumes means failover will be faster, as the presentation of the LUN to the passive node does not need to happen as part of the process.  It also means that block storage for SQL Server becomes even simpler by divorcing the workload (database) from the LUN itself. It also means that solutions like SQL Server with VPLEX will become even easier to deploy.


Conclusion

We’ve only just scratched the surface with this brief overview, but it should be clear that EMC solutions continue to play a critical part in extracting the maximum value out of your investment in SQL Server.  Contact your local EMC account team to start a conversation.

From the Helm

EMC's SQL Server 2014 Story

 

Much has been written of Microsoft’s transformation, most recently the naming of Satya Nadella as the third CEO in Microsoft’s history.  In reality, the foundation for the most visible of these changes has been laid over the course of years.  You can look at the development focus and release pace over the last couple of SQL Server versions to see the effect the Microsoft transformation is having on their database product line:


CLICK HERE to read more


Paul Galjan - Microsoft Global Functional Lead at EMC

Technical Tools & Videos

EMC STORAGE INTEGRATOR for Windows Suite 3.1 (ESI) is now available
We are highlighting the many uses of ESI in the video series below.  View the release enhancements, if you missed the announcement. ESI, with a UI based on Microsoft Management Console (MMC), is available for download for use with any of your EMC storage products.

Use ESI to provision a SharePoint content database


Use ESI to provision an Exchange content database


Watch as ESI automatically discovers your Exchange Forest


See how ESI brings application & storage services together


Watch storage provisioning made easy with ESI


EMC Data Protection Suite:

What's new in Avamar 7.1:
Now supporting Microsoft SQL Server 2014 in Hybrid Cloud deployments plus 6 more great new features

 

What's new in Networker 8.2:

Read about all the Enhancements to Microsoft Data Protection Visibility and Control plus much more


XtremIO Webinar  Series

Register Now

Upcoming Events

May 15th - The True Test of an All Flash Array

May 29th - Expand your VDI Horizon

Customer Corner

Screen Shot 2014-05-01 at 2.01.41 PM.png

See how ALOM transformed their IT for SQL, SharePoint and other applications.

Analyst Corner

Screen Shot 2014-05-01 at 5.55.16 PM.png

Read the comments on Microsoft's SharePoint Conference 2014:  Work This Way

 

In the Pipeline 


Coming next month

Focus on the newly released VNXe 3200 in Microsoft Environments

Bloggers Corner

Ross Smith from Microsoft has received great feedback on this recent post on Microsoft's preferred architecture for Exchange Server.  Check it out.

 

 

Join Your Peers at EMC World 2014!
EMC World 2014 on now through May 8th in Las Vegas at the Venetian!  As data growth explodes, EMC creates the infrastructure that enables you to manage your business and your career.  Come to EMC World 2014 to participate in dozens of Microsoft specific sessions!

Join us May 5-8 in Las Vegas!
>>

tech_ed.JPG

Visit Microsoft TechEd
Microsoft TechEd is being held in  Houston, TX May 12-15Learn more >>

Filter Blog

By date:
By tag: