Running Microsoft SQL Server on Docker on Apple Silicon

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

SQL Server 2016 R Services: executing R code examples

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

SQL Server 2016 R Services: offline installation and adding additional R packages

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

SQL Server 2016 R Services: introduction

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

SQL Server Query Plans: Startup Expression Predicate

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. create table dbo.startup_expression_predicate_example ( dt datetime not null, some_data char(1000) null ); insert into dbo.startup_expression_predicate_example … Read more