Skip to content

Commit 3843c4e

Browse files
JocaPCJocaPC
authored
Merge pull request microsoft#1 from JocaPC/json
Adding JSON Examples
2 parents 2302096 + 62f1c65 commit 3843c4e

File tree

75 files changed

+8406
-2831
lines changed

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

75 files changed

+8406
-2831
lines changed

‎.gitignore

Lines changed: 27 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,29 @@
11
samples/in-memory/ticket-reservations/DemoWorkload/obj/Debug/TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
22
*.nupkg
3-
samples/in-memory/ticket-reservations/packages/CircularGauge.1.0.0/CreatePackageFile.bat
3+
samples/in-memory/ticket-reservations/packages/CircularGauge.1.0.0/CreatePackageFile.bat
4+
*.suo
5+
samples/databases/wide-world-importers/sample-scripts/always-encrypted/PopulateAlwaysEncryptedData/bin/Debug/PopulateAlwaysEncryptedData.exe
6+
*.pdb
7+
samples/databases/wide-world-importers/sample-scripts/always-encrypted/PopulateAlwaysEncryptedData/bin/Debug/PopulateAlwaysEncryptedData.vshost.exe
8+
*.Cache
9+
samples/databases/wide-world-importers/sample-scripts/always-encrypted/PopulateAlwaysEncryptedData/bin/Debug/PopulateAlwaysEncryptedData.exe.config
10+
samples/databases/wide-world-importers/sample-scripts/always-encrypted/PopulateAlwaysEncryptedData/obj/Debug/TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
11+
samples/databases/wide-world-importers/workload-drivers/vehicle-location-insert/MultithreadedInMemoryTableInsert/obj/Debug/TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
12+
*.exe
13+
samples/features/in-memory/iot-smart-grid/ConsoleClient/bin/Release/DataGenerator.dll
14+
samples/features/in-memory/iot-smart-grid/ConsoleClient/bin/Release/Reports/PowerDashboard.pbix
15+
samples/databases/wide-world-importers/wwi-integration-etl/Daily ETL/bin/Development/Daily ETL.ispac
16+
samples/databases/wide-world-importers/sample-scripts/always-encrypted/PopulateAlwaysEncryptedData/obj/Release/PopulateAlwaysEncryptedData.csproj.FileListAbsolute.txt
17+
samples/databases/wide-world-importers/sample-scripts/always-encrypted/PopulateAlwaysEncryptedData/bin/Release/PopulateAlwaysEncryptedData.vshost.exe.config
18+
samples/databases/wide-world-importers/sample-scripts/always-encrypted/PopulateAlwaysEncryptedData/obj/Release/TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
19+
*.dll
20+
samples/features/in-memory/ticket-reservations/DemoWorkload/obj/Release/DemoWorkload.FrmConfig.resources
21+
samples/features/in-memory/ticket-reservations/DemoWorkload/bin/Release/DemoWorkload.vshost.exe.config
22+
samples/databases/wide-world-importers/sample-scripts/always-encrypted/PopulateAlwaysEncryptedData/obj/Debug/PopulateAlwaysEncryptedData.csproj.FileListAbsolute.txt
23+
samples/databases/wide-world-importers/sample-scripts/always-encrypted/PopulateAlwaysEncryptedData/bin/Debug/PopulateAlwaysEncryptedData.vshost.exe.config
24+
*.zip
25+
samples/features/in-memory/ticket-reservations/packages/CircularGauge.1.0.0/CreatePackageFile.bat
26+
samples/features/in-memory/ticket-reservations/TicketReservations/TicketReservations.dbmdl
27+
samples/databases/wide-world-importers/workload-drivers/vehicle-location-insert/MultithreadedInMemoryTableInsert/obj/Release/TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
28+
*.dat
29+
*.sln

‎README.md

Lines changed: 6 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,11 +1,16 @@
11
# SQL Server Samples Repository
22
This GitHub repository contains code samples that demonstrate how to use Microsoft's SQL products including SQL Server, Azure SQL Database, and Azure SQL Data Warehouse. Each sample includes a README file that explains how to run and use the sample.
33

4-
Note that certain features like In-Memory are edition specific for SQL Server and would be possible to implement if the edition which supports that feature is being used to run the sample.
4+
Note that certain features like In-Memory OLTP are edition specific for SQL Server and would be possible to implement if the edition which supports that feature is being used to run the sample.
55

66
## Working in GitHub
77
To work in GitHub, go to https://github.com/microsoft/sql-server-samples and fork the repository. Work in your own fork and when you are ready to submit to make a change or publish your sample for the first time, submit a pull request into the master branch of sql-server-samples. One of the approvers will review your request and accept or reject the pull request.
88

