Sql-Server-DBA-Toolbox
A box of tricks (SQL scripts) that I've built up over many years for Microsoft SQL Server instance and database administration, and general working-with-data. (by DavidSchanzer)
sql-server-samples
Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge (by microsoft)
| Sql-Server-DBA-Toolbox | sql-server-samples | |
|---|---|---|
| 1 | 35 | |
| 281 | 10,626 | |
| 0.7% | 0.5% | |
| 7.1 | 9.1 | |
| 9 months ago | 25 days ago | |
| TSQL | ||
| GNU General Public License v3.0 only | GNU General Public License v3.0 or later |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Sql-Server-DBA-Toolbox
Posts with mentions or reviews of Sql-Server-DBA-Toolbox.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-03-30.
sql-server-samples
Posts with mentions or reviews of sql-server-samples.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-12-06.
- Are there any “real-like” large size databases I can download to practice SQL ? What do you recommend?
-
Create a stored procedure with Sql Server
Download .bak file from here
-
User-Defined Functions in SQL: Expanding Your Database Toolkit
I will be using Microsoft SQL Server to do the demo in this article, while also using some data readily available online - AdventureWorksDW2014
-
MS Azure SQL Database Demo
All the Microsoft AzSQL PG canned samples are here. https://github.com/microsoft/sql-server-samples/tree/master/samples
-
Sql Serve automatic replication inside k8s
Hello Guys, Yesterday I spend whole day configuring sql server image (mcr.microsoft.com/mssql/server:2022-latest) to be automatically replicated in k8s. That was not successful (not sure if I was even close to completion). I want to deploy manifests of statefulset of mssql server where mssql-0 is primary readwrite, and others are secondary readonly. I know some basics of sql server as developer, but I am not a dba, so not good in types of replication topics of sql server such as Mirroring, HADR, etc. I just want to deploy this stack with one command (all manifests with configuration and maybe some postStart hooks). I haven't found any useful link to help me with that(all of them showing the "easiest way" with manual configuration, but I don't want to use manual configuration). I used some configuration from here https://github.com/microsoft/sql-server-samples/tree/master/samples/containers/replication But the problem that I want to automate this fully. And this sample is not working properly and uses docker compose insted of k8s Any ideas or if you maybe have manifests already created for mssql replication.
- MSSQL (SQL Server) Replication
-
Exploring EF Core Updates Land: Join Us on an Exciting Journey
The Worldwide Database Sample is available for download from the Microsoft website, and it includes documentation and sample queries to help users get started. It is a useful resource for anyone looking to gain practical experience with SQL Server and to explore the capabilities of the platform.
- Hello all. Database Question. Any public databases to download that are sql server db's
-
Raw Data Sources for Practise in Building Databases
The Microsoft sample databases are available here (I use these extensively for demos)
- How was this demo data warehouse created?
What are some alternatives?
When comparing Sql-Server-DBA-Toolbox and sql-server-samples you can also consider the following projects:
MachineIntelligence-TextAnalytics-TPLDataFlows - Machine Intelligence using OpenAI, Semantic Kernel, Vector Search, SQL Server
milliondigits - In 1955, RAND Corporation published a book of a “million random digits”; this code is a modern attempt to reproduce the analysis that was originally conducted on punchcards. This new analysis does not indicate that the original digits are nonrandom or flawed, but there are small differences between the original and this reproduction.
sql-server-password-secure - Securely storing passwords in SQL-Server for C# and verifying
Samples-Aviation - Provides sample data for use in exploring InterSystems IRIS Text Analytics capabilities. Also includes sample analytics model elements.
sqlserver-kit - Useful links, scripts, tools and best practice for Microsoft SQL Server Database
Northwind - Sample C#.NET web application using ASP.NET MVC, ADO.NET entity data model, MVVM, Bootstrap, and Northwind SQL Server database.