Understanding Data Modeling Part 4: Fact Modeling
In Part 1 we presented some foundation knowledge with which to debunk misconceptions lurking in the "data models" mess in the industry that Friesendal has tried to catalog. In...
2019-05-04
Database Design and Implementation
The Blast Radius of a database
Phil Factor feels that the database gets the short shrift in any outage - it's time to stop saying "the database has gone down" and time to start thinking about the resilience of the entire system.
2019-05-04
252 reads
Downgrading A SQL Server Database To An Older Version
"How do I restore a SQL Server backup to a previous version of SQL Server?" is a commonly-asked question. The answer, of course, is you don't - but if you must, there may be some solutions.
2019-05-03
Should I pluralize table names, is it Person, Persons, People or People?
There is a lot of confusion when it comes to designing tables in SQL Server around whether to pluralize names or not. How do you choose whether to pluralize or not?
2019-05-03
Designing Highly Scalable Database Architectures
While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and has the capability to recover from a disaster scenario. In this article, Samir Behara discusses the options available when designing the database architecture to achieve scalability.
2019-05-02
Understanding Data Modeling Part 2: "E/RM" and "RDM"
In Part 1 we presented some foundation knowledge with which to debunk misconceptions lurking in the industry's modeling mess that Friesendal has tried to map, and to show how...
2019-04-22
Understanding Your Database
Steve notes that many of us might not completely understand every part of our database, but it's information that can be helpful in cleaning out unnecessary entities.
2019-04-10
484 reads
The Cost of Useless Surrogate Keys in Relationship Tables
What’s a good natural key? This is a very difficult question for most entities when you design your schema. In some rare cases, there seems to be an “obvious” candidate, such as a variety of ISO standards.
2019-04-05
Blogs
Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic
By Devin-Knight
Welcome back to my series on Power Platform quick tips! In this episode you...
State of Database DevOps Survey
Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...
HP is the 2019 Laptop Winner
By Steve Jones
This is for me, not necessarily for you, but I decided to go with...
Forums
BUY REAL TRAVEL PASSPORT
We are a group of professionals with many years of experience in Manufacture of...
BUY REAL AND FAKE PASSPORT
We are a group of professionals with many years of experience in Manufacture of...
BUY REAL TRAVEL DOCUMENTS
We are a group of professionals with many years of experience in Manufacture of...
Ask SSC