sqlserver-kit - Useful links, scripts, tools and best practice for Microsoft SQL Server Database

  •        13

Useful links, scripts, tools and best practice for Microsoft SQL Server Database

http://sqlserver-kit.org
https://github.com/ktaranov/sqlserver-kit

Tags
Implementation
License
Platform

   




Related Projects

powerTrace - a PowerShell snapin for SQL Server Trace files

  •    

This is a snapin for Microsoft PowerShell which allows for the loading and exploration of SQL Trace files using PowerShell. This provider has been initially designed to work with trace files from SQL Server Analysis Services.

SQL Server PowerShell Extensions

  •    

The primary goal of SQL Server PowerShell Extensions (SQLPSX) is to provide intuitive functions around the SMO objects which are backward compatible with SQL 2000. A secondary goal is to provide an application which reports flatten/effective security settings.

dbatools - PowerShell module to help SQL Server Pros be more productive

  •    PowerShell

dbatools is sort of like a command-line SQL Server Management Studio. The project initially started out as Start-SqlMigration.ps1, but has now grown into a collection of over 400 commands that help automate SQL Server tasks and encourage best practices.

node-sqlserver

  •    C++

This driver is a native C driver that uses the Microsoft ODBC driver under the hood. If you are looking for a pure javascript driver with no dependencies please check out Tedious.The Microsoft Driver for Node.js for SQL Server allows Node.js applications on Microsoft Windows and Microsoft Windows Azure to access Microsoft SQL Server and Microsoft Windows Azure SQL Database.

GetMsSqlDump - a mysqldump-like tool for MSSQL

  •    

GetMsSqlDump is the mssql counterpart (or something similar) of mysqldump, written for Microsoft SQL Server, in PowerShell. I'd call it mssqldump if it weren't in use. Using this script you can dump your database content into a file in a form of INSERT INTO statements.


sql-docs - Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc

  •    PowerShell

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments. You've found the GitHub repository that houses the source for the SQL Server technical documentation published on https://docs.microsoft.com.

SQL-Server-R-Services-Samples - Advanced analytics samples and templates using SQL Server R Services

  •    R

In these examples, we will demonstrate how to develop and deploy end-to-end advanced analytics solutions with SQL Server 2016 R Services.Develop models in R IDE. SQL Server 2016 R services allows Data Scientists to develop solutions in an R IDE (such as RStudio, Visual Studio R Tools) with Open Source R or Microsoft R Server, using data residing in SQL Server, and computing done in-database.

Free SQL Server Database Templates & SQL Code Download

  •    

You can download here SQL Server Database Templates an SQL Source codes for various type of projects, Template Downloads for SQL Server

activerecord-sqlserver-adapter - SQL Server Adapter For Rails

  •    Ruby

Both TinyTDS and the Rails SQL Server Adapter are MIT-licensed open source projects. Its ongoing development is made possible thanks to the support by these awesome backers. If you'd like to join them, check out our Patreon Campaign. The SQL Server adapter for ActiveRecord v5.1 using SQL Server 2012 or higher.

mssql-docker - Official Microsoft repository for SQL Server in Docker resources

  •    PowerShell

This GitHub repository aims to provide a centralized location for community engagement. In here you will find documentation, Dockerfiles and additional developer resources.Visit the Microsoft Docker Hub page for more information and additional images.

SQL-Server-First-Responder-Kit - sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning

  •    PLpgSQL

You're a DBA, sysadmin, or developer who manages Microsoft SQL Servers. It's your fault if they're down or slow. These tools help you understand what's going on in your server. Everyone here is expected to abide by the Contributor Covenant Code of Conduct.

PowerRepl

  •    

A Powershell script to sync access database table data with SQL Server database tables.

Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server

  •    

SPADE simplifies the process of standing up a new SQL Server instance by applying standard Operating System pre-configurations, Installing SQL Server and then applying post-configurations and creating standard objects.

SQLbuddy – Microsoft SQL Server Management Tool

  •    CSharp

SqlBuddy is a tool for use with Microsoft SQL Server and MSDE, written in csharp/ DotNet (.NET), to facilitate SQL script writing. It is serves a slightly different purpose that of Query Analyser, in that it is aimed to *help* the user write SQL. It helps to explore the database schema, Organise SQL code and snippets, To expose the in-built SQL Server functionality (functions, procedures etc) to the developer.

SQL Server DB & SSIS Powershell Deployment

  •    

A lightweight way to automate SQL Server builds and deploy SSIS packages to development environments. Uses Red Gate SQL Compare, SVN and Powershell. Ideal for DW/BI projects.

SQL Power Doc

  •    

SQL Power Doc is a collection of Windows PowerShell scripts & modules that discover, document, & diagnose SQL Server instances & their underlying Windows OS.

Rezoom.SQL - Statically typechecks a common SQL dialect and translates it to various RDBMS backends

  •    F#

Rezoom.SQL is an F# ORM for SQL databases. It integrates with the F# compiler via a generative type provider to statically typecheck its own dialect of SQL. It knows how to translate this SQL dialect to various backends. Currently it supports SQLite, SQL Server, and PostgreSQL.

SQL Web Data Administrator

  •    

The SQL Server Web Data Administrator enables you to easily manage your SQL Server data, wherever you are. Using its built-in features, you can do the following from Microsoft Internet Explorer or your favorite Web browser: * Create and edit databases in SQL Server or Microsoft

go-mssqldb - Microsoft SQL server driver written in go language

  •    Go

A string of this format can be constructed using the URL type in the net/url package.The sqlserver driver uses normal MS SQL Server syntax and expects parameters in the sql query to be in the form of either @Name or @p1 to @pN (ordinal position).

Standalone SQL Agent

  •    

The Standalone SQL Agent provides SQL Express users with the ability to use the SQL Server Agent features of the database system even though Microsoft has decided to remove the SQL Agent from the SQL Express product. This project is developed using Visual Basic.NET 2008.