Blog: Prashanth Jayaram

209 blogs updated: 8 min. ago
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
How to analyze SQL Server database performance using T-SQL
The performance of a database is the most challenging and critical part of database optimization. The challenge every DBA faces is to identi...
10-07-2017 17:11:20 Prashanth Jayaram SQL Server
SQL Server 2017
Top String Functions Machine Learning Python Integration Resumable Index Operations Happy Learning!!
06-07-2017 19:26:07 Prashanth Jayaram SQL Server
Overview of Resumable Indexes in SQL Server 2017
Managing indexes is a critical component of database maintenance but we often don't think about the indicators behind the index maintenance ...
26-06-2017 20:15:46 Prashanth Jayaram SQL Server
How to use Python in SQL Server 2017 to obtain advanced data analytics
On the 19th of April 2017, Microsoft held an online conference called Microsoft Data Amp to showcase how Microsoft's latest innovations put ...
20-06-2017 18:32:13 Prashanth Jayaram SQL Server
Top string functions in SQL Server 2017
SQL Server 2017 has been in the talk for its many features that simplify a developer's life. With the previous versions, developers had to w...
08-06-2017 21:01:56 Prashanth Jayaram SQL Server
Migrate an SQL database from Windows to Linux using backup-and-restore and SMB Protocol
In an attempt decouple systems, we may modularize them. In most cases, we would need to move databases from one server to another sometimes,...
16-05-2017 16:52:17 Prashanth Jayaram SQL Server
Installation of SQL Server vNext CTP on Linux Distribution CentOS 7
It was a paradigm shift in December 2016, when Microsoft made their SQL Server database available for Linux; it was the first time in histor...
10-05-2017 17:46:43 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.