Blog: Prashanth Jayaram

210 blogs updated: 30 min. ago
SQL Server - Internals of sp_spaceused
This article is an effort to dissect the output of the sp_spaceused stored procedure. Introduction Understanding the database usage internal...
06-02-2018 21:58:30 Prashanth Jayaram SQL Server
Know How to Recover SQL Server Database Without Backup
Microsoft SQL Server has widely used database management system for storing and retrieving data. It stores its files in MDF, NDF and LDF for...
24-01-2018 13:05:25 Prashanth Jayaram SQL Server
SQL Server 2017 DMVs and DMFs for DBAs
Dynamic management views (DMVs) and dynamic management functions (DMFs) are system views and system functions that return metadata of the sy...
17-01-2018 18:36:21 Prashanth Jayaram SQL Server
How to fix the database consistency and integrity issues using DBCC CHECKDB and Third Party Tool
Overview The database protection and recovery is a vital role of database administrators. While working on SQL Server, sometimes users get s...
09-01-2018 19:08:44 Prashanth Jayaram SQL Server
Python and SQL Server Administration
Some of my previous articles on Python provided insight of the basics and the usage of Python in SQL Server 2017. Why would a SQL Server DBA...
08-01-2018 16:02:55 Prashanth Jayaram SQL Server
Different methods to write PowerShell output to a SQL table
PowerShell has become the ultimate choice for many database administrators because of its efficient way of handling and managing automation ...
26-12-2017 16:58:30 Prashanth Jayaram SQL Server
Configure SQL Server 2017 on Linux with mssql-conf, the Linux way
The configuration of any system plays a vital role in its working efficiently. However, configuring a system needs not necessarily be a daun...
13-12-2017 17:21:23 Prashanth Jayaram SQL Server
An introduction to a SQL Server 2017 Graph database
What is a graph database? A graph is composed of two elements: a NODE (vertices) and an EDGE (relationship). Each node represents entities, ...
04-12-2017 16:45:20 Prashanth Jayaram SQL Server
SQL Server 2017 : Data Transformation and Interpolation using Python
As a continuation to my previous article, How to use Python in SQL Server 2017 to obtain advanced data analytics, a little bit of curiosity ...
21-11-2017 17:53:42 Prashanth Jayaram SQL Server
SQL Server Log Shipping on Linux
Log shipping is a high-availability configuration that perhaps most of us are familiar with. It's one of the oldest techniques wherein we sh...
13-11-2017 18:34:54 Prashanth Jayaram SQL Server

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.