SQL BI, SQL Maintenance, SQL Setup2 Comments

Migration of SSRS to Another Instance

Introduction You can move the report server databases that are used in an installation SQL Server Database Engine to an instance that is on a different computer. Both the reportserver and reportservertempdb databases must be...

R Coding, R Troubleshooting0 Comments

R –> Encountered Error!!!

I was working normally in Rstudio, when all of a sudden, I got a popup saying "R encountered a fatal error the session was terminated". After that, Rstudio hangs for any command I give as...

R Coding, R Setup0 Comments

R Tutorial 101

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...

R Setup0 Comments

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...

Miscellaneous, SQL Performance0 Comments

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...

SQL Performance0 Comments

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...

Miscellaneous, SQL Corruption, Uncategorized0 Comments

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)...

Python Coding, Python Setup0 Comments

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...

Uncategorized1 Comment

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...

Miscellaneous0 Comments

50 Frequently Asked SQL Server Interview Questions – Part I

How will you to performance tuning ? https://www.youtube.com/watch?v=P97_oFfD218 What will you look for in an execution plan ? http://www.mssqltips.com/sqlservertutorial/285/query-execution-plans/ What is bookmark look-up related to execution plan http://www.qdpma.com/CBO/s2kCBO_2a.html Table variables vs temp tables http://engineering.picscout.com/2012/04/ sql-temporary-tables-vs-table-variables_17.html How do you pass output parameter in a...

Yearly Archives - 2017

Request For Proposal