Category Archives: SQL 2017

Backup and Restore operations with SQL Server 2017 Docker containers using SQL Operations Studio

Posted on July 19, 2018 by Prashanth Jayaram

In this 18th article of the series, we’ll discuss the concepts of database backup-and-restore operations with SQL Server 2017 Docker containers using SQL Ops Studio (SOS). Before proceeding, you need to have Docker engine installed and SQL Ops studio configured on … Continue reading →

Posted in Backup and Restore, docker, SQL 2017 | Tagged , , , | Leave a comment

SQL Server 2017 DMVs and DMFs for DBAs

Posted on January 17, 2018 by Prashanth Jayaram

Dynamic management views (DMVs) and dynamic management functions (DMFs) are system views and system functions that return metadata of the system state. On querying the related system objects, database administrators can understand the internals of SQL Server. It allows us to … Continue reading →

Posted in SQL 2017, T-SQL | Tagged , , , , , , , | Leave a comment

Python and SQL Server Administration

Posted on January 8, 2018 by Prashanth Jayaram

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 be interested in Python An overview of Python vs PowerShell for SQL Server … Continue reading →

Posted in Python, SQL 2017 | Tagged , , , , | Leave a comment

An introduction to a SQL Server 2017 Graph database

Posted on December 4, 2017 by Prashanth Jayaram

What is a graph database? A graph is composed of two elements: a NODE (vertices) and an EDGE (relationship). Each node represents entities, and the nodes are connected to one another with edges; these provide details on the relationship between two nodes … Continue reading →

Posted in Graph database, SQL 2017, Uncategorized | Tagged , , , | Leave a comment

SQL Server 2017 : Data Transformation and Interpolation using Python

Posted on November 21, 2017 by Prashanth Jayaram

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 about Deep Learning with Python integration in SQL Server led me to write this latest … Continue reading →

Posted in SQL 2017, SQL and Python | Tagged , , , , | Leave a comment

SQL Server Log Shipping on Linux

Posted on November 13, 2017 by Prashanth Jayaram

Log shipping is a high-availability configuration that perhaps most of us are familiar with. It’s one of the oldest techniques wherein we ship transaction logs from a Primary database to a Secondary database. Log Shipping is still a vital feature used … Continue reading →

Posted in Logshipping on Linux, SQL 2017 | Tagged , , , , | Leave a comment

Why would a SQL Server DBA be interested in Python?

Posted on October 23, 2017 by Prashanth Jayaram

If we follow blogs and publications on the technological advancement with respect to SQL, we notice the increase in the number of references to Python, of late. Often, that makes us think: Why so much emphasis on Python these days? … Continue reading →

Posted in Python, SQL 2017, SQL 2017 on Linux | Tagged , , , | Leave a comment