Also, author some queries against the system tables to bring back some information about the SQL Server instance or the AdventureWorksLT2012 database. Now that I have everything connected I can start running queries.Īuthor some SQL queries against this database, demonstrating knowledge of several of the following: joins, grouping, window functions, common table expressions, etc. I decided to use a different tool called SQLPro after downloading and launching SQLPro I knew what my problem was… I was doing everything right I was just using the wrong password to connect. I tried RazorSQL but after spending an hour trying to troubleshoot the connection with no help from the error messages. One issue I was running into was finding a good tool to run SQL queries from my Macbook. Now that I have my server up and running it is time to connect to the database and run queries. I followed along the tutorials in Microsoft’s documentation to figure out exactly how to do this. I then used the SQL Database tool built into Azure to connect a sample database containing the AdventureWorks2012 data. I then deployed the Virtual Machine running SQL Server Express 2012.

I then searched the marketplace on Azure for SQL Server Express 2012. The first step I took was to create an Azure account with Microsoft. Create an instance of SQL Server Express 2012 on a cloud provider (AWS, Azure, etc.). Attach the AdventureWorksLT2012 database (which can be found on CodePlex).

Razorsql scam