Skip to Content

john paul cook (167 Posts)

RSS

SQL Server Dump Analyzer

Posted July 11, 2017

By ,

In Uncategorized

Recently Microsoft released a preview version of the SQL Server Diagnostics extension to SSMS. You can read more about it here. I downloaded it from here and... more »
0

BI Beginner: Using R Forecasting Visualization

Posted June 25, 2017

By ,

In Uncategorized

There are new HTML 5 enabled custom visualization for making interactive R visualizations in Power BI Desktop. Read the documentation and find the download... more »
0

Cosmos DB References

Posted June 24, 2017

By ,

In Cosmos DB

Here is a list of links to get you started in understanding Cosmos DB, Microsoft’s new cloud based globally distributed multi-model database. Cosmos DB... more »
0

Cosmos DB Podcast While You Commute

Posted June 22, 2017

By ,

In Cosmos DB, Uncategorized

Cosmos DB is Microsoft’s new Azure (i.e. Microsoft cloud) globally distributed multimodel database. There is a good podcast where Rimma Nehme explains it.... more »
0

SSMS Presenter Mode

Posted June 21, 2017

By ,

In SSMS, Uncategorized

Recent builds of SQL Server Management Studio (SSMS) have a feature called PresentOn that can be accessed from Quick Launch. Figure 1. Quick Launch location in... more »
1

Modeling an Adjacency List Hierarchy with SQL Server 2017 Graph Database

Posted June 20, 2017

By ,

In graph database, SQL Server 2017

The Northwind database implements the manager to employee hierarchy using an adjacency list, which is a type of graph. This post shows you how to migrate the... more »
0

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

Posted June 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

Using Hyper-V for SQL Server CTP and RC Versions

Posted June 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

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

SQL Server 2016 Import and Export Wizard and Excel

Posted June 11, 2017

By ,

In SQL Server 2016, Uncategorized

SQL Server 2016 is a 64-bit application and it comes with two versions of the Import and Export Wizard. If you launch the Import/Export Wizard from the SSMS,... more »
1