Code Monkey home page Code Monkey logo

sqldev's Introduction

SQL Server Tutorials Documentation Contributor Guide

You've found the GitHub repository that houses the source for the SQL Server tutorials that are published on https://aka.ms/sqldev.

Contribute to SQL Server tutorials

Firstly, thank you for your interest in contributing to our tutorials. We use Jekyll + Markdown for our documentation. To contribute, simply make a pull request (PR) with changes in the Markdown files or add new Markdown files. We will do our best to review changes within 24 hours.

Repository organization

The content in the repository follows the standard Jekyll folder structure:

\pages

The \pages folder contains the documentation articles formatted as markdown files with an .md extension for each langauge & operating system combination.

_includes

This folder contains reusable content sections to be included in one or more articles. This folder also contains base HTML files that are used across the site.

_sass

This folder contains the CSS files used to style the website

\assets

This folder contains images and js scripts used in the tutorials website.

Use GitHub

For information about how to contribute, how to use the GitHub UI to contribute small changes, and how to fork and clone the repository for more significant contributions, see Authoring in GitHub.

Branches

We recommend that you create local working branches that target a specific scope of change. Each branch should be limited to a single concept/article both to streamline work flow and reduce the possibility of merge conflicts. The following efforts are of the appropriate scope for a new branch:

  • A new article (and associated images)
  • Spelling and grammar edits on an article.
  • Applying a single formatting change across a large set of articles (e.g. new copyright footer).

How to use markdown to format your topic

All the articles in this repository use GitHub flavored markdown. Here's a list of resources.

Article metadata

Article metadata enables certain functionalities, such as author attribution, contributor attribution, breadcrumbs, article descriptions, and SEO optimizations as well as reporting Microsoft uses to evaluate the performance of the content. So, the metadata is important! Here's the guidance for making sure your metadata is done right.

Labels

Automated labels are assigned to pull requests to help us manage the pull request workflow and to help let you know what's going on with your pull request:

  • Contribution License Agreement related
    • cla-not-required: The change is relatively minor and does not require that you sign a CLA.
    • cla-required: The scope of the change is relatively large and requires that you sign a CLA.
    • cla-signed: The contributor signed the CLA, so the pull request can now move forward for review.

Microsoft Open Source Code of Conduct

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

sqldev's People

Contributors

ajlam avatar akatesmith avatar badersur avatar bureado avatar david-engel avatar david-puglielli avatar dependabot[bot] avatar fpelaez avatar jeffjkwok avatar jettermctedder avatar luisbosquez avatar meet-bhagdev avatar michaelsun90 avatar microsoft-github-policy-service[bot] avatar microsoftopensource avatar msftgits avatar pinguin999 avatar sarvaje avatar tobiassql avatar twright-msft avatar vin-yu avatar yitam avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

sqldev's Issues

Connect string incorrect for Python tutorial on *nix platforms

Kudos for the great tutorial pages! I just wanted to identify that the connect string shown:

cnxn = pyodbc.connect('DRIVER={ODBC Driver 13 for SQL Server};SERVER='+server+';PORT=1433;DATABASE='+database+';UID='+username+';PWD='+ password)

seems to be incorrect. The "PORT=" entry is useless and does nothing. You can set it to any number you like and it still just defaults to 1433. The "SERVER=" entry is where the port must be set. It should look like this: "SERVER=192.168.1.100,15002"

Unable to complete configuration of new installation on Linux

I'm unsuccessfully trying to complete configuration of newly installed MS-SERVER on Ubuntu 18.04 machine.

My problem basically is follows:


[sergey@sergey-Bionic:~$ sudo /opt/mssql/bin/mssql-conf setup’
Traceback (most recent call last):
  File "/opt/mssql/bin/../lib/mssql-conf/mssql-conf.py", line 15, in <module>
    import mssqlconfhelper
  File "/opt/mssql/lib/mssql-conf/mssqlconfhelper.py", line 220
    print _("Setting language using LCID from environment variable %s") % mssqlLcidEnvVariable
          ^
SyntaxError: invalid syntax
sergey@sergey-Bionic:~$ ](url)


I attribute inability of the code to complete to those "_" underscores after print statements. Any Ideas where I should move from here?

Any help is really appreciated!

SQL Server 2017 CU21 apply patch error

Expected behavior and actual behavior:
SQL Server 2017 CU 21 apply patch from sql server 2017 CU20 fails with error: The operation failed because an index or statistics with name 'IX_EventMessageContext_EventMessageId' already exists on table 'internal.event_message_context'.

Steps to reproduce the problem:
Apply patch SQLServer2017-KB4557397-x64.exe over sql server 2017 Developer CU20

Versions:
Microsoft SQL Server 2017 (RTM-CU20) (KB4541283) - 14.0.3294.2 (X64) Mar 13 2020 14:53:45 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: ) (Hypervisor)

mssql-conf setup freezes and never finishes

So I'm following the instructions for python and ubuntu, and my installation freezes at some point

