THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 1 of 35 (345 total posts) < 1 second(s)
  • 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 also 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
  • BI Beginner: Using R Visualizations

    Last week I showed a simple line plot of a hypothetical college students GPA. The plot could have been done using R. Before showing you a visualization that requires the power of R, Im starting with the simple line plot recreated in R. For additional information about using R with Power BI desktop, David Iseminger has done a great job writing ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 4, 2017
  • [OT] Great American Eclipse of 2017

    Im amazed at how many people arent yet aware of the eclipse visible from the middle United States on August 21, 2017. Hotel reservations along the route are scarce and expensive. Theres a great website where you can find out all about it: https://www.greatamericaneclipse.com/ If you think that if you arent in the central United States that ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 3, 2017
  • Intel Active Management Technology Vulnerability

    Certain Intel processors have a security vulnerability that you can read about at the Intel site or at the NIST Computer Security Resource Center. Make certain that you install the latest version of the Intel vulnerability analyzer which as of today was found here. The tool tells you if your computer is vulnerable to allowing a nonprivileged user ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 2, 2017
1 2 3 4 5 Next > ... Last »
Privacy Statement