2024-09-09
4,531 reads
git
Git, GitHub and Visual Studio Code for SQL Server
Learn how to get started with Git and Visual Studio Code.
2024-08-05
6,446 reads
A Version Control Strategy for Branch-based Database Development
The migration to a different VCS should not be underestimated, as there is a lot more involved than just switching tools, and that’s what Tonie Huizer covers in this article.
First, the team needed to migrate the monolithic repos over to Git, second the team needed to make sure we had a branching strategy and workflow in place.
It involved a big process change for the team as well, but this switch is mandatory to make full use of branch-based database development.
2023-02-08
7,275 reads
Measuring Team Performance: Calculate LeadTime metric using JIRA and GitHub data
In this article we look at how to measure lead time for development projects using Python along with GitHub and JIRA.
2021-05-19
Resolve Git Merge Conflict for SSIS Projects
When working on an SSIS project with multiple developers, a merge conflict can occur in the git repository. In this tip we'll show you how to resolve this type of conflict and provide alternative options.
2021-02-22
Gitflow Workflow Hotfix Branching for SQL Database Projects
Git is a great tool for source control and in this tip we look at how you can utilize Git source control to build and deploy database hotfixes.
2021-02-10
Feature branches and pull requests with Git to manage conflicts
Feature branching and pull requests are two important concepts when using Git. In this article, Kendra Little explains these patterns and even provides a video to demonstrate.
2020-12-30
SQL Database Project with Git Feature Branch Workflow
In this tip we look at how to work with SQL Database Projects using Git source control and using branching to work on different features.
2020-11-17
Branching in Git with SQL Database Projects
Learn how to use Git with SQL Server Data Tools to allow branching for development and how to merge development changes.
2020-10-13
Database Development with GitHub
How can you use GitHub to do team-based database development? This article proposes a process that splits development work into task-based GitHub branches, incorporates daily database builds and integration testing, and using Redgate tools to automate tasks such as provisioning, database scripting, and testing.
2020-09-25
Blogs
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
Why sys.fn_dblog Is Undocumented And Why It's Still There
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
Forums
Alamat BCA KCP Pondok Indah Telp:(0821-7555-651)
Telp/Wa 62 8217555651 Jl. Metro Pondok Indah No.60 & 61 UA, RT.4/RW.14, Pd. Pinang,...
Alamat BCA KCP Kemang Mansion Telp:0821-8200-233
Telp/Wa 62 8218200233 Shopping Arcade, The Mansion At Kemang, Jl. Kemang Raya No.3-5, RT.1/RW.7,...
Alamat BCA KCP Plaza Sentral Telp:0821-8200-203
Telp/Wa 62 8218200203 Jl. Jend. Sudirman No.Kav.47, RT.5/RW.4, Karet Semanggi, Kecamatan Setiabudi, Kota Jakarta...
Question of the Day
The Disabled Index
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers