SQLPro for MSSQL free for students

Posted by Kyle Hankinson August 18, 2024

What is SQLPro Studio?

SQLPro Studio is a versatile database management tool designed to streamline the process of working with various databases using SQL queries. It supports a wide range of databases, including MySQL, PostgreSQL, Microsoft SQL Server, SQLite, Snowflake and more. With its user-friendly interface and powerful features, SQLPro Studio is an essential tool for anyone dealing with databases.

Benefits of Using SQLPro Studio

  • Efficient Database Management: SQLPro Studio offers a comprehensive set of tools to manage and manipulate databases efficiently. You can easily create, edit, and delete database objects such as tables, views, and indexes.

  • Advanced Querying: Writing and executing SQL queries is a breeze with SQLPro Studio's syntax highlighting, code completion, and query history features. It helps you write accurate queries and quickly identify errors.

  • Visual Data Exploration: The visual data explorer allows you to view and analyze your data in a graphical format, helping you gain insights from your database content.

  • Collaboration: SQLPro Studio enables seamless collaboration by allowing you to share queries and query results with team members. This is particularly beneficial when working on group projects or assignments.

Getting SQLPro Studio for Free as a Student

Here's how you can obtain SQLPro Studio for free as a student:

  1. Visit the student portal: Head over to the student portal.

  2. Verify Your Student Status: You will need a non genearic email educational institution's email address.

  3. Apply for the Education License: Enter your student details.

  4. Download and Install: Once your education license is approved, you'll receive instructions on how to download and install SQLPro Studio on your device.

Making the Most of SQLPro Studio

After successfully obtaining SQLPro Studio, take some time to explore its features and functionalities. Familiarize yourself with the user interface, practice writing SQL queries, and experiment with different databases. SQLPro Studio's documentation and online tutorials can provide valuable guidance as you enhance your database management skills.

In conclusion, SQLPro Studio is a valuable asset for students studying fields related to data and databases. Its efficient database management tools and advanced querying capabilities can greatly enhance your learning experience. By following the steps outlined in this blog post, you can obtain SQLPro Studio for free and begin harnessing its power to excel in your studies and future projects. Happy querying!

Note: Pricing and availability of education licenses may vary. Please refer to the official SQLPro Studio website for the most accurate and up-to-date information.

Export from SQLPro for MSSQL to CSV, JSON or XML

Posted by Kyle Hankinson August 9, 2023

SQLPro for MSSQL export to CSV, JSON or XML

You can use SQLPro for MSSQL to export a table or view directly, or to export the results of a result set. Results can be exported to CSV, JSON or XML.

To export from a table or view, find the target in the database tree and right click on it. Choose 'Export as', then pick from either CSV, JSON or XML from one of the submenus.

Similar, when exporting from a results set either right click (or single click the arrow at the top left of resutls) and choose 'Export result set as' and pick from one of the options.

Video example:

Tags: MySQL Feature PostgreSQL Microsoft SQL Server SQLite Snowflake


Posted by Kyle Hankinson August 9, 2023

SQLPro for MSSQL Feature list

A list of some of SQLPro's features.

  • Intellisense/SQL autocompletion
  • Syntax highlighting with customizable themes (including dark)
  • Tabbed based interface for an optimal user experience
  • Context aware database tree navigation, including quick access to tables, views, columns, indexes and much more!
  • SQL Beautifier/formatter
  • Database wide searching
  • NTLMv2 supported (but not required)
  • Netbios support
  • Master password support for additional security
  • Supports Handoff from iOS to macOS
  • Cloud support (Amazon RDS, Microsoft Azure, Heroku and many others)
  • Support for multiple result sets at once
  • Inline results editing
  • Automatic foreign key detection
  • No Java. SQLPro is native code
  • Intuitive interface
  • Import from CSV, JSON or XML
  • Export to CSV, JSON or XML (link)
  • Multiple cursor support (link)
  • Execute query in cursor range (link)

Tags: Feature

MySQL table size

Posted by Kyle Hankinson January 12, 2023

Understanding the Size of MySQL Tables

When working with MySQL databases, it's important to understand the size of the tables in order to optimize performance and storage. In this article, we will discuss how to retrieve the size of all tables in a MySQL database using a simple SQL query.

To retrieve the size of all tables in a MySQL database, we can use the information_schema.TABLES table, which contains information about all tables in the database. The information_schema.TABLES table has two columns, data_length and index_length, that represent the size of the data and index for each table, respectively.

Here is an example of a query that shows the size of all tables in a MySQL database:

SELECT table_name AS 'Table Name', round(((data_length + index_length) / 1024 / 1024), 2) AS 'Size (MB)' FROM information_schema.TABLES GROUP BY table_name

Tags: MySQL

License key FAQ

Posted by Kyle Hankinson June 29, 2021

Can I use SQLPro on multiple platforms?

SQL Pro can be used on multiple platforms when you purchase a yearly or monthly license from the SQLPro website. A monthly or yearly license purchased via the website will work on the iOS, macOS and Windows verison. SQLPro for SQLite is the one exception to this rule.

Can I use my lifetime license on multiple platforms?

Unfortunately, no. Lifetime purchases are single-platform only. As an independent developer, subscriptions are how the app can continue to maintain a revenue stream and allow me to continually improve and develop the applications. Lifetime is provided only for those users who absolutely wish to avoid a subscription but does require a purchase for each platform.

Can a purchase from the macOS/iOS/Windows app store be used on multiple platforms?

No. While Apple did add the ability for iOS and macOS apps to share purchases, they only added it for apps. At the time SQLPro was already in the store for more than five years and did not get this ability.

I purchased via the App Store, can I get a license key?

Unfortunately, not. Generally, I recommend requesting a refund via the app store, then purchasing via the website.

More articles: