-
Updated
Jun 1, 2024 - TSQL
ssms
Here are 55 public repositories matching this topic...
Dive deep into Slowly Changing Dimensions (SCD) ETL in action with this comprehensive tutorial! In this video, we'll explore how to effectively manage changing data using SQL Server Management Studio (SSMS) and SQL Server Integration Services (SSIS).
-
Updated
Apr 15, 2024 - TSQL
This repository contains a real example of an Extract, Transform, Load (ETL) process using SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), and AdventureWorks2012 data. The objective is to load data into our LightAdventureDW data warehouse.
-
Updated
Mar 22, 2024 - TSQL
I store all my personal Data projects here :)
-
Updated
Mar 17, 2024 - TSQL
A ton of Scripts to help finding SQL Server objects, seeing important info and managing databases.
-
Updated
Mar 5, 2024 - TSQL
SQL Server scripts for automate, search, understand, and facilitate management in OuroWeb testing and development applications.
-
Updated
Mar 5, 2024 - TSQL
This LibraryDBMS was developed using T-SQL and SQL Server, utilizing Microsoft SQL Server Management Studio for managing book loans, publishers, branches, borrowers, copies, and authors. The project included tailored stored procedures for efficient and organized operations in library management.
-
Updated
Mar 5, 2024 - TSQL
Developed an SQL Server data warehouse with a 'Production' schema, enabling PowerBI reporting and sales KPI analysis.
-
Updated
Jan 29, 2024 - TSQL
Challenges that cover many core SQL skills and techniques for data engineering/analysis from beginner to advanced
-
Updated
Jan 26, 2024 - TSQL
This repositories contains the SQL Scripts which is used for Data Archiving and Purging in SQL Server
-
Updated
Dec 18, 2023 - TSQL
-
Updated
Nov 19, 2023 - TSQL
Showcase to my SQL skills about 'Stored Procedures'.
-
Updated
Nov 12, 2023 - TSQL
SQL Syntax SQL Select SQL Select Distinct SQL Where SQL And, Or, Not SQL Order By SQL Insert Into SQL Null Values SQL Update SQL Delete SQL Select Top SQL Min and Max SQL Count, Avg, Sum SQL Like SQL Wildcards SQL In SQL Between SQL Aliases SQL Joins and all topics are covered in this repo.
-
Updated
Nov 5, 2023 - TSQL
Airline Management Reservation System is a database system designed to handle various aspects of airline reservations, such as flight information, passenger details, seat availability, and booking history focusing on student benefits and group booking as part of academic project. Data reporting and visualization representation using Tableau
-
Updated
Aug 24, 2023 - TSQL
Improve this page
Add a description, image, and links to the ssms topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the ssms topic, visit your repo's landing page and select "manage topics."