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

  • 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!

  • SQL Server 2016 Cumulative Updates (August 2017)

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

    Cumulative Update 4 for SQL Server 2016 SP1
     
     
    Enjoy!
  • 24 Hours of PASS (July 2017): Recordings now available!

    The sessions of the event 24 Hours of PASS "Summit Preview" edition (held the last July 2017 on 19 and 20) 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.
     
    A big THANK YOU to the Sponsors (Quest, Melissa Global Intelligence and Nutanix) who made possible the organization of this event, at no cost for participants!
     
    Sessions recorded in this edition of 24 Hours of PASS allow you to taste the main topics of the upcoming PASS Summit 2017 that will be held in Seattle (WA) from October 31 to November 03, 2017!
     
    Enjoy! 
  • 24 Hours of PASS (July 2017) - Summit Preview

    Which topics can you expect to see at the PASS Summit 2017 ? Find it out from July 19 to 20, 2017 at the 24 Hours of PASS Summit 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 October 31 to November 03, 2017.

    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... direct on your desk!

    Enjoy! 

  • How to calculate barcode check-digit using T-SQL language

    Introduction

    In order to scale, it's imperative that companies stay ahead of competition. So how can they identify, store, manage and deliver goods to customers efficiently? The answer is: Barcode! A barcode is the graphical representation of a sequence of numbers and other symbols. The representation is made by lines (bars) and spaces. A barcode typically consists of five parts – and one of these is the check character, also known as the check digit. Handwriting this is a hard work, and is also susceptible to legibility problems. Barcoding dramatically reduces human error, recognition errors and transcription errors.

    This article explores the algorithm needed to calculate the check-digit of an UCC/EAN barcode. It compares two possible implementations of the algorithm to calculate the check character for an EAN13 barcode using T-SQL language for SQL Server.

    UCC/EAN standard coding

    The UCC/EAN standard coding requires that every (well-formed) code ends with a check-digit that will be used by barcode readers to interpret the code properly. The check-digit is a number between zero and nine and it is calculated according to the other digits in the code.

    The calculation algorithm requires that every digit in the code is enumerated from right to left as shown in the following picture.

    Picture 1 – Digit position table (source GS1 https://www.gs1.org/how-calculate-check-digit-manually)

    After you have enumerated each digit of the given code, you need to do the following steps to determine the check character:

    1. Add up the digits in the even positions
    2. Multiply the result of the previous step by three
    3. Add up the digits in the odd positions
    4. Add up the results obtained in steps two and three
    5. Subtract the upper multiple of 10 from the result obtained in step four. For example, if the result of step four is 47, subtract 50 from 47, so the result is 3.

    If the result of the four step is a multiple of ten, the check-digit will be equal to zero. Otherwise the check-digit will be the result of the fifth step.

    Let's implement the algorithm using T-SQL language

    Suppose that your boss asked you to implement a T-SQL object, in an SQL Server database, that it is able to calculate the check-digit for a given EAN13 code. How can you translate the standard algorithm to T-SQL code? ..continue reading full article here.

     

    A big "Thank you" to Mia Chang for reviewing this article. 

  • SQL Server 2016 Cumulative Updates (May 2017)

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

    Enjoy!

  • 24 Hours of PASS (May 2017): Recordings now available!

    The sessions of the event 24 Hours of PASS Data Security and Data Quality edition (held the last May 2017 on 3rd and 4th) were recorded and now they are available for online streaming!

    If you have missed one session in particular or the entire event, you can view or review your preferred sessions.

    Each video is available on detail page of the related session. Thanks to the Sponsors, the 24 Hours of PASS has been presented at no cost for you!

    Enjoy the videos!

  • 24 Hours of PASS (May 2017) – Data Security and Data Quality Edition

    Why can we say that SQL Server is the least vulnerable database system for the last seven years? Find it out from May 03 to 04, 2017 at the 24 Hours of PASS "Data Security and Data Quality" edition.
     
     
    This series of one hour sessions will start at 12:00 UTC on May 3 and it will continue for 24 hours covering the following topics:
    • Data security concerning the application network
    • Database
    • Internet of things
    • Security on the cloud
    • Digital identity protection
    Register now at this link, thanks to the Sponsors, the 24 Hours of PASS is presented at no cost for you!
     
    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 free training on data security and data quality.. directly on your desk!

    Don't miss it!
  • Microsoft Data Amp

    Microsoft Data Amp is the live event that celebrates the "Data Spring" of this year, it will be held on Wednesday, April 19, 2017 at 08:00 am PT.

    During the two keynotes, Scott Guthrie (Executive Vice President, Microsoft Cloud Enterprise + Group) and Joseph Sirosh (Corporate Vice President, Data Group) will clarify why data will be even more central in the business of the companies. The event will be full of interesting announcements that will help you to catch even more benefits from the services offered by Microsoft Azure and how you can capitalize on intelligence from any data, of any size, anywhere, even across Linux and others open source technologies!

    After the keynotes there will be technical sessions on the entire Microsoft Data Platform from SQL Server to Azure Machine Learning!

    Do not miss it! Register today on Microsoft Data Amp website!

  • PASS Business Analytics Marathon (March 2017) - Recordings Available!

    The sessions of the event PASS Business Analytics Marathon, held last March 2017 on 29th, were recorded and now they are available for online streaming!

    If you have missed one session in particular or the entire event, you can view or review your preferred topics.

    Each video is available on detail page of the related session, you can find the full schedule here.

    Enjoy!

  • PASS Business Analytics Marathon (March 2017)

    The next edition of the live event PASS Business Analytics Marathon will be on March 29, 2017.

    This edition of Business Analytics Marathon will consist of five webinars on the following topics:

    • Data Driven Storytelling
    • Data Discovery
    • Power BI

    The schedule is available here.

    Thanks to the Sponsors, the event will be free of charge, register now here.

    Enjoy! 

  • SQL Saturday Pordenone is back!

    Another SQL Saturday event has been scheduled in Pordenone (Italy), it will be the SQL Saturday #589 and this year it will be more international than the previous editions because the Data Science track will be completely in English language, as some other sessions as well!

    SQL Saturday Pordenone 2017 will be on February, Saturday 25, 2017 at Consorzio Universitario di Pordenone, Via Prasecco 3/a, Pordenone (Italy).

    The agenda of the day is divided in four track (one more than the previous edition) that will deliver a total of 20 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, choosing between the paths:

    • BI/Cloud
    • Data Science
    • DBA
    • DEV

    Thanks to our Sponsors the event will be free of charge, but the registration is required.

    In addition, there will be a pre-conference day on February, Friday 24, 2017 with two workshop, one of these in English language:

    If you are around Pordenone at the end of February, or if you want to come in Italy for two days training on Data Science and BI Analytics with good food :) you are welcome!

    Registration is available here and the official Twitter hashtag is #sqlsat589.

    See you soon in Pordenone!

  • SQL Server 2016 Cumulative Updates (January 2016)

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

    Cumulative Update 4 for SQL Server 2016 RTM

    Cumulative Update 1 for SQL Server 2016 SP1

    Enjoy!

More Posts Next page »

This Blog

Syndication

Privacy Statement