azure / azure-sql-database-samples

Azure SQL Database Samples and Reference Implementation Repository

Azure SQL Database Code Samples

Azure SQL Database Samples and Reference Implementation Repository

Here we will cover samples for:

1. PHP

2. Node.js

3. Python

4. Django

5. Ruby

6. Ruby on Rails

7. Java

8. C#

9. T-SQL

Questions

For questions please email [email protected] or [email protected]

azure-sql-database-samples's Issues

Collapse code which isn't different on different platforms.

There is currently duplicate code, for instance in the python example, which is exactly the same on both platforms and the only difference is the installation instructions on each platform.

Ideally these would be collapsed and you could just have different sections for each platform, as currently the structure of the project makes it appear like you will need to write different code on different platforms, when that isn't true.

SQL Server v15 is not supported

Hi, error occurred on connecting to MSSQL2017 Linux edition, it shows SQL Server v15 is not supported. May I know is it really not supported yet?　thankyou

TinyTds::Error: Adaptive Server connection failed

I'm trying to configure my Rails project with SQL on Azure. I'm using Mac OS X 10.11. But when I run rake db:migrate I receive this error TinyTds::Error: Adaptive Server connection failed.

I'm looking for answer in Stackoverflow, too.

http://stackoverflow.com/questions/36484700/rails-and-azure-tinytdserror-adaptive-server-connection-failed

Sample code leaks resources and does not use best practice of prepared statements

Code at : https://docs.microsoft.com/nl-nl/azure/sql-database/sql-database-connect-query-java

• The code does not use try with resources /does not try to close connections in a finally clause.
• It does not use prepared statements

Code I saw at 25-01-2018

public static void main(String[] args) {

     // Connect to database
        String hostName = "your_server.database.windows.net";
        String dbName = "your_database";
        String user = "your_username";
        String password = "your_password";
        String url = String.format("jdbc:sqlserver://%s:1433;database=%s;user=%s;password=%s;encrypt=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;", hostName, dbName, user, password);
        Connection connection = null;

        try {
                connection = DriverManager.getConnection(url);
                String schema = connection.getSchema();
                System.out.println("Successful connection - Schema: " + schema);

                System.out.println("Query data example:");
                System.out.println("=========================================");

                // Create and execute a SELECT SQL statement.
                String selectSql = "SELECT TOP 20 pc.Name as CategoryName, p.name as ProductName " 
                    + "FROM [SalesLT].[ProductCategory] pc "  
                    + "JOIN [SalesLT].[Product] p ON pc.productcategoryid = p.productcategoryid";

                try (Statement statement = connection.createStatement();
                    ResultSet resultSet = statement.executeQuery(selectSql)) {

                        // Print results from select statement
                        System.out.println("Top 20 categories:");
                        while (resultSet.next())
                        {
                            System.out.println(resultSet.getString(1) + " "
                                + resultSet.getString(2));
                        }
                 connection.close();
                }                   
        }
        catch (Exception e) {
                e.printStackTrace();
        }
    }
}