parse json in sql server 2014

Label: When you use SQL Server 2014 for your initial installation, you may encounter situations where you cannot connect to (local). So, how do I fix this problem? steps to readTools/Materials SQL Server 2014 Method/

SQL Server 2014 new features-buffer pool extension (Extension)Supported versionsBuffer pool Extension This feature is available only for 64-bit SQL Server enterprise/business intelligence/standard versions.Terminology interpretationBufferIn

The IT industry is already in the cloud, and more and more enterprise IT infrastructures will be deployed in public, private, or mixed clouds, and it will be important for the database to be the most important part of the IT infrastructure to be integrated into the cloud. SQL Server 2014 opens up the relationship between the public cloud and the organization, whe

Memory Database In traditional database tables, due to the limitation of the physical structure of disks, the structure of tables and indexes is B-Tree, which makes such indexes very weak in the highly concurrent OLTP environment, although there are many ways to solve such problems, such as optimistic concurrency control, application caching, and distributed. However, the cost is still slightly higher. With the development of hardware over the years, it is not uncommon for a

The declining SQL Server and 2014 summarySince in the heart, it is better to send a blog to say2014 I basically did a few things1, came to a company to do DBA, management more SQL Server serversJust came to a company is not very suitable, because

Label:As you can see from Paul White's Twitter, in SQL Server 2014, for table variables (tables Variables), it is supported for non-unique clustered indexes (Non-unique Clustered Indexes) and nonclustered indexes (non-clustered Indexes). Seeing this, I decided to try it on my own virtual machine, because it would be an excellent feature. Table variables are great

Brief introduction SQL Server 2014 offers a number of exciting new features, but one of the most anticipated features I think is the memory database. When I attended the opening of SQL Pass Summit 2012 in Seattle last year, Microsoft announced that a memory database engine, code-named Hekaton, would be included in the

Label:In today's article, I'd like to talk about the cool boost in SQL Server 2014: Now you can finally suppress queries based on the IOPS you need! The resource governor (Resource Governor) was introduced from SQL Server 2008, but the functionality offered is limited: You c

Tags: directory maintenance guideSQL Server 2014 installation and Configuration guideChapter Catalogue"SQL Server 2014 management and Maintenance"1th. Achieving data integrity and consistency1.1 Data integrity1.2 Data consistency1.3 Blocking and deadlocksThe 2nd chapter cont

Power query and power map are new features for Excel in power Bi, which was released by Microsoft shortly before WPC. With these two features, self-service bi will make it easier for you to discover and process data and enrich the visualization of your data. The predecessor of power query and power map are data explorer and Geoflow, both of which are mentioned in SQL Server

Tags: database always on high availability SQL Server 2014For an overview of always on, here's not much to say, you need to see Microsoft's official website: https://technet.microsoft.com/zh-cn/library/ff877884 (v=sql.110). aspxLet's start by introducing the machines used in your environment. Computer name IP Address Note Con

Tags: MCTThe following series of official training courseware for SQL Server 2014 has been released.The required MCT (Microsoft Certified Instructor) can download these courseware by logging in to the official HTTPS://MOCL.ONE.MICROSOFT.COM/CWDL ID.10977b:updating Your SQL Server