GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → dbamaster → DBA-Mastery

dbamaster / DBA-Mastery

Licence: MIT license
Main repository from contributions from my blog

Programming Languages

powershell
5483 projects
Jupyter Notebook
11667 projects
TSQL
950 projects

Labels

azurenotebookssqlserver

Projects that are alternatives of or similar to DBA-Mastery

tigefa4u.github.io
🆙 for personal notes
Stars: ✭ 13 (-18.75%)
Mutual labels:  notebooks
evernote-backup
Backup & export all Evernote notes and notebooks
Stars: ✭ 104 (+550%)
Mutual labels:  notebooks
dapper-repositories
CRUD for Dapper
Stars: ✭ 523 (+3168.75%)
Mutual labels:  sqlserver
db-doc
📝一款生成在线/离线数据库文档的小工具
Stars: ✭ 98 (+512.5%)
Mutual labels:  sqlserver
migration
Simple library writen in PHP without framework dependancy for database version control. Supports Sqlite, MySql, Sql Server and Postgres
Stars: ✭ 142 (+787.5%)
Mutual labels:  sqlserver
nocodb
🔥 🔥 🔥 Open Source Airtable Alternative - turns any MySQL, Postgres, SQLite into a Spreadsheet with REST APIs.
Stars: ✭ 28,894 (+180487.5%)
Mutual labels:  sqlserver
CRUD.ASPCore.Reactjs.WebAPI.EF
CRUD Operations in ASP.NET Core application using React.js , Web API and Entity Framework core DB first approach with the help of VS 2017.
Stars: ✭ 80 (+400%)
Mutual labels:  sqlserver
lightning-tutorials
Collection of Pytorch lightning tutorial form as rich scripts automatically transformed to ipython notebooks.
Stars: ✭ 145 (+806.25%)
Mutual labels:  notebooks
Microsoft.SqlServer.Types
a .NET Standard implementation of the spatial types in `Microsoft.SqlServer.Types`
Stars: ✭ 64 (+300%)
Mutual labels:  sqlserver
sqlserver
GORM sqlserver driver
Stars: ✭ 33 (+106.25%)
Mutual labels:  sqlserver
colour-notebooks
Colour - Jupyter Notebooks
Stars: ✭ 21 (+31.25%)
Mutual labels:  notebooks
Deep-Learning-CNN-for-Image-Recognition
Google TensorFlow project for classification using images or video input.
Stars: ✭ 33 (+106.25%)
Mutual labels:  notebooks
advanced-pandas
Pandas is a powerful tool for data exploration and analysis (including timeseries).
Stars: ✭ 22 (+37.5%)
Mutual labels:  notebooks
ProductsStoreOnKubernetes
Demoing deployment of Docker containers into Kubernetes for both minikube and Azure AKS.
Stars: ✭ 90 (+462.5%)
Mutual labels:  sqlserver
erdiagram
Entity-Relationship diagram code generator library
Stars: ✭ 28 (+75%)
Mutual labels:  sqlserver
data-profiling
a set of scripts to pull meta data and data profiling metrics from relational database systems
Stars: ✭ 57 (+256.25%)
Mutual labels:  sqlserver
dbaTDPMon
dbaTDPMon - Troubleshoot Database Performance and Monitoring
Stars: ✭ 20 (+25%)
Mutual labels:  sqlserver
GraphQL.RepoDB
A set of extensions for working with HotChocolate GraphQL and Database access with micro-orms such as RepoDb (or Dapper). This extension pack provides access to key elements such as Selections/Projections, Sort arguments, & Paging arguments in a significantly simplified facade so this logic can be leveraged in the Serivces/Repositories that enca…
Stars: ✭ 25 (+56.25%)
Mutual labels:  sqlserver
python-for-excel
This is the companion repo of the O'Reilly book "Python for Excel".
Stars: ✭ 253 (+1481.25%)
Mutual labels:  notebooks
qdstoolbox
Tools for management of SQL Server's Query Store data
Stars: ✭ 39 (+143.75%)
Mutual labels:  sqlserver
View All Similar Projects ➔

N|Solid

Just another witchcraft and wizardry site and DBA tips …

Welcome to my GitHub repository, here you will find all source code of my previous and future contributions made through my blog as:

MAXDOP Calculator

This T-SQL script will help you to calculate to correct MAXDOP configuration for your SQL Server instance.

It runs starting from SQL Server 2012, for SQL Server 2016 or major it also returns the MAXDOP value configured at database level.

Azure Data Studio Notebooks

A collection of Azure Data Studio Notebooks created as POC (proof of concept), to explore the capabilities of this new cool feature. You will find examples for the following scenarios:

  • Creating a simple SQL container with Python
  • Upgrading a SQL container to the latest CU with Python
  • Troubleshooting guide with sp_WhoIsActive

MSDB Tuning

This is a simple T-SQL script that creates a set of missing indexes on MSDB database, which improves the performance of backup\restore purge process.

The execution time for sp_delete_backuphistory stored procedure dropped in 60% after adding the recommended indexes included in this script. So go ahead and try it and let us know how everything works for you!

Wait stats widget for Azure Data Studio

This T-SQL script and JSON files will help you to create a custom widget for Azure Data Studio. Please make sure to check my blog post where I explain in detail how to create this custom widget.

PerfMon for DBAs

This PowerShell script will help you to create a PerfMon data collector job in any Windows server, this first version only contains the PowerShell for the CPU counters.

Database Integrity Checker

This T-SQL script files will help you to run a DBCC CHECKDB for one or all databases from a SQL Server instance, it also identifies corruption issues for any iteration.

Orphan data files

This PowerShell script uses DBATools the DBA-GetDatafiles function, it loops through a defined list of servers looking for datafiles sitting on disk not attached to a database.

Questions?

If you have questions or comments about this demo, don't hesitate to contact me at [email protected]

Follow me

N|Solid N|Solid N|Solid N|Solid

License

MIT

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].