THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 35 (349 total posts) < 1 second(s)
  • Your Personal Health in Information Technology

    How is your health? How is your job in information technology affecting your health? I want to know! Since I started blogging here almost a decade ago as a new Microsoft Most Valuable Professional, Ive become a registered nurse and now Im a full-time psychiatric nurse practitioner student. There are articles and studies purporting that ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on July 30, 2017
  • SQL Server Dump Analyzer

    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 you can see the results below. If you install the extension while SSMS is up and running, youll have to stop and restart SSMS in order to see the new menu option. Figure 1. SQL Server ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on July 11, 2017
  • BI Beginner: Using R Forecasting Visualization

    There are new HTML 5 enabled custom visualization for making interactive R visualizations in Power BI Desktop. Read the documentation and find the download links here. Because of the dependency on R packages that are loaded with the R library command. The end result is that your required R packages end up installed in your machines R library. ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 25, 2017
  • Cosmos DB References

    Here is a list of links to get you started in understanding Cosmos DB, Microsofts new cloud based globally distributed multi-model database. Cosmos DB development started in 2010 as project Florence. When it was initially released to the public as part of Azure, it was called DocumentDB. Multi-model means it is more than just a document database ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 24, 2017
  • Cosmos DB Podcast While You Commute

    Cosmos DB is Microsofts new Azure (i.e. Microsoft cloud) globally distributed multimodel database. There is a good podcast where Rimma Nehme explains it. Ive long wanted to blog about how to configure USB flash drives to play mp3 files on automotive sound systems. You can downloads Rimmas podcast as an mp3 available on this page. To play mp3 ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 22, 2017
  • SSMS Presenter Mode

    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 SSMS. Enter Present in to Quick Launch and select it. Figure 2. Select PresentOn. Using PresentOn is helpful when you give a presentation. It doesnt increase the size of the ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 21, 2017
  • Modeling an Adjacency List Hierarchy with SQL Server 2017 Graph Database

    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 adjacency list to a graph of one node and one edge. This is a continuation of what was started in this prior post. In the Employees table, the employees manager has an EmployeeID ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 20, 2017
  • Modeling Many-to-Many relationships in SQL Server 2017 Graph Database

    Relational databases do not natively support many to many relationships although a junction table is an easy workaround. Graph databases natively support many-to-many relationships. One of the first sample databases Microsoft provided for SQL Server was Northwind. It has three many-to-many relationships as can be seen in the entity relationship ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 19, 2017
  • Using Hyper-V for SQL Server CTP and RC Versions

    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 you want to learn how to use new software before it is released, running it in a virtual machine is a really good idea. It is wise to keep prerelease software off of your primary machine. ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 18, 2017
  • 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 features of SQL Server 2017, I recommend that you start with the following official Microsoft ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 17, 2017
1 2 3 4 5 Next > ... Last »
Privacy Statement