Blog: Prashanth Jayaram

208 blogs updated: 0 min. ago
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
Understanding Database Backup Encryption in SQL Server
Terabytes of data, millions of rows; the entire business depends on this a database administrator's responsibility is as massive as it sound...
03-05-2017 16:15:49 Prashanth Jayaram SQL Server
SQL Server 2016 enhancements - Truncate Table and Table Partitioning
The idea behind this article is to discuss the importance and the implication of SQL Partition and understand the truncate command partition...
19-04-2017 16:07:00 Prashanth Jayaram SQL Server
SQL Server Database Recovery Process Internals - database STARTUP Command
A database recovery process is an essential requirement for database systems, It can be a tedious job and the process of recovery varies on ...
28-03-2017 22:22:08 Prashanth Jayaram SQL Server
Custom keyboard shortcuts in SQL Server Management Studio (SSMS)
People love taking shortcuts because it's the easiest way to do things faster; computers are no exception. Shortcuts, particularly ones perf...
27-03-2017 16:20:11 Prashanth Jayaram SQL Server
Illustration of an example availability monitoring service Using PowerShell and SQL
This article discusses a simple solution of how to monitor SQL service availability across multiple servers and reporting. To build this I'l...
23-03-2017 14:38:42 Prashanth Jayaram SQL Server
PowerShell: Managing Service(s) Using WMI, CIM and Get-Service Cmdlet
Abstract A common task of any administrator is to manage and maintain the application availability by checking the various services status, ...
10-03-2017 21:39:53 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.