Blog: Prashanth Jayaram

208 blogs updated: 6 min. ago
Monitoring SQL Server database status changes using T-SQL and PowerShell scripts
Monitoring a SQL Server database is a critical component of database administration. Ninety percent of the organizations expect the number o...
17-10-2017 15:58:03 Prashanth Jayaram SQL Server
The evolution of SQL Server towards Digital Transformation challenges
SQL Server on Linux boosts the database market for Microsoft. Support of PolyBase (a feature to work with Big Data providers), In-Memory Opt...
09-10-2017 18:05:05 Prashanth Jayaram SQL Server
How to configure Always Encrypted in SQL Server 2016 using SSMS, PowerShell and T-SQL
In an era of remote storage and retrieval of data, including the cloud, data security plays a vital role, especially since it's vulnerable d...
02-10-2017 17:12:43 Prashanth Jayaram SQL Server
Recover Deleted Data from SQL Table Using Transaction Log and LSNs
Introduction At times a user may perform UPDATE operation or DELETE operation in SQL server database without applying the WHERE condition. T...
21-09-2017 15:57:12 Prashanth Jayaram SQL Server
SQL Server DB Migration - Cloning a database to another collation
Database migration is a vital task in any environment, complex or otherwise. Seamless migrations are the goal but the efforts required to en...
19-09-2017 17:27:14 Prashanth Jayaram SQL Server
How to Capture Database(s) usage stats using sp_spaceused and PowerShell
The objective of this article is to look at the possible ways of capturing database usage trends using the most commonly available tools and...
11-09-2017 16:56:26 Prashanth Jayaram SQL Server
Multi-server Script to Find Orphaned Data Files using PowerShell
In this article, we take the sledgehammer approach in searching for MDFs and then comparing them against files which are available on the li...
23-08-2017 18:37:43 Prashanth Jayaram SQL Server
Planning a SQL Server Backup and Restore strategy in a multi-server environment using PowerShell and T-SQL
This post demonstrates one of the ways to gather an inventory of database backup information. The output of the script includes various colu...
15-08-2017 18:39:45 Prashanth Jayaram SQL Server
A Quick Start Guide to Managing SQL Server 2017 on CentOS/RHEL Using the SSH Protocol
This article details the following How to get PuTTY and SQL Server How to install/uninstall SQL 2017 CTP2.1 How to Upgrade to SQL 2017 RC1 H...
08-08-2017 16:49:48 Prashanth Jayaram SQL Server
How to Configure TDE database with AlwaysOn using the Azure Key Vault in SQL Server 2016
One of the recent tasks that I have undertaken seemed rather like an experiment to me. I set out to configure Transparent Data encryption (T...
28-07-2017 23:26:55 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.