
TomazTsql | Tomaz Doing BI & DEV With SQL Server & R
1000 FOLLOWERS
Tomaz Kastrun is a BI / DEV developer and data analyst. With more than 15 years of experience in the field of databases, business warehouses, and development, with a focus on T-SQL programming and query optimization. Follow this blog to get articles on BI & DEV with SQL Server and R, Python, Power BI, Azure, and beyond.
TomazTsql | Tomaz Doing BI & DEV With SQL Server & R
1M ago
When you are working with large datasets performance comes to everyone’s mind. Especially when converting datasets from one data type to another. And choosing the right method can make a huge difference.
So in this case, I will be creating a dummy list, and I will convert the values in the list into data.frame.
Simple function to create a large list (approx. 46MB with 250.000 elements and each element consists of 10 measurements).
cre_l <- function(len,start,end){ return(round(runif(len,start,end),8)) }
myl2 <- list()
# 250.000 elements is approx 46Mb in Size
# 2.500 elements for demo ..read more
TomazTsql | Tomaz Doing BI & DEV With SQL Server & R
1M ago
The Mandelbrot set is a set of complex numbers c for which the function does not diverge to infinity when iterate from , and therefore remains bounded in absolute value.
For little stretching, we can create a Mandlebrot set and draw it with image function.
MandelBrotImage <- function(){
cols <- colorRampPalette(c("white","black","white","grey","black"))(11)
n <- 400
x <- seq(-2, 1, length.out=250)
y <- seq(-1.5, 1.5, length.out=250)
c <- outer(x,y*1i,"+")
z <- matrix(0.0, nrow=length(x), ncol=length(y ..read more
TomazTsql | Tomaz Doing BI & DEV With SQL Server & R
1M ago
In the series of Azure Machine Learning posts:
Dec 01: What is Azure Machine Learning?
Dec 02: Creating Azure Machine Learning Workspace
Dec 03: Understanding Azure Machine Learning Studio
Dec 04: Getting data to Azure Machine Learning workspace
Dec 05: Creating compute and cluster instances in Azure Machine Learning
Dec 06: Environments in Azure Machine Learning
Dec 07: Introduction to Azure CLI and Python SDK
Dec 08: Python SDK namespaces for workspace, experiments and models
Dec 09: Python SDK namespaces for environment ..read more
TomazTsql | Tomaz Doing BI & DEV With SQL Server & R
1M ago
In the series of Azure Machine Learning posts:
Dec 01: What is Azure Machine Learning?
Dec 02: Creating Azure Machine Learning Workspace
Dec 03: Understanding Azure Machine Learning Studio
Dec 04: Getting data to Azure Machine Learning workspace
Dec 05: Creating compute and cluster instances in Azure Machine Learning
Dec 06: Environments in Azure Machine Learning
Dec 07: Introduction to Azure CLI and Python SDK
Dec 08: Python SDK namespaces for workspace, experiments and models
Dec 09: Python SDK namespaces for environment ..read more
TomazTsql | Tomaz Doing BI & DEV With SQL Server & R
1M ago
In the series of Azure Machine Learning posts:
Dec 01: What is Azure Machine Learning?
Dec 02: Creating Azure Machine Learning Workspace
Dec 03: Understanding Azure Machine Learning Studio
Dec 04: Getting data to Azure Machine Learning workspace
Dec 05: Creating compute and cluster instances in Azure Machine Learning
Dec 06: Environments in Azure Machine Learning
Dec 07: Introduction to Azure CLI and Python SDK
Dec 08: Python SDK namespaces for workspace, experiments and models
Dec 09: Python SDK namespaces for environment ..read more
TomazTsql | Tomaz Doing BI & DEV With SQL Server & R
1M ago
In the series of Azure Machine Learning posts:
Dec 01: What is Azure Machine Learning?
Dec 02: Creating Azure Machine Learning Workspace
Dec 03: Understanding Azure Machine Learning Studio
Dec 04: Getting data to Azure Machine Learning workspace
Dec 05: Creating compute and cluster instances in Azure Machine Learning
Dec 06: Environments in Azure Machine Learning
Dec 07: Introduction to Azure CLI and Python SDK
Dec 08: Python SDK namespaces for workspace, experiments and models
Dec 09: Python SDK namespaces for environment ..read more
TomazTsql | Tomaz Doing BI & DEV With SQL Server & R
1M ago
In the series of Azure Machine Learning posts:
Dec 01: What is Azure Machine Learning?
Dec 02: Creating Azure Machine Learning Workspace
Dec 03: Understanding Azure Machine Learning Studio
Dec 04: Getting data to Azure Machine Learning workspace
Dec 05: Creating compute and cluster instances in Azure Machine Learning
Dec 06: Environments in Azure Machine Learning
Dec 07: Introduction to Azure CLI and Python SDK
Dec 08: Python SDK namespaces for workspace, experiments and models
Dec 09: Python SDK namespaces for environment ..read more
TomazTsql | Tomaz Doing BI & DEV With SQL Server & R
1M ago
In the series of Azure Machine Learning posts:
Dec 01: What is Azure Machine Learning?
Dec 02: Creating Azure Machine Learning Workspace
Dec 03: Understanding Azure Machine Learning Studio
Dec 04: Getting data to Azure Machine Learning workspace
Dec 05: Creating compute and cluster instances in Azure Machine Learning
Dec 06: Environments in Azure Machine Learning
Dec 07: Introduction to Azure CLI and Python SDK
Dec 08: Python SDK namespaces for workspace, experiments and models
Dec 09: Python SDK namespaces for environment ..read more
TomazTsql | Tomaz Doing BI & DEV With SQL Server & R
1M ago
In the series of Azure Machine Learning posts:
Dec 01: What is Azure Machine Learning?
Dec 02: Creating Azure Machine Learning Workspace
Dec 03: Understanding Azure Machine Learning Studio
Dec 04: Getting data to Azure Machine Learning workspace
Dec 05: Creating compute and cluster instances in Azure Machine Learning
Dec 06: Environments in Azure Machine Learning
Dec 07: Introduction to Azure CLI and Python SDK
Dec 08: Python SDK namespaces for workspace, experiments and models
Dec 09: Python SDK namespaces for environment ..read more
TomazTsql | Tomaz Doing BI & DEV With SQL Server & R
1M ago
In the series of Azure Machine Learning posts:
Dec 01: What is Azure Machine Learning?
Dec 02: Creating Azure Machine Learning Workspace
Dec 03: Understanding Azure Machine Learning Studio
Dec 04: Getting data to Azure Machine Learning workspace
Dec 05: Creating compute and cluster instances in Azure Machine Learning
Dec 06: Environments in Azure Machine Learning
Dec 07: Introduction to Azure CLI and Python SDK
Dec 08: Python SDK namespaces for workspace, experiments and models
Dec 09: Python SDK namespaces for environment ..read more