Testing SQL Server code with tSQLt
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.
How to use MIDI for web in short
MIDI player
- Use MIDI parser to read notes from MIDI file
- Use WebAudioFont to play musical instruments in a browser
- See result
10 Popular PHP frameworks in 2019
PHP, or hypertext preprocessor, is an open-source server-side scripting language. It’s extremely popular, too — almost 80% of all websites were using PHP as of October 2018.
But how do you know which PHP framework is right for you?
Web Worker easier than you thought
In this article, a DIRTY, unsafe, unstable and scary <em>eval</em>
method will be described. So, if you are uncomfortable with that, stop reading right now.
First off, some issues with convenience remained unresolved: in code sent to web web workers, closure can't be used.
All of us like new technologies, and all of us like new technologies to be convenient to use. However, it's not exactly the case with web workers. web workers accept files or links to files, which isn't convenient. It would be good to be able to put any task into web workers, not just specifically planned code.
What do we need to make web workers more convenient to operate? I believe, it's the following:
- A possibility to launch in web workers any code at any moment
- A possibility to send to web workers complicated data (class instances, functions)
- A possibility to receive a promise with a reply from a web worker.
SCADA visualization for IoT projects [Free Library]
Original article — IoT dashboard library: visualize SCADA at a snap [Free IoT library]
We often use awesome Qt framework for implementing complex IoT solutions. For a bunch SCADA and SCADA-like projects, we came across the need for quick tool for developing device dashboards. That’s why we developed super lightweight unofficial Qt library. The library is open source, customizable, and free to use under MIT license. We also share a small set of developed widgets.
How Gantt Charts Simplify and Empower Project Management
Gantt Charts assist project managers and their teams to improve their productivity and efficiency of workflows and ensure timely tasks execution. The charts can be applied to small projects and the most complex ones. What are the secrets of the diagrams developed by Henry Gantt and what people in project management used before they were created?
5 Methods to Run an Effective Brainstorm
Where does the team path to success begin? In this post, we share ten essential tips on how to improve team meeting discussions and describe five powerful methods that accelerate brainstorming sessions. IT professionals, this will perfectly suit you too.
How do you choose products in stores?
The most important single ingredient in the formula of success is knowing how to get along with people. Theodore Roosevelt
In the previous article I tried to cover the basics of pricing analytics. Now I'd like to talk about something more interesting.
Have you ever thought about why you choose certain products in stores, why you prefer them to other similar ones? Many shopping trips are spontaneous, so it's probably impossible to give a clear answer for all the times you go shopping. But the general idea is obvious: you go shopping for a specific reason (to get food, a gadget, for entertainment, to play blackjack). In this article I'm going to use available data from grocery retailers to talk about how a set of basic logical assumptions and community analysis can help us determine the way customers choose products.
Most Popular Computer Problems We Are Facing Everyday
Even those few persons who don't use computers in their daily work life can possibly have access to a computer on that they perform alternative necessary tasks.
With all of the access to info that computers permit and with all of the work they will facilitate a personal perform, this trend of a computer in every home and in each workplace of business isn't shocking.
But what may be shocking, and downright aggravating, is when the computer you are working on suddenly shuts off, goes blank, or explodes in the dreaded blue screen of death.
These and other common computer problems are among the most frequently occurring issues that one might experience with their computers.
The following may be a list of 5 common Computer issues and what may be done to mend them.
Why LLVM may call a never called function?
I don’t care what your dragon’s said, it’s a lie. Dragons lie. You don’t know what’s waiting for you on the other side.This article is based on the post in the Krister Walfridsson’s blog, “Why undefined behavior may call a never called function?”.
Michael Swanwick, The Iron Dragon’s Daughter
The article draws a simple conclusion: undefined behavior in a compiler can do anything, even something absolutely unexpected. In this article, I examine the internal mechanism of this optimization works.
Marketing with ML decision making
Visual Studio tips and tricks
Debugger
Hitting F10 to build, run, and attach debugger instead of F5 will automatically break on the first time your own code is being executed. No breakpoints needed.
Supported from Visual Studio 2005
Reattach to process (Shift+Alt+P) is extremely helpful when you have to attach to the same process again and again.
Supported from Visual Studio 2017 v15.8
A blue dot in the margin indicates a switch of threads while stepping through debugging.
Supported from Visual Studio 2013
How to Repair a Backyard Swimming Pool in 7 Hours Using the Critical Path Method?
What is the value of determining the critical path and why is the critical path method (CPM) necessary? In this post, the example of how to determine the critical path. So, let's repair the old backyard swimming pool with the help of CPM.
Azure IoT Edge Tools Extension (Preview) Announcement
We’re excited to announce the preview availability of the new Azure IoT Edge Tools Extension (Preview) for Visual Studio 2019. The extension provides a rich set of functionalities to support development of IoT Edge solutions with Visual Studio 2019:
Porting desktop apps to .NET Core
Since I’ve been working with the community on porting desktop applications from .NET Framework to .NET Core, I’ve noticed that there are two camps of folks: some want a very simple and short list of instructions to get their apps ported to .NET Core while others prefer a more principled approach with more background information. Instead of writing up a “Swiss Army knife”-document, we are going to publish two blog posts, one for each camp:
- This post is the simple case. It’s focused on simple instructions and smaller applications and is the easiest way to move your app to .NET Core.
- We will publish another post for more complicated cases. This post will focus more on non-trivial applications, such WPF application with dependencies on WCF and third-party UI packages.
If you prefer watching videos instead of reading, here is the video where I do everything that is described below.
What are the application areas of 3D printing?
What is 3D printing?
3D printing is a new way of manufacturing solid objects based on the principle of discrete-stacking.
With the evolution of the trend, 3D printing has become a way to promote smart manufacturing, flexible manufacturing and green manufacturing. It can realize the integrated formation of complex structures that are difficult to process or even cannot be processed by traditional manufacturing technologies, greatly enhancing the process realization capability. Subversive advancement in equipment design and manufacturing.
From the past used to manufacture models, and now gradually realize the direct manufacturing of products, 3D printing manufacturing technology is developing towards the integration of “design-material-manufacturing”. According to research, the size of the world 3D printing market in 2017 was 3.86 billion US dollars. In 2018, the scale of China's 3D printing market was as high as 7.75 billion US dollars, which has more than doubled in two years. From behind the scenes to the forefront of the industry, the development of the 3D printing industry has moved from the concept introduction period to the rapid development period, all thanks to: "application." Members of the World 3D Printing Association have said:
“When 3D printing technology goes out of the lab,
Its development motivation lies in its application”
How to run Scrum efficiently in 2019? Quick guide for beginners
People go mad about Scrum: many IT blogs write about it, many practical courses promise to teach all Scrum features, many companies want to see a working experience with Scrum in CVs, and so on. Scrum conquers them all. In this post, we define why.
Advantages and Disadvantages of Using Flutter for Mobile Development
Flutter is a new open source framework created by Google that assists in developing native Android as well as iOS apps with one codebase. It is more than just a framework as it is a full software development kit that has everything you require for building cross-platform apps. This Flutter review will look into the advantages and disadvantages of the tool.
Rebuilding an icon: a call for the sharing of open data to help restore Notre-Dame
Since its completion more than 675 years ago, the medieval cathedral of Notre-Dame has captivated millions of people with its incomparable beauty. From its legendary stained glass rose window to its towering spire, it’s widely regarded as one of the most stunning examples of medieval architecture in history.