2020-09-15
166 reads
Database modelling
Database Modeling - Relationships
A proper relationship between two people, places or things improves the communication between them. In every real-world based application, this logic holds and a database is no different. This article discusses the different relationship types possible between database objects. The designing of these relationships between them is called modeling, and the three types of relationships […]
2020-08-31
4,724 reads
Five Online Database Modelling Services
To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialized tools that have dominated the industry for a long while are expensive and are installed on a workstation. Now that browser technology has progressed so rapidly, the online database modelling tools have become viable and are starting to attract the attention of database designers. Are they good enough to use now? Robert Sheldon finds out.
2016-03-11
4,547 reads
Blogs
Daily Coping 23 Sept 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Getting Up and Running with Dapr
By Steve Jones
I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...
Data Platform products for Microsoft gaps
By James Serra
Microsoft has a ton of data platform-related products, but there are certain areas where...
Forums
Wait type LATCH_EX [NESTING_TRANSACTION_FULL] - and blocking.
We have this ad hoc query that is a recurring block leader, blocking dozens...
ADD Values from a table to an another table
I am working with Microsoft SQL Server MANAGMENT STUDIO 18 and i Have 2...
In-Place upgrade from SQL Server 2016 to SQL Server 2019 leaves older version
My company has decided that in-place upgrading to SQL Server 2019 for test environments...
Ask SSC