This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
Triggers in T-SQL have many uses. There are right and wrong ways to write triggers. To learn the difference, read on...
In part three of this series, Boris Novikov looks at how data is saved and modified in a temporal database and what kind of integrity constraints are needed for temporal tables. If you haven’t seen parts one and two, don’t worry! Links are provided in the article, and we recommend checking them out first.
In this article on Fabric we will examine how to get data from a REST API.
Today Steve wonders how many software developers use separate connections for reads and writes in their application.
Learn how to join tables together when using the GraphQL API with Microsoft Fabric in this step-by-step article.
This next level of the Stairway to Snowflake looks at the Snowsight UI and what you can accomplish with it.
Learn about the ways in which you might better manage indexes for a better performing and efficient database.
Many of you can't choose your team, or even change teams if you want, but from an organizational perspective, it might be the right thing to do. Whether you like it or not.
Let’s start with the Stack Overflow database (any size will work), drop all the indexes on the Users table, and run a delete:
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
4. Use the Right Talismans for Stamina and Weight Synergy Talismans can help mitigate...
2. Highlight How Accountability Leads to Success Recruits are looking for programs where they...
i see this in the definition of a linked server on our wh sql...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers