sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
-
Updated
Jun 16, 2022 - TSQL
{{ message }}
Microsoft's SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality. It originated from the Sybase SQL Server 4.x codebase and Transact-SQL dialect (t-sql), but it has forked significantly since then.
SQL Server is available in multiple versions (typically identified by release year), each of which are subdivided into editions to distinguish between product functionality. The latest released version is SQL Server 2019 which was released on November 4th, 2019.
sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
Free GUI Tool for Index Maintenance on SQL Server and Azure
AceQL HTTP is a framework of REST like http APIs that allow to access to remote SQL databases over http from any device that supports http.
Open-source Repository of Useful Scripts and Solutions for the Microsoft Data Platform
A collection of cool and useful tools, procedures and scripts for the discerning DBA
ASP.NET MVC case study solution for PluralSight Guides. Demonstrates structuring a solution with separate projects for the web application, entities, data context, utilities, and tests.
Ecto adapter for Mssqlex
ASP.NET MVC case study solution for PluralSight Guides. Demonstrates how to use populate dropdown lists in Razor views.
SQL Server Blocked Process Report Viewer
ASP.NET MVC case study solution for PluralSight Guides. Demonstrates how to use default MVC model binding with hierarchical form data.
A simple blog system build with ASP.NET MVC and MS SQL Server, also using best practices in the world of programming and web development. I using for running my personal blog.
sp_Develop can be used by database developers, software developers and for performing database code (smell) reviews.
Java JDBC Driver for easy access of remote SQL databases managed with AceQL HTTP
DBAddin is an MS Excel Addin for retrieving Database data via userdefined functions into Excel and writing Data (DBMapper), executing generic DML (DBAction) and doing all this in Sequences (DBSequence).
Brute force attack prevention for remotely accessible SQL Server databases using PowerShell and Windows Task Scheduler API
MS SQL Server to MongoDB export tool
Various SQL stuff I'm working on...tools, scripts, etc
Code for all the projects I create.
QueryBuilder for Node.js. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, and more.
Queries and reports to visualize your SQL data and transaction log page allocations. See which pages are reserved for which objects, and which pages are not used.
A generic SQL DAO plugin for Para (H2, MySQL, MariaDB, ProstgreSQL, MS SQL Server, Oracle, SQLite)
Web application visualizing the relationship database tables ms-sql-server, based on existing referential integrity (ASP.NET MVC & d3.js)
A Web Application like IMDB app to demonstrate many to many relationship using Entity - Framework and ASP.NET MVC
Table synchronization utility for MS-SQL
This Web Application is developed Asp.Net Web Form & MS-SQL Server-14, JavaScript, JQuery, HTML, CSS (Team Lead: Me). It's a smart Diagnostic Center Bill Management System web application. It has three types of user, those are Admin/Manager, Receptionist, Accountant. It has 7 unique features that cover all the necessities for managing billing system of any diagnostic/medical/clinic center.
Open Simple & Lightweight Infrastructure Manager
Transport Management System was a web portal which was concerned to help a user in finding the shortest route, transportation mode and fare estimate between a source and a destination. This web portal project considered the geographical location nodes and applicable fare depending upon the mode of transport and route.
The application is an online registry for patients who want to make an appointment with their local doctor.
Python Client toolkit/module for easy access of remote SQL databases managed with AceQL HTTP.
SQL Queries, MS SQL Server