9+
Each sample should be in its own folder with a README.md file that follows the [template](README_samples_template.md). Generated files (e.g., .exe or .bacpac) and user configuration settings (e.g., .user) should not be committed to GitHub.
10+
11+
## Code of Conduct
12+
This project has adopted the [Microsoft Open Source Code of Conduct](https://opensource.microsoft.com/codeofconduct/). For more information see the [Code of Conduct FAQ](https://opensource.microsoft.com/codeofconduct/faq/) or contact [opencode@microsoft.com](mailto:opencode@microsoft.com) with any additional questions or comments.
13+
914
## License
1015
These samples and templates are all licensed under the MIT license. See the license.txt file in the root.
1116

‎media/in-memory-oltp-performance.png

42 KB
Loading

‎samples/README.md

Lines changed: 13 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,17 @@
11
# Sample Categories
22

3+
__[applications] (applications/)__
4+
5+
End-to-end sample applications that illustrate the use of SQL Server for specific application scenarios.
6+
7+
__[databases] (databases/)__
8+
9+
Sample databases for SQL Server, Azure SQL Database, and Azure SQL Data Warehouse.
10+
311
__[features] (features/)__
412

5-
Contains samples illustrating specific SQL Server and Azure SQL Database features, including In-Memory OLTP, Master Data Services (MDS), and R Services.
13+
Samples illustrating specific SQL Server and Azure SQL Database features, including In-Memory OLTP, Master Data Services (MDS), and R Services.
14+
15+
__[management] (manage/)__
16+
17+
Samples that help with the management of SQL Server and Azure SQL Database.

‎samples/applications/iot-smart-grid/App.config

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" />
55
</startup>
66
<connectionStrings>
7-
<!--<add name="Db" connectionString="Server=tcp:peskount-hktest1.database.windows.net,1433;Database=PowerConsumption;User ID=demovm001@peskount-hktest1;Password=LetAzureIn0_;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"/>-->
7+
<!--<add name="Db" connectionString="Server=tcp:<server>.database.windows.net,1433;Database=PowerConsumption;User ID=<user>;Password=<password>;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"/>-->
88
<add name="Db" connectionString="Server=.;Database=PowerConsumption;Integrated Security=True"/>
99
</connectionStrings>
1010
<appSettings>

‎samples/databases/README.md

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,9 @@
22

33
Contains samples databases for Microsoft's SQL databases include SQL Server, Azure SQL Database, and Azure SQL Data Warehouse.
44

5-
__[world-wide-importers](world-wide-importers/)__
5+
__[wide-world-importers](wide-world-importers/)__
66

7-
The new sample database for SQL Server 2016 and Azure SQL Database. It illustrates best practices in database design, as well as the core capabilities of SQL Server 2016 and Azure SQL Database, for transaction processing (OLTP), data warehousing and analytics (OLAP) workloads, as well as hybrid transaction and analytics processing (HTAP) workloads.
7+
The new sample database for SQL Server 2016 and Azure SQL Database. It illustrates the core capabilities of SQL Server 2016 and Azure SQL Database, for transaction processing (OLTP), data warehousing and analytics (OLAP) workloads, as well as hybrid transaction and analytics processing (HTAP) workloads.
88

99
__[contoso-data-warehouse](contoso-data-warehouse/)__
1010

‎samples/databases/wide-world-importers/README.md

Lines changed: 8 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -6,6 +6,12 @@ WideWorldImporters is a wholesale company. Transactions and real-time analytics
66

77
The sample includes the databases that can be explored, as well as sample applications and sample scripts that can be used to explore the use of individual SQL Server features in the sample database.
88

9+
**Latest release**: [wide-world-importers-release](http://go.microsoft.com/fwlink/?LinkID=800630)
10+
11+
**Documentation**: [Wide World Importers Documentation](http://go.microsoft.com/fwlink/?LinkID=800631)
12+
13+
**Feedback on the sample**: send to [sqlserversamples@microsoft.com](mailto:sqlserversamples@microsoft.com)
14+
915
### Contents
1016

1117
[About this sample](#about-this-sample)<br/>
@@ -24,7 +30,7 @@ The sample includes the databases that can be explored, as well as sample applic
2430
1. **Key features:** Core database features
2531
1. **Workload:** OLTP, OLAP, IoT
2632
1. **Programming Language:** T-SQL, C#
27-
1. **Authors:** Greg Low, Jos de Bruijn
33+
1. **Authors:** Greg Low, Denzil Ribeiro, Jos de Bruijn
2834
1. **Update history:** 25 May 2016 - initial revision
2935

3036
<a name=before-you-begin></a>
@@ -37,7 +43,7 @@ To run this sample, you need the following prerequisites.
3743

3844
<!-- Examples -->
3945
1. SQL Server 2016 (or higher) or an Azure SQL Database.
40-
2. SQL Server Management Studio, preferably 2016 April Preview or later (version >= 13.0.14000.36).
46+
2. SQL Server Management Studio, preferably June 2016 release or later (version >= 13.0.15000.23).
4147
3. (to build sample apps) Visual Studio 2015.
4248
4. (to run ETL jobs) SQL Server 2016 Integration Services
4349

‎samples/databases/wide-world-importers/documentation/README.md

Lines changed: 0 additions & 7 deletions
This file was deleted.

‎samples/databases/wide-world-importers/documentation/root.md

Lines changed: 0 additions & 65 deletions
This file was deleted.

‎samples/databases/wide-world-importers/documentation/wwi-data-generation.md

Lines changed: 0 additions & 35 deletions
This file was deleted.

0 commit comments

Comments
 (0)