Obtaining R R is available for Linux, MacOS, and Windows. Software can be downloaded from The Comprehensive R Archive Network (CRAN). Startup After R is downloaded and installed, simply find and launch R from your Applications folder. R program - Entering Commands R is a command line driven program. The user enters commands at the … Continue reading R Tutorial 101
Blog
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
TempDB growing: Chronicles of a DBA
As a DBA, you would be faced with situations where databases would begin to grow exponentially causing issues like low disk space. One of the most common databases that is famous for growing is the almighty [TempDB]. TempDB is well known over the decades for being the major culprit for grow and filling up the … Continue reading TempDB growing: Chronicles of a DBA
CORRUPTION 101
CORRUPTION TOOLKIT: BACKUP & RESTORE - See if the backup is clean once you restore (usually on another server. BCP (Bulk Copy) & DB ATTACH - try to BCP remove the corrupt tables and restore (attach) the remaining database REBUILD/REPAIR databases System database issues (corruption) - rebuild will replace system database then you can replace … Continue reading CORRUPTION 101
How to Install Python 2 with PyCharm (Windows ONLY)
Installing Python 2 is a simple process as compared to the dark ages of Python, the installer will now even set the path variable for you (a whole different topic to discuss). Please click link to download the executable windows Python installer Download and run the installer, select “Install for all users,” and then click “Next.” … Continue reading How to Install Python 2 with PyCharm (Windows ONLY)
T-SQL Pivot
To a large extent business users want to visualize data in a tabular format as shown below. This is a good presentation however, it takes 3 rows just to present data for CustomerID 11000 and 31406 rows to present data for all the CustomerIDs. What if your requirement is to represent each year as an individual … Continue reading T-SQL Pivot