diego@envy:~$ sudo /opt/mssql/bin/mssql-conf setup
Choose an edition of SQL Server:
  1) Evaluation (free, no production use rights, 180-day limit)
  2) Developer (free, no production use rights)
  3) Express (free)
  4) Web (PAID)
  5) Standard (PAID)
  6) Enterprise (PAID)
  7) Enterprise Core (PAID)
  8) I bought a license through a retail sales channel and have a product key to enter.

Details about editions can be found at
https://go.microsoft.com/fwlink/?LinkId=852748&clcid=0x409

Use of PAID editions of this software requires separate licensing through a
Microsoft Volume Licensing program.
By choosing a PAID edition, you are verifying that you have the appropriate
number of licenses in place to install and run this software.

Enter your edition(1-8): 3
The license terms for this product can be found in
/usr/share/doc/mssql-server or downloaded from:
https://go.microsoft.com/fwlink/?LinkId=855862&clcid=0x409

The privacy statement can be viewed at:
https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409

Enter the SQL Server system administrator password: 
Confirm the SQL Server system administrator password: 
Configuring SQL Server...

I can't tell what is the script waiting for, and if I do ctrl+c to cancel it, I get

^CTraceback (most recent call last):
  File "/opt/mssql/bin/../lib/mssql-conf/mssql-conf.py", line 277, in <module>
    main()
  File "/opt/mssql/bin/../lib/mssql-conf/mssql-conf.py", line 273, in main
    processCommands()
  File "/opt/mssql/bin/../lib/mssql-conf/mssql-conf.py", line 197, in processCommands
    COMMAND_TABLE[args.which]()
  File "/opt/mssql/bin/../lib/mssql-conf/mssql-conf.py", line 54, in handleSetup
    exit(mssqlconfhelper.setupSqlServer(eulaAccepted, noprompt=args.noprompt))
  File "/opt/mssql/lib/mssql-conf/mssqlconfhelper.py", line 833, in setupSqlServer
    ret = configureSqlservrWithArguments("--setup --reset-sa-password", MSSQL_SA_PASSWORD=encodedPassword, MSSQL_PID=pid)
  File "/opt/mssql/lib/mssql-conf/mssqlconfhelper.py", line 737, in configureSqlservrWithArguments
    return subprocess.call(args, env=env)
  File "/usr/lib/python2.7/subprocess.py", line 523, in call
    return Popen(*popenargs, **kwargs).wait()
  File "/usr/lib/python2.7/subprocess.py", line 1392, in wait
    pid, sts = _eintr_retry_call(os.waitpid, self.pid, 0)
  File "/usr/lib/python2.7/subprocess.py", line 476, in _eintr_retry_call
    return func(*args)
KeyboardInterrupt\

so in def configureSqlservrWithArguments(*args, **kwargs): at line 721 of mssqlconfhelper.py there is a subprocess call to invokesqlservr.sh which is probably the source of the problem. From inspection I can see that it runs sqlservr and passes --setup and --reset-sa-password, I suppose.

#!/bin/bash
cd /var/opt/mssql

CMDLINE="/opt/mssql/bin/sqlservr $@"

echo ""

# If running as mssql then execute the command. Else sudo -u to mssql
if [ "$(id -u -n)" == "mssql" ]; then
    /bin/bash -c "$CMDLINE"
    retcode=$?
else
    sudo -EH -u mssql /bin/bash -c "$CMDLINE"
    retcode=$?
fi

exit $retcode

If I run sqlservr directly, execution stalls at

2018-05-21 19:43:45.74 spid6s      Ending provisioning of CEIPLoginName.       
2018-05-21 19:43:45.75 spid6s      ------------------------------------------------------
2018-05-21 19:43:45.79 spid6s      SQL Server is now ready for client connections. This is an informational message; no user action is required.
2018-05-21 19:43:45.79 spid6s      Recovery is complete. This is an informational message only. No user action is required.
2018-05-21 19:43:51.44 spid66      Using 'dbghelp.dll' version '4.0.5'
2018-05-21 19:44:12.07 spid66      Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2018-05-21 19:44:12.20 spid66      Using 'xplog70.dll' version '2017.140.3025' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.

How can I fix this? Is here the place to ask for this kind of stuff?

also

diego@envy:~$ uname --a
Linux envy 4.13.0-41-generic #46~16.04.1-Ubuntu SMP Thu May 3 10:06:43 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

Thanks!

Are Homebrew & OpenSSL required when Installing .NET Core on Ubuntu?

In https://github.com/Microsoft/sqldev/blob/master/pages/csharp/ubuntu/csharp-ubuntu-1.md, there's this:

If you already have .NET Core installed on your machine, skip this step. Install Homebrew, OpenSSL, and .NET Core using the following commands.

But the command is sudo apt-get install dotnet-dev-1.0.1 which seems to be for installing .NET Core only.

I'm thinking about sending a PR with:

If you already have .NET Core installed on your machine, skip this step. Otherwise, install it using the following commands.

but i'm not sure so I'm filling this issue!

BTW, Thanks for publishing the source code for these tutorials. I was looking for it few months ago but couldn't find it. Also, I think it will be easier to contribute if the tutorials link directly to source files.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.