Bad Idea Cowboy Hat: Using a foreign key to prevent updates
When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series (yes I asked) I decided that ... Continue reading
The post Bad Idea Cowboy Hat: Using...
2019-05-20
Database Design
Understanding Data Modeling Part 1: Models, Models Everywhere, Nor Any Time to Think
“... I needed to know what the constituent parts of data models really are. Across the board, all platforms, all models etc. Is there anything similar to atoms and...
2019-04-14
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....
2019-04-09
Graph Databases: They Who Forget the Past...
Out of the plethora of misconceptions common in the industry, quite a few are squeezed into this paragraph "The relational databases that emerged in the 80s are efficient at storing and analyzing tabular data but their underlying data model makes..."
2019-03-30
2018-12-27
1,096 reads
Degree of Duplication
Technology is constantly moving forward, but it is also helpful to understand how we arrived where we are today. Joe Celko reminisces about the history of database design and how it relates to the concept of ‘Degree of Duplication’ in this article.
2018-02-22
3,419 reads
Using Super Keys to Enforce Database Constraints
Example of Using Super Keys to Enforce Database Constraints, instead of procedural code
2017-08-07
1,831 reads
Proper Storage and Handling of Personal Names
As database developers, we may need to rethink the way we store and handle personal names
2016-08-04
2,537 reads
Design Errors : PK's with multiple columns on table with identity
Find Tables with identity, which should have PK with 1 column but have a PK with multiple columns or where the unique identity is contained in other indexes.
2015-11-24 (first published: 2015-11-04)
128 reads
Design Errors : PK's with multiple columns on table with identity
Find Tables with identity, which should have PK with 1 column but have a PK which is clustered but has multiple columns.
2015-11-24 (first published: 2015-11-04)
923 reads
Blogs
T-SQL Copy & Paste Pattern – Increasing a performance problem
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
Removing ad hoc plans from Query Store
By DesertDBA
This is not a post about the “optimize for ad hoc workloads” setting on...
Disaster recovery, tools edition
I just completed a chapter for another book where I spoke about the Recovery...
Forums
Convert Varchar to Int and SUM
Hi, need a request...it's possible to convert dbo.RE80_MOVSCHPUNTI.RE80_VALORE this table from nvarchar to INT...
TDE for Always on databases
Hi All, In terms configuring and usage of TDE encryption is there a difference...
OLE DB Destination has written 0 rows
Hi SSC, I'm having issues with one SSIS Package running on SQL Server 2017....
Ask SSC