Realizing value from my BI technology Microsoft
Create strategic applications using high performance of in-memory technology OLTP, storage (datawarehouse) data, business intelligence tools and analyzes. SQL Server 2014 uses a current set of tools for deploying and database management both locally and in the cloud.
WHY WORKING WITH LINTAO ON MICROSOFT SQL SERVER
- Unique business expertise in 25+ domains
- Excellent knowledge integrating data with the leading ERPs
- Unique skills in data modeling
- Numerous experiences in building complex ETL flows
- Reknown expertise in creating datawarehousing / data marts
- 20+ years experience delivering business intelligence projects
MICROSOFT SQL SERVER KEY FEATURES
Datawarehouse in the cloud
Microsoft Azure SQL Data Warehouse is a complete cloud-based BI suite based on Microsoft technology allowing to create and deploy datawarehouses within very short time-frame.
OLTP Database engine
SQL Server is an easy-to-administrate database
Microsoft Analysis Services allows you to create analytical cubes to store your business performance
ETL data flows
Microsoft Integration Services enables data ETL services
Power Pivot is a great tool for gathering together data from disparate sources and combining it into a single model for analysis.
Power Query is the solution to discover data and use more advanced techniques for transforming data.
Power BI for Office 365 is a new business-intelligence (BI) solution that extends the self-service BI capabilities in Excel. Power BI enables users to share their work in the cloud while maintaining a secure connection to on-premises and cloud-based data sources and allows users to interact with reports in a browser or on a mobile device by accessing a common repository hosted in a special SharePoint site dedicated to Power BI. Users can even designate favorite reports to more easily find the reports they need most often and can get answers from their data by asking natural-language questions
HDInsight is a Hadoop-based platform that you can use to process data of all kinds in the cloud. In particular, HDInsight is useful for processing high volumes of structured and unstructured data, which traditional relational database systems typically cannot support for a variety of reasons. HDInsight allows you to quickly establish an infrastructure for big data analysis, whether you want to develop a proof of concept for a big data solution or support ongoing analytical requirements in a production environment. Furthermore, HDInsight integrates with Microsoft’s business-intelligence tools to enable users to enhance big data with additional sources and then explore and analyze the results to gain deeper insights.
PolyBase provides an interface that allows you to work with data stored in HDFS by using SQL syntax in PDW queries—in a manner similar to querying a linked server from SQL Server—rather than MapReduce jobs. You can even use PolyBase to join relational data in PDW with data in HDFS. In addition, you can use PolyBase to move data from PDW to HDFS or vice versa. Furthermore, you can use Power Query or Power Pivot to connect to PDW and use PolyBase to import data from HDFS into Excel.
SQL SERVER 2016 NEW FEATURES
Enhanced in-memory performance
provides up to 30x faster transactions, more than 100x faster queries than disk-based relational databases and real-time operational analytics
New Always Encrypted technology
helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without application changes
Stretch Database technology
keeps more of your customers’ historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure in a secure manner without application changes
Built-in advanced analytics
provide the scalability and performance benefits of building and running your advanced analytics algorithms directly in the core SQL Server transactional database
Business insights through rich visualizations
on mobile devices with native apps for Windows, iOS and Android
of relational and nonrelational data by querying both with T-SQL using PolyBase
Faster hybrid backups, high-availability and disaster
to back up and restore your onpremises databases to Microsoft Azure and place your SQL Server AlwaysOn secondaries in Azure
SQL Server Editions
SQL Server is available in three principal editions. All three editions have tighter alignment than their predecessors and were designed to meet the needs of almost any customer. Each edition comes in a 32-bit and 64-bit version. The principal editions are the following:
The Enterprise edition of SQL Server 2014 is the uppermost SKU and is considered the premium offering. It is designed to meet the highest demands of large-scale data centers and data warehouse solutions by providing mission-critical performance and availability for tier 1 applications and the ability to deploy private-cloud, highly virtualized environments and large, centralized, or external-facing business-intelligence solutions.
The Enterprise edition features include the following:
In addition, all the features and capabilities of the Business Intelligence edition are available, including:
The Standard edition is a data-management platform tailored toward departmental databases and limited business-intelligence applications that are typically appropriate for medium-class solutions, smaller organizations, or departmental solutions. It does not include all the bells and whistles of the Enterprise and Business Intelligence editions, although it continues to offer best-in-class manageability and ease of use. Compared with the Enterprise and Business Intelligence editions, the Standard edition supports up to 16 cores and includes the following features:
Business Intelligence edition
The Business Intelligence edition offers organizations the full suite of powerful BI capabilities, such as scalable reporting and analytics, Power View, and PowerPivot. It is tailored toward organizations that need corporate business intelligence and self-service capabilities but do not require the full online transactional processing (OLTP) performance and scalability found in the Enterprise edition. Here is a high-level list of what the Business Intelligence edition includes: