THE SQL Server Blog Spot on the Web

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

Sergio Govoni

A place where share my experience on SQL Server and related technologies

  • Microsoft Docs and Localization Community Platform

    Microsoft Docs is the new platform for sharing high quality technical documentation about Microsoft technologies and related products.

    The documentation is hosted on GitHub and it is open to changes.

    Now, technical communities around the world have the opportunity to improve the quality of the documentation localized in different languages. You can also activate the process of editing the original articles on Docs. How many times have you thought that some technical translations could be improved? Today we have the opportunity to do it!

    Contributing to the improvement of Microsoft Docs is very simple, you can find the (English) guide prepared by Aldo Donetti here. It is also possible to contribute to the localization of Open Source products. Nowadays, projects available for community localization are:

    • VS Code
    • SQL Tools on Linux
    • TEE
    • SQL Operations Studio
    • Developer Tools
    • Batch Explorer

    The guide that explains how to access and use Microsoft Localization Community Platform is available here.

    Transifex is used to localize Visual Studio Code, you can find all details to log-in and start contributing here.

    Do you want to improve Microsoft documentation and the localization of Open Source products in your language? Today you have the opportunity to do it!

    Enjoy the Microsoft Docs! 

  • PASS Summit is back! Let's talk about the 2018 edition!

    PASS Summit is back! This year, the most important event around the world about Microsoft Data Platform will be held again in Seattle (WA) from 6 to 9 of November 2018 and it will be preceded from two pre-conference days at November 5 and 6.

    Every year more and more IT Professionals, Technicians, Analysts and Data Scientists consider this event as an unique opportunity to connect to other people, from all over the world, with a passion for data, share their experiences and learn even more about the Microsoft Data Platform.

    Do not forget that you will also have the opportunity to meet people that work in the SQL Server Product Team. I want to tell you my experience at PASS Summit 2017. Last year I prepared a session on SQL Graph in SQL Server 2017. While I was working on the demos, I did not understand a behavior of the T-SQL MATCH clause (for who are new with SQL Graph, MATCH clause allows you to specifies a search condition for a graph). Chatting by emails with Shreya Verma (PM at Microsoft SQL Server) she said me something like this:

    "Sergio, If you will be at PASS Summit 2017, we will meet and talk about your doubts on this feature".

    At the end.. I met Shreya, she clarified my doubts in a very interesting exchange of opinions about SQL Graph Database. She also offered me the opportunity to contribute to the GitHub Microsoft/sql-server-samples repository, this is the result:

    I also spent some time in the area dedicated to the SQL Clinic, where people from SQLCAT team are available to clarify doubts and answer technical questions. I spoke with my friend Saverio Lorenzini and his colleagues from Redmond about Indexing Strategies, Trace Flag (documented or not) for monitoring Deadlocks and many other things! 

    What other event gives you the opportunity to discuss about these topics with such people? There are not any others!

    Are you thinking these people are too busy for a talk with you? Nobody of these names from SQL Server Product Team walk away if you try to meet and talk them, especially in front of a beer in one of Seattle's pubs!

    SQL Server 2017 is out, it has amazing features, it runs both on Windows and Linux, this conference is a great opportunity to explore the new features of SQL Server 2017 and to understand better the features already released in the previous versions as well.

    If you are undecided about the quality of the content provided at PASS Summit, you can watch the sessions of the previous year on PASS TV, next you will have no doubts!

    Are you a beginner with SQL Server? Or a "first timer" at PASS Summit? Do not worry there are many sessions of level 100 and 200, and first timer can count on the "First Timers Guidebook" that it will arrive soon!

    What kind of sessions can you expect to find at the PASS Summit 2018? Find it out by the recording sessions of the last 24 Hours of PASS named "Summit Preview", each video is available on detail page of the related session. Read my specific blog post here.

    You can find all information you need about PASS Summit on PASS website, for your convenience, here some useful links:


    Discount code for UGISS (Italian User Group of SQL Server) members

    If you have not already done, sign up for free and join to the Italian SQL Server User Group. UGISS, as an official PASS Local Group, allows you to have a special discount: $150 off on the registration fee. To obtain the discount, specify the following code in the registration page:

    See you in Seattle!

     

  • 24 Hours of PASS (June 2018) - Recordings now available!

    The sessions of the event 24 Hours of PASS Summit Preview edition (held this June on 12 and 13) were recorded and now they are available for streaming on-demand!
     
    If you have missed one session or the entire event, you can view or review your preferred talk or topic. Each video is available on the detail page of the related session, sign in is mandatory. Aren't you a SQL PASS member, yet? Don't worry you can sign it up here for free!

    A big "THANK YOU" to the Sponsors who made possible the organization of this event, free for participants!

    Enjoy!
  • 24 Hours of PASS (June 2018) - Summit Preview

    Which topics can you expect to see at the PASS Summit 2018? Find it out from June 12 to 13, 2018 at the 24 Hours of PASS - Summit 2018 Preview - edition.

    Register now at this link, thanks to the Sponsors, the 24 Hours of PASS is presented at no cost for you!

    This edition of 24 Hours of PASS wants to be a sneak taste of what you can expect from the next PASS Summit that will be in Seattle (WA) from November 6th to 9th, 2018.

    No matter from what part of the world you will follow the event, the important thing is to know that they will be 24 hours of continuous training on Microsoft Data Platform (Performance Tuning, Azure Data Lake, Digital Storytelling, Advanced R, Power BI and more!), direct on your desk!

    Enjoy!

  • 24 Hours of PASS (April 2018): Recordings now available!

    The Sessions of the event 24 Hours of PASS "Cross-Platform SQL Server Management" edition (held this April on 25 and 26) were recorded and now they are available for online streaming!

    If you have missed one session or the entire event, you can view or review your preferred talk or topic. Each video is available on the detail page of the related session, sign in is mandatory. Aren't you a SQL PASS member, yet? Don't worry you can sign it up here for free!

    A big "THANK YOU" to the Sponsors (Microsoft, Quest, IDERA, SentryOne e Redgate) who made possible the organization of this event, free for participants!

    Enjoy!

  • SQL Server 2016 Service Pack 2 (SP2) has been released!

    The Service Pack 2 of SQL Server 2016 has been released!

    From the SQL Server Release Services, this service pack contains:

    • Performance and scale improvements
    • Supportability and diagnostics enhancements
    • New improvements based on Connect feedback items
    • Some improvements originally introduced in SQL Server 2014 SP2 and SQL Server 2012 SP4
    • All the fixes up to SQL Server 2016 SP1 CU8

    All the details are listed in this article.

    You can download the SP2 of SQL Server 2016 here:

    The Service Pack 2 installation is recommended, but installing this service pack may require rebooting the instance!

  • PASS Marathon GDPR Edition: Recordings now available!

    You have certainly already heard about the new European Regulation 679/2016, better known as GDPR, on the protection of personal data.
     
    GDPR is the acronym of General Data Protection Regulation, companies and professionals are required, by May 25 (2018) to comply with the new rules on personal data protection.

    "The aim of the GDPR is to protect all EU citizens from privacy and data breaches in an increasingly data-driven world that is vastly different from the time in which the 1995 directive was established. Although the key principles of data privacy still hold true to the previous directive, many changes have been proposed to the regulatory policies; the key points of the GDPR as well as information on the impacts it will have on business can be found below" - https://www.eugdpr.org/key-changes.html 

    Were you unable to attend the PASS Marathon in partnership with Redgate to understand what the GDPR entails? Don't worry, the sessions of the event PASS Marathon GDPR Edition (held the last March 2018 on 13th) were recorded and now they are available for online streaming!
     

    If you have missed one session or the entire event, you can view or review your preferred talk.
     
    Each video is available on the schedule page of the event.
     
    Enjoy the videos! 
  • Developing product recommendations on WideWorldImporters using SQL Graph

    SQL Server has always provided tools to manage hierarchies and relationships, facilitating query execution on hierarchical data, but sometimes relationships can become complex. Think about many-to-many relationships, relational databases don't have a native solution for many-to-many associations. A common approach to realize many-to-many associations is to introduce a table that holds such relationships.

    SQL Server 2017, thanks to the Graph Database, can express certain kinds of queries more easily than a relational database by transforming complex relationships into graphs.

    The graphs theory is not new in the computer world, the first commercial proposals are dating in the year of 2000 by Neo4J, OrientDB, Oracle Spatial, Graph, etc. Recently, thanks to some of the world's largest internet companies and to the new data processing and analysis requirements, this new class of Object-Oriented Database Management Systems (ODBMS) is receiving a strong impulse.

    Today we need to navigate through segments of data quickly and describe how each piece of data is connected to each other by an interconnected logic. A Graph Database is a collection of Nodes and Edges where each node represents an entity and each edge represents a relationship between two nodes with a direction (for example from Node A to Node B).

    A few days ago, Microsoft has merged the pull request I have done on the repository Microsoft/sql-server-samples on GitHub. "This repository contains code samples that demonstrate how to use Microsoft's SQL products including SQL Server, Azure SQL Database, and Azure SQL Data Warehouse. Each sample includes a README file that explains how to run and use the sample".

    My sample explains what Graph Database is and which scenarios it solves easily, they are available here.

    As you can see, the publishment consists of three demos. In the first one, I shown how to create graph objects such as Nodes and Edges. The second demo allows you to do a first look to the T-SQL MATCH clause used to perform some query on Nodes and Edges created in the first demo. In the last demo I shown how to build a recommendation system for sales offers that is able to determine the recommended products based on the product a customer is purchasing.

    Have you heard about the Graph Database and want to know more? These examples are a good place to start!

    Enjoy the SQL Graph! 

  • SQL Server Cumulative Updates (January 2018)

    Microsoft has released the following Cumulative Updates for SQL Server:

    Cumulative Update 3 for SQL Server 2017 RTM


    Cumulative Update 7 for SQL Server 2016 SP1


    Cumulative Update 10 for SQL Server 2014 SP2

    Enjoy!

  • SQL Saturday Pordenone is back! Discover the 2018 edition!

    Another SQL Saturday has been scheduled in Pordenone (Italy), it will be the SQL Saturday #707, as last year it will be an international event with international speakers and several sessions in English language!
     
     
    SQL Saturday Pordenone 2018 will be on February, Saturday 17 at Consorzio Universitario di Pordenone, Via Prasecco 3/a, Pordenone (Italy).
     
    The agenda of the day is divided in four track that will deliver a total of 24 hours of free training on SQL Server, Business Intelligence, Microsoft Azure and Data Science! You will learn more about topics that you use every day rather than learn something about technologies that you don't use yet.
     
    Thanks to our Sponsors the event will be free of charge for you, but the registration is mandatory.
     
    If you are around Pordenone at the end of February, or if you want to come in Italy for a weekend of training on Microsoft Data Platform with friends, #sqlfamily and good food :) you are welcome!
     
    Registration is available here and the official Twitter hashtag is #sqlsat707.
     
    See you in Pordenone!
  • Azure Data Lake Store library for Delphi

    From Microsoft-Docs on GitHub: Azure Data Lake Store is an enterprise-wide hyper-scale repository for big data analytic workloads. Azure Data Lake enables you to capture data of any size, type, and ingestion speed in one single place for operational and exploratory analytics.

    Because I'm a Delphi developer, Microsoft Data Platform MVP since 2010 and because (in my opinion) there are poor documentation about the integration between the Delphi programming language and Microsoft Azure services, I decided to do something for help Delphi developers to use Microsoft Services and Products. I developed a REST sample library to connect and manage files into an instance of Azure Data Lake Store.

    The sample library is intended for Delphi developers those want to build applications and services that are able to connect to Azure Data Lake Store. At the moment the libraty shows how to:

    • Retrieve an access token using REST Client components
    • Retrieve folders list
    • Upload files to a specific folder

    The first version of my ADLSLibrary4Delphi, with source code, is available on my GitHub repository named azure-data-lake-store-for-delphi.

    If you want to contribute in the project, you are welcome!

    Enjoy! 

  • SQL Server 2016 Cumulative Updates (November 2017)

    Microsoft has released the following Cumulative Updates for SQL Server 2016 (RTM and SP1).

    Cumulative Update 9 for SQL Server 2016 RTM

    Cumulative Update 6 for SQL Server 2016 SP1

  • SQL Server 2012 Service Pack 4

    The Service Pack 4 of SQL Server 2012 has been released!

    This service pack contains:

    • More than 20 improvements around performance and scalability
    • All fixes released up to and including the Cumulative Update 10 for SQL Server 2012 SP3

    The most important features are listed in this article:

    You can download the SP4 of SQL Server 2012 here:

    The Service Pack 4 installation is recommended, but installing this service pack may require rebooting the instance!

  • SQL Saturday Parma is back! #sqlsat675

    Another SQL Saturday has been scheduled in Parma (Italy), it's the SQL Saturday #675 and this year it will be more international than the previous editions because there will be six sessions completely in English (= 1 "virtual" track in English).
     
     
    SQL Saturday Parma 2017 will be on November, Saturday 18, 2017 at Università degli Studi di Parma, Dipartimento di Ingegneria dell'Informazione.

    The agenda of the day is divided in four tracks (one more than the previous edition) that will deliver a total of 24 hours of free training on SQL Server, Data Science and Cloud Application! You will learn more about topics that you use every day rather than learn something about technologies that you don't use yet, choosing between these paths:
    • Cloud Application Development & Deployment
    • Data Science
    • Database Administration
    • Development
    Thanks to our Sponsors the event will be free of charge, but the registration is mandatory!
     
    If you are around Parma in the middle of November, or if you want to come in Italy for a day of training on Microsoft Data Platform with good foods and friends, you are welcome!
     
    The registration is open, register now here, let know us that you will be at the event, the official twitter hashtag is #sqlsat675 and our official twitter account is @SqlsaturdayP.

    Greetings from Italy, see you soon in Parma!
  • PASS Summit is back! Discover the edition 2017!

    The PASS Summit is back! The most important event around the world on Microsoft Data Platform will be held again in Seattle (WA) from October 31 to November 3, 2017 and it will be preceded from two "pre-conference" at October 30th and 31th.

    Every year more and more IT Professionals, Technicians, Analysts and Data Scientists consider this event as an unique opportunity to connect other people that have the same passion you have, to share the experiences and problems you face for your job and to learn more and more about the Microsoft Data Platform.. so the keywords are Connect, Share and Learn!

    Do not forget that you will also have the opportunity to meet people that work in the SQL Server development Team. Just a few days ago, while I was playing with SQL Graph, one of the new features of SQL Server 2017, I did not explain a behavior of a MATCH query. MATCH clause is the new clause for traverse a graph in a SQL Graph Database. Chatting with Shreya Verma (Program Manager at Microsoft SQL Server, with particular focus on Query Processing) and Arvind Shyamsundar (Principal Program Manager at Microsoft), they clarified my doubts, and at the end, this sentence came out:

    "Yes Sergio! Shreya and I will be at PASS Summit 2017, so definitely we will meet!"

    What other event gives you the opportunity to discuss about these topics with people from SQL Server Team? There are not any others! Are you thinking that people from SQL Server Team are too busy for a talk with you? Nobody of these names walks away if you try to meet and talk them, especially in front of a beer in one of Seattle's pubs!

    SQL Server 2017 (today the in RC2 version) is coming and this conference is a great opportunity both to explore the new features of SQL 2017 and to study the features already released in previous versions of SQL Server.

    If you are undecided about the quality of the contents provided at the PASS Summit, you can watch the sessions of the previous Summit on PASS TV:

    Are you a beginner or a first timer at PASS Summit? Do not worry there are many sessions of level 100 and 200, and you can count on the "First Timers Guidebook" that it will arrive soon!

    What kind of sessions can you expect to see at the PASS Summit 2017? Find it out by the recording sessions of the last 24 Hours of PASS named Summit Preview, each video is available on detail page of the related session.

    You can find all information you need on PASS Summit 2017 website and for your convenience, here some useful links:


    Discount code for UGISS members

    If you have not already done, sign up for free and join to the Italian SQL Server User Group. UGISS, as an official PASS Local Group, allows you to have a special discount for $150 off on the registration fee. To obtain the discount, specify the following code in the registration page (section "Agenda"):

     

    See you in Seattle!

More Posts Next page »

This Blog

Syndication

Privacy Statement