Top 10 Sql projects on github

October 3, 2018

1.Mssql-jdbc

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.

2.Msphpsql

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.

4.vscode-mssql

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).

5.Dbatools

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.

6.SQLQueryStress

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

7.sql-server-maintenance-solution

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 https://ola.hallengren.com but are now on GitHub.

8.SQLSupportTools

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.

9.Tigertoolbox

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.

10.sql_job_scripter

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.

https://issuehunt.io/

issuehunt-image