Software Engineer and Database Expert
When we talk about databases, indexes are a very important feature. They help us find data quickly. But if we have duplicate indexes, it can cause some problems. First, they use more space than necessary. Imagine you have two copies of the same book on your shelf; it takes up space that you can use … Read more
In the realm of web and application development, the pairing of efficient languages with robust databases is a foundational concept. Go, often known as “Golang”, is an open-source programming language developed by Google engineers. With its simplicity, efficiency, and robustness, it has rapidly carved a niche for itself in the backdrop of backend development. SQL … Read more
The Go programming language is constantly evolving, regularly introducing new exciting features that boost development efficiency and improve code maintainability. The latest release Go 1.21 brings many exciting things, from profile-guided optimization to standard library packages for structured logging, slices and maps operations (see the full release notes for more details). But in this post … Read more
In the realm of web and application development, the pairing of efficient languages with robust databases is a foundational concept. Go, often known as “Golang”, is an open-source programming language developed by Google engineers. With its simplicity, efficiency, and robustness, it has rapidly carved a niche for itself in the backdrop of backend development. MySQL, … Read more
In the realm of web and application development, the pairing of efficient languages with robust databases is a foundational concept. Go, often known as “Golang”, is an open-source programming language developed by Google engineers. With its simplicity, efficiency, and robustness, it has rapidly carved a niche for itself in the backdrop of backend development. PostgreSQL, … Read more
MacBook Pro with Apple silicon is a great laptop for developers with impressive performance and energy efficiency, but you still could face some compatibility issues when trying to run specific software. One of such examples is running Microsoft SQL Server on Docker. What happens if you try to run it using default example command from … Read more
Imagine the situation, when you have several test suites for your application. And the problem arise, when you need to run only specific test or tests, to check the new fix, for example. There is absolutely no need to run all of them. To see, how you can do it with ScalaTest in sbt, let’s … Read more
There are two possible ways to pass command line arguments to your application when running it with SBT. The first one is to run it inside the SBT shell, and second, from your operating system terminal. They are slightly different, but let’s look at both of them. SBT shell In order to , you need … Read more
Curious about running your fist R script inside SQL Server and want to learn how it looks like? Unfortunately, it’s not a mix of R and T-SQL code, because R commands will be executed in a separate engine, which is installed with SQL Server. Therefore, sp_execute_external_script procedure is introduced with a bunch of parameters. To … Read more
Let’s discover, how to install R Services with SQL Server 2016. First, you need to check the respective component it during the installation process. In the early CTP versions it was called the Advanced Analytics Extensions, but in RTM it was renamed to R Services (In-Database). If your server is connected to the Internet, the … Read more