(Pinal Dave) I was helping a client to install SQL Server using script/automation (without using UI). They wanted to do command-line install rather than hitting next, next, fill values in the UI as they have to deploy more than 100 servers with SQL installed on it.

(Saurabh Desai) R supports a wide range of machine algorithm libraries. Using R, we can build predictive models, clustering, classification, etc. Once an R script produces output, we need a way to visualize the output and interact to explore the visualizations effectively.

(Pinal Dave) Recently one of my old clients contacted me and informed that they are having an issue with database backup on the secondary replica. In this blog we would learn about how to fix error 3636 – An error occurred while processing BackupMetadata.

(Daniel Neumann) Azure Container Registry Build is currently in preview, but it is an awesome feature of ACR. But what is ACR Build? It is a native container build capability directly integrated into the Azure Container Registry. So, we do not need container build agents anymore.

(Denny Cherry) I admit it, I still use SQL Profiler. I always have, and I will for the foreseeable future. My reasons are pretty simple.

(gdavi) Why do I want my publisher app to be a Docker image? Because I’d potentially like to be able to run the app from different environments and/or have other people run the app from their environments. Not having to rebuild or distribute the binaries would make it easier and I can be more certai

(Haroon Ashraf) Reference data is added to the SQL Server database by multiple developers and testers, thereby causing inconsistencies in the database due to reference data updated by one developer getting overwritten by another developer/tester and so on. In this tip we will look at how this can b

(Manoj) SQL Data Sync is a service built on Azure SQL Database that lets you synchronize the data you select bi-directionally across multiple SQL databases and SQL Server instances.

(Kenneth Fisher) As always with something like this, I like to start with a definition so we are all starting in the same place. From dictionary.com.

(Erin Stellato) When looking at query performance there are a lot of great sources of information within SQL Server, and one of my favorites is the query plan itself. In the last several releases, notably starting with SQL Server 2012, each new version has included more detail in the execution plans