Software Engineer and Database Expert
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
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
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
This article is a short introduction to R programming language and a new R Services feature in SQL Server 2016. I hope, it will be a good starting point for those, who haven’t heard about it at all. R is a software environment and programming language for statistical computing, predictive analytics, and rich graphics. R can … Read more
I’ve already posted about predicates in query plans, but here is one more: Startup Expression Predicate. Again, it’s better to illustrate its behavior by example. Let’s create a small table with one clustered index and put some data into it. Now, look at the following query. It should calculate the amount of rows in the … Read more
If you have ever written any query with a predicate, you should have noticed, that, at first, the optimizer is trying to find the smallest indexes, and then try to push predicate down to the get data operators to minimize the amount of logical and physical reads. To illustrate this behavior, let’s look at the example … Read more
Many of you at least should have heard about Max Degree of Parallelism setting, which exists in SQL Server from the early versions. By default, its value is zero, which means that SQL Server determines by itself the optimal number of threads for your queries. However, let us go a little bit further and delve … Read more