CORRUPTION 102 – STELLAR PHOENIX DATABASE REPAIR TOOL

Microsoft SQL Server is one of the highly used relational database application of the current time. For its advanced internal structure and reliability, many organizations use SQL Server database to store their business critical data. Unfortunately, sometimes due to virus infection, operating system malfunction, file system corruption or other similar reasons, the SQL database gets... Continue Reading →

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 moved or copied together. A Reporting Services installation requires both databases; the reportservertempdb database must be related by name to... Continue Reading →

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 the R engine probably has died. Anytime I bring Rstudio up now, I get the same message. I have reinstalled... Continue Reading →

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 program - Entering Commands R is a command line driven program. The user enters commands at the... Continue Reading →

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 →

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 →

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 →

Create a website or blog at WordPress.com

Up ↑