Sites Microsoft


JSON in SQL Server 2016: Part 1 of 4

Publié le 5 janvier 2016 sur sql server team blog
 

JSON is currently one of the most commonly used data exchange formats. Most modern services return information formatted as JSON text; web browsers use information formatted as JSON. JSON is the common format when semi-structured information needs to b …

Loading GeoJSON data into SQL Server

Publié le 5 janvier 2016 sur Microsoft SQL Server database engine blog
 

GeoJSON is popular format for spatial data representation. If you receive text formatted as GeoJSON from other systems, you can load it into SQL Server and convert it into spatial types. New OPENJSON function in SQL Server 2016 enables you to parse and …

Returning spatial data in GeoJSON format

Publié le 5 janvier 2016 sur Microsoft SQL Server database engine blog
 

GeoJSON is popular format used to represent spatial data. An example of GeoJSON text that represents one point is shown in the following example: { « type »: « Feature », « geometry »: { « type »: « Point », « coordinates »: [125.6, 10.1] }, « properties »: { « name » …

Returning spatial data in GeoJSON format – Part 1

Publié le 5 janvier 2016 sur Microsoft SQL Server database engine blog
 

GeoJSON is popular format used to represent spatial data. An example of GeoJSON text that represents one point is shown in the following example: { « type »: « Feature », « geometry »: { « type »: « Point », « coordinates »: [125.6, 10.1] }, « properties »: { « name » …

Wanting your non-sysadmin users to enable certain trace flags without changing your app?

Publié le 30 décembre 2015 sur css sql server engineers
 

Even with SQL Server support for so many years, we still face something new almost every day.   Sometimes you will just have to combine things together to achieve what you need.  Here is an example due to troubleshooting a customer …

What to do when you run out of disk space for In-Memory OLTP checkpoint files

Publié le 23 décembre 2015 sur css sql server engineers
 

While data for memory optimized tables resides in memory all the time with SQL Server 2014 and 2016’s In-Memory OLTP feature, we still need a means to cut down recovery time in case of crash or restart.  For disk based table, check …

Cumulative Update #11 for SQL Server 2014 RTM

Publié le 22 décembre 2015 sur microsoft sql server release services
 

Dear Customers, The eleventh cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. To learn more about the release or servicing model, please visit: CU#11 KB Article: https://support…(read more …

Cumulative Update #4 for SQL Server 2014 SP1

Publié le 22 décembre 2015 sur microsoft sql server release services
 

Dear Customers, The fourth cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Support site. To learn more about the release or servicing model, please visit: CU#4 KB Article: https://support.microsoft…(re …

Indexing data in JSON product catalogs

Publié le 21 décembre 2015 sur Microsoft SQL Server database engine blog
 

In the previous post Designing Product Catalogs in SQL Server 2016 using JSON, I have described how you can design product catalog with JSON. Product catalog contains few columns that are common to all types of products and all custom/specific columns …

Designing Product Catalogs in SQL Server 2016 using JSON

Publié le 21 décembre 2015 sur Microsoft SQL Server database engine blog
 

In this post we will see how we could design flexible product catalogs in SQL Server using JSON….(read more)

WITHOUT_ARRAY_WRAPPER – New important change in FOR JSON

Publié le 21 décembre 2015 sur Microsoft SQL Server database engine blog
 

In SQL Server 2016 CTP3.2 is added new option in FOR JSON clause – WITHOUT_ARRAY_WRAPPER see https://msdn.microsoft.com/en-us/library/mt631354.aspx This option enables you to remove square brackets [ and ] that surround JSON text generated by FOR JSON …

WITHOUT_ARRAY_WRAPPER – New important change in FOR JSON

Publié le 21 décembre 2015 sur Microsoft SQL Server database engine blog
 

In SQL Server 2016 CTP3.2 is added new option in FOR JSON clause – WITHOUT_ARRAY_WRAPPER see https://msdn.microsoft.com/en-us/library/mt631354.aspx This option enables you to remove square brackets [ and ] that surround JSON text generated by FOR …

Using SQL Server Integration Services (SSIS) with Always Encrypted

Publié le 18 décembre 2015 sur sql server security blog
 

We would like share a couple of links to two articles, just published on SQL Server IntegrationServices (SSIS) Blog, which provide guidance for how to use SSIS with Always Encrypted: SSIS with Always Encrypted Lookup transformation with Always Encrypte …

Planning an efficient upgrade from SQL Server 2005: Step 3 of 3

Publié le 17 décembre 2015 sur sql server team blog
 

Step 3: Identify your upgrade strategy As the end-of-support deadline for SQL Server 2005 draws near (April 12, 2016), you are probably starting to think about your upgrade strategy. Upgrading SQL Server is a multistage effort that takes time. Planning …


Pages :