Install R in 5,4,3,2,1…

Install R and RStudio on Windows 7, 8, and 10 1. Download R from http://cran.us.r-project.org/. 2. Click on Download R for Windows. Click on base. Click on Download R 3.3.2 for Windows (or a newer version that appears). 3. Install R. Leave all default settings in the installation options. 4. Download RStudio Desktop for windows from http://rstudio.org/download/desktop (it should be called something like RStudio 1.0.136 — Windows Vista/7/8/10). … Continue reading Install R in 5,4,3,2,1…

Read your SQL trace files from SSMS using Transact-SQL

As a DBA/developer, you probably face a scenario where you need to trace your SQL Server for various reasons. This blog digs directly into how to read the trace (*.trc) file after you capture the required data. This blog would not demonstrate how to capture a trace on SQL Server. It is assumed that readers … Continue reading Read your SQL trace files from SSMS using Transact-SQL