Skip to Content

Modeling Many-to-Many relationships in SQL Server 2017 Graph Database

Posted Jun 19, 2017

By

In graph database, SQL Server 2017

Relational databases do not natively support many to many relationships although a junction table is an easy workaround. Graph databases natively support... more »
0

Father, Son, Daughter, and SQL

Posted Jun 18, 2017

By

In Off Topic, Personal, Un-SQL, Uncategorized

I don’t love Father’s Day. Mostly because I spoke to my father for the last time on Father’s day back in 1996. He wasn’t feeling well,... more »
0

Using Hyper-V for SQL Server CTP and RC Versions

Posted Jun 18, 2017

By

In Hyper-V, SQL Server 2017, Uncategorized

Yesterday at SQL Saturday I was asked how to connect to SQL Server 2017 CTP 2.1 that was running in a virtual machine by using Remote Desktop Connection. If... more »
0

We Are Part of an Awesome Community

Posted Jun 17, 2017

By

In Geek, SQL Saturday, SQL Server Community

As I type, SQL Saturday-Dublin 2017 is winding down for me. There’s a Viking Splash Tour planned for tomorrow but I’m off to London to deliver some Biml... more »
0

SQL Server 2017 Graph Database References

This is a list of references I used in creating my SQL Saturday presentation on SQL Server 2017 graph databases. To get started with the graph database... more »
0

Utility to temporarily drop FOREIGN KEY constraints on a set of tables

Posted Jun 15, 2017

By

In T-SQL, Uncategorized, Utility

I was working on a database a few weeks back (maybe longer, I am kind of busy with several projects right now), and I wanted to truncate a set of tables. There... more »
2

Announcing Data Science Daily

Posted Jun 15, 2017

By

In Uncategorized

At Data Driven we’re experimenting with new show formats – especially what we call “mini-shows.” Earlier this week we started a new feature called Data... more »
0

Introduction to Azure Cosmos DB: Microsoft’s Globally Distributed, Multi-Model Database Service

Posted Jun 15, 2017

By

In AppDev, CosmosDB, DocumentDB, NoSQL, PASS

It’s time for something NoSQL at the PASS Application Development Virtual Group. Next week Denny Lee will present on Cosmos DB, the latest evolution of... more »
0

The SQL Hall of Shame

Posted Jun 14, 2017

By

In bad, features, shame, Uncategorized

SQL Server is a big product, with lots of features. Many of the features—hopefully the vast majority of them—are solid and allow us to build trustworthy,... more »
96

Learn DAX, data modeling, and data visualization after MS Data Insight Summit #dax #powerbi #dataviz

Posted Jun 14, 2017

By

In Uncategorized

I spent three days in Seattle at Microsoft Data Insight Summit, delivering a preconference day about data modeling for business users, and two workshops about... more »
0