• How to receive data from Google Analytics using R in Microsoft SQL Server

    • Tutorial

    In this article I want to show in detail how you can use R in Microsoft SQL Server to get data from Google Analytics (and generally from any API).


    The task — we have MS SQL server and we want to receive data in DWH by API


    We will use googleAnalyticsR package to connect to Google Analytics (GA).


    This package is chosen as an example due to its popularity. You can use another package, for example: RGoogleAnalytic.
    Approaches to problem solving will be the same.

    Read more →
  • How we created IoT system for managing solar energy usage

      If you have no idea about the development architecture and mechanical/electrical design behind IoT solutions, they could seem like "having seemingly supernatural qualities or powers". For example, if you show a working IoT system to 18th century people, they'd think it's magic.This article is sort of busting such myth. Or, to put it more technically, about hints for fine-tuning the IoT development for an awesome project in solar energy management area.

      Read more →
    • TOP-23 Language Learning Apps

        There are hundreds of language learning apps and hundreds of reviews and comparisons. Actually most of the comparisons are about the same programs. Are the apps really helpful or this is only ad and marketing? Yes, and Yes.

        I have been studying English using various methods and resources over five years. Language learning is not my greatest talent but I have achieved B2 level (from A2) using only my smartphone and PC. I found a set of features that really helps you study a foreign language. Some of them are crucial, others are just useful. Under the cut you will find a rating of the language learning apps that I composed by analyzing these features, As Objective As Possible.
        Read more →
      • 2019 National Internet Segments Reliability Research & Report



          This report explains how the outage of a single AS can affect the connectivity of the impacted region with the rest of the world, especially when it is the dominant ISP on the market. Internet connectivity at the network level is driven by interaction between autonomous systems (AS’s). As the number of alternate routes between AS’s increases, so goes the fault-resistance and stability of the internet across the network. Although some paths inevitably become more important than others, establishing as many alternate routes as possible is the only viable way to ensure an adequately robust system.

          The global connectivity of any AS, regardless of whether it is a minor provider or an international giant, depends on the quantity and quality of its paths to Tier-1 ISPs. Usually, Tier-1 implies an international company offering global IP transit service over connections to other Tier-1 providers. But there is no guarantee that such connectivity will be maintained. Only the market can motivate them to peer with other Tier-1’s to deliver the highest quality service. Is that enough? We explore this question in the IPv6 section below. For many ISPs at all levels, losing connection to just one Tier-1 peer would likely render them unreachable in some parts of the world.

          Measuring Internet Reliability


          Let’s examine a case where an AS experiences significant network degradation. We want to answer the following question: “How many AS’s in the region would lose connectivity with Tier-1 operators and their global availability along with it?”
          Read more →
        • AdBlock has stolen the banner, but banners are not teeth — they will be back

          More
          Ads
        • PVS-Studio 7.04

            Picture 4

            Summer is not only a holiday season, but also time of fruitful work. Sunny days are so inspiring that there's enough energy both for late walks and large code commits. The second summer PVS-Studio 7.04 release turned out to be quite large, so we suggest for your attention this press release, in which we'll tell you about everything.
            Read more →
          • Polygonal Mesh to B-Rep Solid Conversion: Algorithm Details and C++ Code Samples

              Boundary representation (B-rep) is the primary method of representing modeled objects in most geometric kernels, including our C3D Modeler kernel. The core algorithms that edit models, such as applying fillet operations, performing cutting operations, and obtaining flat projections require the precision of B-rep representations. The rapidly growing variety of 3D data in polygonal formats makes the task of model transformations from polygons into boundary representation increasingly relevant. As a result, we developed a new SDK, C3D B-Shaper, which is part of our C3D Toolkit.

              image
              Read more →
            • How To Install The Latest SQL Server Management Studio (SSMS)

              • Tutorial
              Hello Folks, In this chapter, we will explain to you the Step by step method to install SQL Server Management Studio (SSMS).

              Introduction

              This study demonstrates how to install & Configure the latest SQL Server Management Studio in a step by step procedure. The popular version of SSMS is 18.0.

              Installation Steps


              Step 1

              First of all, you need to download the latest version of the SQL Server Management Studio. Download the software from trusted websites.

              Step 2

              For downloading the software, click “SSMS-Setup-ENU.exe” swiftly a window will be open, click save button for saving the latest SQL Server Management Studio exe file and download will begin.

              Step 3

              check your downloaded files and you will see the .exe file. Just Double click the exe to start the installation.

              Step 5

              While Installing the system will ask the authority and permissions: “Do you want to allow the following to make a change this computer?”. Just click yes to proceed to install the latest SQL Server Management Studio.
              Read more →
            • Hidden mistakes with Shared Element Transitions



                There is a good practice to make your application beautiful and live, and nowadays there are a lot of tools and ways to achieve this. One of them is Shared Element Transition.

                In this article I’ll cover a few mistakes which have cost me a lot of time; I’ll show how to avoid them if you decide to implement this kind of transitions with Fragments on application.
                Read more →
              • System.IO.Pipelines — a little-known tool for lovers of high performance

                • Translation
                Hello reader. Quite a lot of time has passed since the release of .NET Core 2.1. And such cool innovations as Span and Memory are already widely known, you can read, see and hear a lot about them. However, unfortunately, library called System.IO.Pipeslines did not receive the same attention. Almost everything there is on this topic is the only post that have been translated and copied on many resources. There should be more information about that technology to look on it from different angles.


                Read more →
              • Flock Vs Slack: Which tool is more easy to use and highly productive?

                image

                The technology-driven world has built the current era of convenience by giving simple solutions to complex problems. It has brought many super flexible and diverse forms of applications to integrate displaced things or people on a unified platform to make things happen better. Having said that, I suggest you try to improve the work quality and increase productivity at your workplace by adopting smart solutions.


                Make conversations real-time and dynamic with the help of instant messaging applications, instead of static and long threaded confusing emails!


                Don’t just let your productive morning hours go in checking and replying those lengthy transactional emails. instead, switch to simple and easy to use team collaboration applications like Slack or Flock for the swift understanding of your work and their updates.


                The blog article of PGi says emails don’t provide collaboration features to co-ordinate work.


                Flock, a simple team messaging software, founded by a tech entrepreneur Bhavin Turakhia in the year 2014 has a notable client list from across the globe including; MERU, Policy bazaar, Crisil, Avendus, Ricoh, Gini & Jony, McDonald’s, Sodexo, etc, Flock is available across all devices, so you will never miss a thing.


                On the other side, the initial release of Slack happened in the year 2013, by its founder Stewart Butterfield and now the non-engineers built application has reached the top of silicon valley with its stock market debut of $20bn.


                Though there are so many chat applications out there, now team conversations are more seamless and organized with Troop Messenger. We had performed various in-depth analysis of our competitor’s tools to give you better insights into their pros and cons with our previous comparison blogs.


                However, this time we made our best efforts to make you know the highs and lows of two rivals: the most popular Flock and Slack.


                Read more →
              • How to get the team to search for more productive ideas

                  The creation of design models as well as visualization of solutions is for some reason always a subject of great interest among all members of a productive team, be it a manager eager to master Sketch, or a developer who wants to make cool interfaces without the need to go to a designer. But we all know what happens when it comes to actually doing stuff.



                  My way


                  Hi, everybody!

                  My name is Anna and I work for an American company Scentbird NY as a product designer. Prior to that I was involved in developing flagship products in Alfa-Bank design team.

                  I was probably born under a lucky star but all my life I've been working with the developers who suggest the best product solutions, better than a lot of product managers and product owners. But anyway, my observation is that the earlier you involve developers into working on a particular task, the better off you are.

                  What you are about to read is actually a blueprint on how to conduct brainstorm sessions and generate not-so-obvious yet effective solutions, which are apparently really easy to reach and not that time-consuming.
                  Read more →
                • Testing SQL Server code with tSQLt

                    FYI: this article is an expanded version of my talk at SQA Days #25.

                    Based on my experience with colleagues, I can state: DB code testing is not a widely spread practice. This can be potentially dangerous. DB logic is written by human beings just like all other «usual» code. So, there can be failures which can cause negative consequences for a product, business or users. Whether these are stored procedures helping backend or it is ETL modifying data in a warehouse — there is always a risk and testing helps to decrease it. I want to tell you what tSQLt is and how it helps us to test DB code.

                    Read more →
                  • What should a fitness app have?

                      Creating a fitness app would be an excellent choice for people who are exceptionally expert in the field. In this article, we are going to describe some of the essential features you should have a look upon while creating a fitness app. And there are many fitness apps available across the Google Play Store & App Store. Each application has its features based on the pricing. However, what if there aren't such features in an application, which you are in search of? Though, I will be discussing some of the crucial features to have in a fitness application and some others which will make your application stand unique when it comes to overviewing number of features.

                      image

                      Essential features of a fitness app



                      Personalized Diet plans


                      The fitness coaching application is more like a personal trainer. Customized diet plans are the most essential feature you should include in your application.
                      The personalized diet plans can be managed based on the body requirements. It will also provide an option to select the ingredients based on the recipe they want to eat.

                      Read more →
                    • How to Become a Leading Scrum Master and Rock the Team?

                        Scrum allows Agile teams working on complex projects and delivering winning products by solving problems adaptively. This popular straightforward method is widely used to handle projects and get things done. Scrum projects more accurately fulfill customers' needs because they encourage continuous feedback.

                        There is no need for detailed analytics to understand that Scrum continues to grow in popularity just because of its many benefits and general effectiveness. And the important merit in this belongs to a Scrum Master. In this post, we extol and praise the role of a Scrum Master, without which no Scrum project succeeds.

                        image
                        Read more →
                      • TOKEN2 Molto-1, world's first multi-profile TOTP hardware token

                          imageOur new product currently being finalized, the Token2 Molto-1, will expand on our technology by now supporting up to 10 Time based One-Time Password (TOTP) profiles. Earlier this year, with the miniOTP-2, miniOTP-3, and C301 we introduced the world’s first programmable TOTP tokens with time sync. The aim of these products was to provide a solution to the time drift that affects hardware tokens. We didn’t want to stop there, though! We also recognize the desire for multiple profiles which is why our latest product is a programmable multi-profile hardware token, called Token2 Molto-1. The clue is in the name, at least for anyone who understands Italian — “molto” is “many” in Italian. Having a multi-profile programmable hardware token means you can have only one device for up to 10 of your accounts.
                          Read more →