It is awkward to do 'Graph databases' in SQL to explore the sort of relationships and memberships in social networks because equivalence relations are classes (a set of sets) rather than sets. However one can explore graphs in SQL if the relationship has all three of the mathematical properties needed for an equivalence relationship.
2014-08-08
9,485 reads
A brief overview of Columnstore index and its usage with an example
2014-08-07
8,098 reads
What data specific considerations do you make when preparing for performance testing?
2014-08-07
257 reads
Joe Celko & Chris Date guest as the sinister Relational Police in this new DBA Team adventure. Can the DBA Team save another doomed database? Find out.
2014-08-07
11,971 reads
Encryption brings data into a state which cannot be interpreted by anyone who does not have access to the decryption key, password, or certificates. Hashing brings a string of characters of arbitrary size into a usually shorter fixed-length value or key. Here's how to get started using it.
2014-08-06
10,471 reads
In this article, Thomas chronicles the difficulties of troubleshooting a linked server set up, with helpful tips and an exposé of a Linked Server UI flaw.
2014-08-05
5,908 reads
SQL Saturday #315 in Pittsburgh (Oct 4th) is looking for speakers - if you've got a SQL topic you want to talk about, submit it and you may get to share with your peers.
2014-08-05
8,910 reads
For date and time based testing, I use what I like to call "mock-time". The mock-time starts at what ever I set it to, but then advances along with the regular system clock. Andy Novick shows how that would work.
2014-08-05
9,532 reads
This metric creates an alert that will be raised when something is added to the schema, or the existing schema is modified.
2014-08-05
8,628 reads
The quickness at which technology has and is changing our lives and shaping our culture.
2014-08-04
61 reads
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
I am using ssrs in visual studio 2022, I work on a report, there...
Comments posted to this topic are about the item The Max PK Length
Comments posted to this topic are about the item My experience using the GitHub...
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers