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 23 (228 total posts) < 1 second(s)
  • Creating your first Dashboard with Apache Zeppelin and SQL Server/Azure SQL

    Now that Apache Zeppelin has been downloaded and configured, its time to create a dashboard. It will be very easy: all you have to do is figure out which data you want to show, write the corresponding T-SQL query and then add some charts and information to make it perfect. To create the first Apache Zeppelin dashboard, lets use the new Wide ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on January 9, 2017
  • Apache Zeppelin 0.6.2 for SQL Server Docker Image updated

    In order to be able to keep created notebooks and interpreters configurations when upgrading the docker image to a newer version, I changed the dockerfile to use docker volumes, as described here (if youre interested into learning more): Manage data in containers to run the container, now, the command is docker run --name zeppelin -p 8080:8080 ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on January 6, 2017
  • Apache Zeppelin 0.6.2 for SQL Server now with correct Syntax Highlighting

    After a little bit of work Ive managed to have syntax highlight for T-SQL in Apache Zeppelin 0.6.2 working correctly. The tricky part is that the Ace Editor already supports T-SQL specific syntax highlighting from v 1.2.0, but Apache Zeppelin is still using version v 1.1.9. Moving the v 1.2.0 doesnt work since it creates some compatibility ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on December 19, 2016
  • Configure and use Apache Zeppelin with SQL Server: the Basics

    In the previous post Ive shown how to download and run Apache Zeppelin 0.6.2 for SQL Server, using Docker to simplify the installation procedure. Its now time to start to use the fantastic Apache Zeppelin to connect to SQL Server and run some queries. This version specifically created for SQL Server, already comes with a predefined and almost ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on December 13, 2016
  • Run Apache Zeppelin 0.6.2 for SQL Server

    As promised in my last post here is the first post that aim to show how to use Apache Zeppelin with SQL Server. First thing first: installation. Or maybe not. The first thing to do, usually, is installing the product. Since were talking Java here, things may get a little bit long and complex if, like me, youre more a .NET guy. Even worse if ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on December 5, 2016
  • SQL Server Interpreter for Apache Zeppelin 0.6.2

    Ive updated the code-base to Apache Zeppelin 0.6.2 and Ive also finished a first simple-but-working support to autocomplete (you can activate it using CRTL + .). Right now the autocomplete is based on the keywords specified here: Reserved Keywords (Transact-SQL) is not much, I know, but is something, at least. Next steps will be to read ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on December 3, 2016
  • Azure Functions to Schedule SQL Azure operations

    One of the things that I miss a lot when working on SQL Azure is the ability to schedule jobs, something that one normally does via SQL Server Agent when running on premises. To execute scheduled task, on Azure, Microsoft recommends to use Azure Automation. While this is surely one way of solving the problem, I find it a little bit too complex ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on November 20, 2016
  • Temporal Tables

    I have delivered a talk about SQL Server 2016 Temporal Tables for the Pacific Northwest SQL Server User Group at the beginning of October . Slides are available on SlideShare here: http://www.slideshare.net/davidemauri/sql-server-2016-temporal-tables and the demo source code isof courseavailable on ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on October 29, 2016
  • Azure SQL Database DTU Calculator

    One of the most common questions when you start to use SQL Azure is related to the choice of the level of service needed for your needs. On the cloud every wasted resource is a tangible additional cost, so it is good to chose the best service level the fits your needs, no more and no less. You can always scale it up later if needed. The ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on September 19, 2016
  • Operator progress changes in LQS

    This has maybe gone unnoticed since August is usually a slow month, but with the August release there has been a major change in SQL Server Management Studio and how it show the Live Query Statistics data. The operator level percentages shown in the Live Query Statistics is now the ratio between actual and estimated rows, which means that the ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on September 15, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement