Data Control Language (aka Security)Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the […] 12 novembre 2024 dans Sites anglophones étiqueté Database Theory / Featured / Theory and design par simple-talk.com
TransactionsBy now, pretty much everyone has heard the stories about the first computers. They were huge, cost […] 29 octobre 2024 dans Sites anglophones étiqueté Database Theory / Featured / Theory and design par simple-talk.com
Consistency and Concurrency in NewSQL Database SystemsCompanies today require database systems that are reliable and capable of efficiently handling large volumes of data […] 18 octobre 2024 dans Sites anglophones étiqueté Big Data / Featured / Google / NewSQL / Theory and design par simple-talk.com
Rounding NumbersI would hope by now everybody has figured out when you see a price like $39.99 that […] 23 septembre 2024 dans Sites anglophones étiqueté Database Theory / Featured / Theory and design par simple-talk.com
Database Sharding: Strategies for Seamless Scaling and Performance OptimizationCompanies of all sizes and across industries are struggling to cope with an explosion of data never […] 13 septembre 2024 dans Sites anglophones étiqueté Database Design / Featured / Sharding / Theory and design par simple-talk.com
Uniqueness, Keys, and IdentityIf you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as […] 9 septembre 2024 dans Sites anglophones étiqueté Database Theory / Featured / Theory and design par simple-talk.com
Bad Data and Dirty DatabasesMany years ago, my wife and I wrote an article for Datamation, a major trade publication at […] 28 août 2024 dans Sites anglophones étiqueté Database Theory / Featured / Theory and design par simple-talk.com
LIKE ConstraintsIn this article, I will cover a bit about the LIKE operator, including how it works, and […] 19 août 2024 dans Sites anglophones étiqueté Database Theory / Featured / Theory and design par simple-talk.com
Concepts and Issues in Test Data GenerationData generation is the science and art of providing data for database development work that is as […] 10 juin 2024 dans Sites anglophones étiqueté Homepage / Test Data / Theory and design par simple-talk.com
The CHECK() ConstraintOne of the many ways a relational table differs from the file structures used by pre-relational storage […] 20 mai 2024 dans Sites anglophones étiqueté Database Theory / Homepage / Theory and design par simple-talk.com
Database Subsetting and Data ExtractionLet’s start by defining a subset and why you would require a data subset? When dealing with […] 17 avril 2024 dans Sites anglophones étiqueté Database Administration / Homepage / Theory and design par simple-talk.com
SQL LogicIn this article, I will discuss the history and thinking behind several types of logic that are […] 29 mars 2024 dans Sites anglophones étiqueté Database Theory / Homepage / Theory and design par simple-talk.com
Department of Redundancy DepartmentEver wonder all the reasons that we use databases instead of file systems? While we don’t think […] 18 mars 2024 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
Two-Dimensional Interval Packing ChallengePacking intervals is a classic SQL task that involves packing groups of intersecting intervals to their respective […] 2 janvier 2024 dans Sites anglophones étiqueté Homepage / T-SQL Programming / Theory and design par simple-talk.com
Eager Aggregation in SQL queriesAggregation is a widely used way to summarize the content of a database. It is usually expressed […] 27 décembre 2023 dans Sites anglophones étiqueté Homepage / PostGreSQL / Theory and design par simple-talk.com
Using a SQL TokenizerImagine this: you have several directories full of SQL script files, and you need to know where […] 18 décembre 2023 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
When an update doesn’t updateTell me if you’ve heard this one before: I changed data from my application, but when I […] 27 novembre 2023 dans Sites anglophones étiqueté Homepage / T-SQL Coding / T-SQL Programming / Theory and design par simple-talk.com
The NTILE FunctionThe SQL NTILE() is a window function that allows you to break a table into a specified […] 9 novembre 2023 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
First Normal Form Gets No RespectDr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 […] 5 octobre 2023 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
T-SQL Fundamentals: Controlling DuplicatesWhen people start learning a new field, for example T-SQL, it’s tempting to spend very little time […] 28 septembre 2023 dans Sites anglophones étiqueté Homepage / SummitSpeaker2023ItzikBenGan / T-SQL Programming / Theory and design par simple-talk.com
The GROUP BY ClauseWhen you’re learning SQL DML, the most complicated clause is typically the GROUP BY. It’s a fairly […] 10 juillet 2023 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
Getting Out of CharacterPre-Unicode Younger programmers have grown up with ASCII and Unicode as the only ways of representing character […] 28 février 2023 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com