Sql-Server-DBA-Toolbox
sql-server-samples
Sql-Server-DBA-Toolbox | sql-server-samples | |
---|---|---|
1 | 35 | |
91 | 9,506 | |
- | 1.1% | |
6.4 | 0.0 | |
6 days ago | 5 days ago | |
TSQL | ||
GNU General Public License v3.0 only | GNU General Public License v3.0 or later |
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
sql-server-samples
- 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?
sql-server-password-secure - Securely storing passwords in SQL-Server for C# and verifying
Northwind - Sample C#.NET web application using ASP.NET MVC, ADO.NET entity data model, MVVM, Bootstrap, and Northwind SQL Server database.
sqlserver-kit - Useful links, scripts, tools and best practice for Microsoft SQL Server Database
Samples-Aviation - Provides sample data for use in exploring InterSystems IRIS Text Analytics capabilities. Also includes sample analytics model elements.
sp_whoisactive - sp_whoisactive
babelfish_compass - Babelfish Compass: compatibility assessment tool for Babelfish for PostgreSQL
MachineIntelligence-TextAnalytics-TPLDataFlows - Machine Intelligence using OpenAI, Semantic Kernel, Vector Search, SQL Server
Visual Studio Code - Visual Studio Code
CEDS-Data-Warehouse - Modeled for longitudinal storage and reporting of P-20W data, the Common Education Data Standards (CEDS) Data Warehouse implements star schema data warehouse normalization techniques for improved query performance.
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.