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 (348 total posts) < 1 second(s)
  • 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
  • SQL Server 2016 Import and Export Wizard and Excel

    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, the 32-bit version is invoked. The 64-bit version does not natively provide support for Excel files. Theres a lot of bad, outdated, or complex advice on how to fix the problem. I was able to ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 11, 2017
1 2 3 4 5 Next > ... Last »
Privacy Statement