Microsoft SQL Server 2014 - Presented by Atidan
•
3 likes•2,538 views
SQL Server 2014 is the data platform for the modern business. SQL Server offers small and midsize organizations a fast, highly available database—and a cloud-ready data platform that will grow with your business. SQL Server 2014 dramatically speeds transactions with new in-memory capabilities. Cloud capabilities make it easy for your organization to choose where to deploy your applications—whether on-premises, in the cloud, or a combination of both. Now more than ever, Microsoft makes powerful database functionality available to small and midsize organizations with a range of performance enhancements in SQL Server 2014 Standard Edition. With new in-memory technology built in to SQL Server 2014 Enterprise Edition, transactions run an average of 10x faster on the same hardware. SQL Server 2014 also includes built-in capabilities to maximize uptime, helping ensure your database—and your business—are always running. With SQL Server, you get a proven business-class data platform you can rely on: it’s the world’s most widely used database, with millions of installations and 46% market share per IDC Unit Share.
Recommended
Recommended
More Related Content
More from David J Rosenthal
More from David J Rosenthal (20)
Recently uploaded
Recently uploaded (20)
Microsoft SQL Server 2014 - Presented by Atidan
- 1. SQL Server 2014 David J. Rosenthal CEO, Atidan November 21, 2014 Microsoft Technology Center, NYC ModernBiz
- 2. ModernBiz: Your path to the Modern Business SQL Server 2014 overview Key business solutions •Get the most out of your IT investment •Be prepared for the unexpected A great time to modernize your database Get started 2 Agenda
- 3. 3 ModernBiz Choose your own path to modern, with flexible, familiar, and trusted solutions for your business—desktop to mobile, server to cloud. Connect with customers Grow efficiently Safeguard your business Business anywhere Increase your sales Get the most out of your technology Be prepared for the unexpected Protect and control your data Work together easily Get yourwork done anywhere Understand your customer ModernBiz Adapt to change
- 4. 4 ModernBiz SQL Server 2014 offers a key component of the modern business Get faster application performance on your existing hardware Have the peace of mind that your business data is backed up in the cloud Increase your sales Get the most out of your technology Be prepared for the unexpected Protect and control your data Work together easily Get yourwork done anywhere Understand your customer Adapt to change ModernBiz
- 5. 5 SQL Server 2014 The data platform for the modern business. SQL Server offers small and midsize organizations a fast, highly available database—and a cloud-ready data platform that will grow with your business. SQL Server
- 6. 7 How much is database downtime costing your organization? A slow-performing or unavailable database can cause significant business challenges. Poor Productivity Lost Customers As your company grows, so do the demands on the databases that support core business functions Inventory Orderprocessing Customermanagement
- 7. SQL Server 2014 makes fast, highly-available database functionality affordable to any size of organization 8 Get a database that can keep up with your business today and tomorrow Speed up transactions without buying new hardware Keep your database up and running more of the time Trust SQL Server, the world’s most widely used database (IDC) Click hereto jump to a slide in the appendix with more technical information on this solution.
- 8. 10 Is your data backed up? You want to make sure your data lives on through system failures, yet effective backup often requires significant capital investment in hardware and backup media.
- 9. 11 Protect your data and keep your business up and running Click hereto jump to a slide in the appendix with more technical information on this solution. Automate database backups to minimize data loss Encrypt your backup files for added protection Restore to the cloud if on-site servers are down Get fast, easy backup for your database with SQL Server and Microsoft Azure
- 10. Avoid security and compliance risks and ensure continued compatibilityby upgrading today. SQL Server 2005 End of Extended Support is April 12, 2016. 12 Now is a great time to modernize your database
- 11. 13 SQL Server 2014 Feature Comparison FEATURES SQL Server2014 SQL Server2012 SQL Server 2008 R2 SQL Server 2008 Performance In-Memory OLTP* In-Memory ColumnStore* Buffer Pool Extension to SSDs Enhancedvirtualization support and Live Migration Availability Always On* Database Recovery Advisor Windows Server Core Support Security Transparent Data Encryption* Backup Encryption Support Enhanced Separation of Duties Cloud-Readiness Simplified Backup to Microsoft Azure Larger SQL Server VMs and memory sizes available in Microsoft Azure Gallery ofVM images in Microsoft Azure Management & Programmability Policy Based Management Distributed Replay *SQL Server Enterprise Edition only
- 12. modernbiz@Atidan.com 1-215-825-5045 14 Next steps Let us help you get the latest database technology to power your business!
- 13. Appendix
- 14. Case studies
- 15. 40 employees | Chemicals | www.jarchem.com Chemical company transforms business with all-in move to the latest Microsoft platform “We have the right tools in place so we can go and sell chemicals. We don’t think about computers – they just help us do our jobs better.” Art Hein, Managing Director, JARCHEM Industries, Inc. JARCHEM delayed an IT investment for many years, resulting in system conflicts, business slowdowns, and reduced capabilities. With Microsoft partner eMazzanti Technologies, JARCHEM updated PCs and servers to the latest Microsoft technologies including Windows 8.1, Windows Server 2012 R2 & Hyper V, Office 365 and SQL Server 2012. Now, everything “just works” and JARCHEM can focus on the business of delivering innovative chemicals to customers around the world. JARCHEM Industries Inc. Consistent, up-to-date software saves employees time from system startup to sharing documents Systems are automatically replicated off-site every 15 minutes for fast disaster recovery Mobile access including Remote Desktop Services means employees can work anywhere Fast, responsive technology helps JARCHEM maintain a customer service edge ModernBiz 17
- 16. Adapt to Change “As we welcome new franchise partners, it’s easy to fold them into Office 365 and get them up and running right away.” Tom Boyle, Director of IT, Sky Zone Unifies disparate products into one enterprise-grade solution that scales with the business Enables regional managers and franchisees to present a unified face to the world Simplifies licensing and management for streamlined user onboarding Integrated mobile access eliminates device management challenges 450 people | Recreation | www.skyzone.com The global success of their indoor trampoline park concept spurred rapid growth at Sky Zone, but their productivity tools couldn’t scale. They called on Microsoft partner CorpInfo to help them move to a unified cloud productivity solution: Office 365. The result: Sky Zone now has a reliable, integrated productivity platform that will grow with their needs no matter how big they get. Fun fitness pioneer keeps business bouncing forward 18
- 17. Legal firm sails through Hurricane Sandy with Windows Server IT at the Law Offices of Aaron I. Katsman couldn’t keep up with the firm’s growth. Slow performance and the need to frequently restart servers significantly reduced productivity. Microsoft partner WorkITsafe deployed Windows Server 2012, using Hyper-V to create virtual servers and desktop computers. They set up automatic backup and failover capabilities to guard against disaster. The result: During Hurricane Sandy, employees served customers from home – without even realizing they were using the failover system. “Our computers are our lifeline. When Hurricane Sandy hit, Hyper-V Replica saved our business.” Aaron I. Katsman, Owner, Law Offices of Aaron I. Katsman 30 employees | Law | www.katsmanlaw.com Be prepared for the unexpected Delivered uninterrupted customer service despite a natural disaster that could have impacted business continuity Increased IT agility and reduced costs with virtual servers desktops running on consolidated hardware Gained time to focus on growing the business by reducing IT hassles and improving system performance 19
- 18. Toole Design Group specializes in bicycle and pedestrian transportation consulting. With many small, regional offices located far from HQ and rapid growth, their IT solution –based on Google Apps and Linux –could not deliver the ease of collaboration and reliability they needed. With the help of District Computers, Toole Design Group moved to a system based on Office 365, Windows Server 2012 R2 and Microsoft Azure. The result: Specialists inside the company can work together no matter where they are located – at the click of a button. “We have a lot of passionate experts in different locations who want to connect with each other. We need our people to feel like they’re part of the larger team even if they’re an office of one. That’s what Microsoft technology delivers.” Ben Sigrist, GIS Coordinator, Toole Design Group Improved employee satisfaction and retention in branch offices by connecting individuals to the larger team Provided real-time document collaboration and sharing with consistent formatting across devices Enabled access to the same file structures and versions across all locations with DFSR replication Set the stage for further growth with a highly scalable solution Transportation consultancy connects experts company-wide with Microsoft solutions 60 employees | Transportation Consulting www.tooledesign.com Get your work done anywhere 20
- 19. SQL Server
- 20. 22 SQL Server 2014 Standard Edition Business-class data management Faster insights across your data Cloud on your terms Proven data platform Reliable availability Robust administration Security and compliance Easy on-ramp to the cloud On-demand cloud solutions Rich developer tools Operational reporting Analytical insight Integrated, consistent data
- 21. 23 SQL Server 2014 Standard Edition Performance SQL Server 2014 Standard Edition offers new performance enhancements to keep your database applications running fast, including: •Higher max memory allocation of 128 GB. •Extend buffer pool to non-volatile storage such as SSD (solid state drives) for even more memory with no risk of data loss. •Query planning enhancements aid in easy performance tuning. •Delayed Durability provides increased performance when disk I/O is slow. •Improvements to Full-Text Search and FILESTREAM offer dramatic performance and scale advances for building content management applications. Back to solution slide Availability Basic high availability for SMBs, including: •Database Mirroring •Log Shipping •Two-node Failover Clustering Support for Windows Server Core, which can reduce OS patching by as much as 50-60%1 1. The percentage reduction in patching varies and can be less based on the server roles that are enabled and the type of patches that are applied. Security Secure by Design Fewest vulnerabilities of any major database 5 years running Active Directory Authentication Enhanced Separation of Duty Basic Auditing and New Backup Encryption
- 22. Manual or automatic backups Enable backup directly to Microsoft Azure storage All you need is the URL and storage key At an instance level with point in time restore Measures DB usage patterns to set backup frequency 24 SQL Server 2014 Standard Edition Backup on Microsoft Azure Reduce CAPEX & OPEX with Cloud Backup On-Premises Network Azure Storage Domain Controller Periodic Snapshot (automatic/manual) SQL Server Microsoft Azure Restore to VM Geo Replication Back to solution slide
- 23. Mission critical performance Platform for hybrid cloud Faster insights from any data 25 SQL Server 2014 Enterprise Edition Overview
- 24. New In-Memory OLTP Enhanced In-Memory ColumnStore for DW In-Memory BI with PowerPivot Buffer Pool Extension to SSDs & Enhanced Query Processing SQL Server 2014 Enterprise Edition In-Memory Technologies Key Features Before 15,000requests/sec 16x FasterWith In-Memory 250,000requests/sec SQL Server 2014 with In-Memory Bwin Game Application Bwin Game Application Select only highly utilized tables to be in-memory Optimize in-memory to fit existing hardware Flexible On average 10x faster, without having rewrite entire app Leverage full SQL Server capabilities Built-in In-memory performance across OLTP, DW and BI All in a single SKU Spans All Workloads 26
- 25. Increased availability SQL Server 2014 Enterprise Edition Disaster Recovery on Microsoft Azure Multi-DB failover, manual or automatic Up to 8 secondary replicas 100% availability during all online operations HA without expensive SANs Offload reads and backups to secondaries Efficient Deployment and management wizards Monitoring dashboard within SSMS and System Center Easy to deploy and manage Unified HA/DR solution Primary Secondary 2 Running BI workloads Secondary 1 Running backups Synchronous data movement AG_Listener SQL Server 2014 Enhanced AlwaysOn Replica Wizard Windows Server 2012 R2 Clustered shared volume support Online VHDX support System Center 2012 R2 Manage on-premises and cloud apps Key features 27