2021-10-08
2,125 reads
Database Design
Much Ado about nothing: missing data
Joe Celko explains how missing data is handled from the printing press to databases.
2021-07-26
Constraints and declarative referential integrity
Database systems have powerful features built right in that can ensure the integrity of data. In this article, Joe Celko discusses keys and constraints.
2021-05-28
Creating Database Build Artifacts when Running Flyway Migrations
This article provides PowerShell automation scripts for running Flyway database migrations. These scripts use SQL Compare to automatically generate all the required database build artifacts in the version control system, for each Flyway deployment.
2021-04-26
Customizing Database Deployments using Flyway Callbacks and Placeholders
How to customize a database deployment process using Flyway, demonstrating how to incorporate tasks such stamping a version number into the latest database build, or writing to the SQL Server log.
2021-02-26
Implementation of Normalization in SQL Server
Introduction In my last article, Discussion on Normalization and Database Design Concepts, I discussed about the normalization concepts. Here, I will take one table in SQL Server and implement different normal forms. As we move up the higher normal forms, we end up on more number of tables. Implementation of Normal Forms Let us start […]
2021-02-22
4,498 reads
Blogs
Spark Connect Dotnet November 2024 Where are we?
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
A New Word: Ochisia
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
Create a Numbers Table in Power Query
This is a quick blog post, mainly so I have the code available if...
Forums
BUY REAL PASSPORTS,VISA,DRIVERS LICENSE,GMAT,IELTS,PLAB 1&2 CERTIFICATES, BUY IE
BUY REAL PASSPORTS,VISA,DRIVERS LICENSE,GMAT,IELTS,PLAB 1&2 CERTIFICATES, BUY IELTS,GRE,TOEIC,TOEFL,PET, FCE,CAE, CPE, BEC,YLE, KET,BULA TS,ILEC, ICFEWhatsApp:+1...
BUY REAL PASSPORTS,VISA,DRIVERS LICENSE,GMAT,IELTS,PLAB 1&2 CERTIFICATES, BUY IE
BUY REAL PASSPORTS,VISA,DRIVERS LICENSE,GMAT,IELTS,PLAB 1&2 CERTIFICATES, BUY IELTS,GRE,TOEIC,TOEFL,PET, FCE,CAE, CPE, BEC,YLE, KET,BULA TS,ILEC, ICFEWhatsApp:+1...
BUY REAL PASSPORTS,VISA,DRIVERS LICENSE,GMAT,IELTS,PLAB 1&2 CERTIFICATES, BUY IE
BUY REAL PASSPORTS,VISA,DRIVERS LICENSE,GMAT,IELTS,PLAB 1&2 CERTIFICATES, BUY IELTS,GRE,TOEIC,TOEFL,PET, FCE,CAE, CPE, BEC,YLE, KET,BULA TS,ILEC, ICFEWhatsApp:+1...
Question of the Day
The Density Vector
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers