Top 10 Sql projects on github

October 3, 2018



785a2621fbaf30ea4816fb68c1858c18.png The Microsoft JDBC Driver for SQL Server is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in the Java Platform, Enterprise Editions.
The Driver provides access to Microsoft SQL Server and Azure SQL Database from any Java application, application server, or Javaenabled applet.


f56d52529964b437b78453cc489d7b0e.png The Microsoft Drivers for PHP for Microsoft SQL Server are PHP extensions that allow for the reading and writing of SQL Server data from within PHP scripts.
The SQLSRV extension provides a procedural interface while the PDO_SQLSRV extension implements PHP Data Objects (PDO) for accessing data in all editions of SQL Server 2008 R2 and later (including Azure SQL DB).
These drivers rely on the Microsoft ODBC Driver for SQL Server to handle the low-level communication with SQL Server.

3.Visual Studio Code

c97a2ccbd57f497490fe35703bdb995c.png VS Code is a new type of tool that combines the simplicity of a code editor with what developers need for their core edit-build-debug cycle.
Code provides comprehensive editing and debugging support, an extensibility model, and lightweight integration with existing tools.


0c25997c4345e63570432d2422a91afc.png If you’re going to use Visual Studio Core with SQL Server you’ll want to add the Visual Studio Extensions for SQL Server.
This adds features to Visual Studio Code for connecting to SQL Server and Azure SQL Databases and to write and execute T-SQL code.
Microsoft is putting a lot of effort into this project and it’s reached general availability (GA).


b4140f3357d58b78a9ae37cb72dde459.png A group of developers have created this library of PowerShell modules for managing SQL Server.
If you’re a PowerShell user this library has many commands that a DBA can use to automate their job.


20224ce126abffb3d7bcf8d8ddc2729d.png This is Adam Machanic’s tool to generate a test load for performance testing.


e5059e64329f314e37750d2f2d68ad9d.png One of the most widely used maintenance libraries is from Ola Hallengren’s.
It supports versions of SQL Server from 2005 to 2016, and includes backups, Integrity Checking, and Index and Statistics Maintenance.
These maintenance scripts have been available from but are now on GitHub.


e3868f4ee1d53ca7347b5d37a5d1f525.png The CSS Team’s tools such as PSSDIAG, SQL Nexus, and the RML Utilities This is just a small sample of the projects that Microsoft has hosted on GitHub.
There are quite a few more and the existing ones are frequently updated.
Microsoft isn’t the only source for SQL Server projects on GitHub.
There are many members of the SQL community that have contributed projects.


58dae79b88bd55be064c9debf8dc2a04.png “As-is” solutions including tools/scripts from the Microsoft Tiger team that supports SQL Server.
You find just gems as the Waits and Latches scripts to identify where your system is using Waits and Latches.
A script to fix VLFs and compression analysis tools.
I’m going to be spending a lot of time on this one.


20d8377a0a3a2e0b34d4205887b8fcf6.png SQL Job Scripter is a command line utility that produces scripts of SQL Agent jobs.
It will script either to a single file or to one file per job.

This post is curated by IssueHunt that an issue based bounty for open-source projects.