Category Archives: SQL 2016

Know How to Recover SQL Server Database Without Backup

Posted on January 24, 2018 by Andrew Jackson

Microsoft SQL Server has widely used database management system for storing and retrieving data. It stores its files in MDF, NDF and LDF format. If SQL database lost due to disasters then backup acts as a silver lining. That is … Continue reading →

Posted in Backup and Restore, SQL 2016 | Leave a comment

The evolution of SQL Server towards Digital Transformation challenges

Posted on October 9, 2017 by Prashanth Jayaram

SQL Server on Linux boosts the database market for Microsoft. Support of PolyBase (a feature to work with Big Data providers), In-Memory Optimized SQL Server, Real-time Operational Analytics, the scaling of Python and R Services for Data analytics, Graph database … Continue reading →

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

How to configure Always Encrypted in SQL Server 2016 using SSMS, PowerShell and T-SQL

Posted on October 2, 2017 by Prashanth Jayaram

In an era of remote storage and retrieval of data, including the cloud, data security plays a vital role, especially since it’s vulnerable during the transit. Situations like database backup or copy from or to the cloud, there is always … Continue reading →

Posted in SQL 2016 | Tagged , | Leave a comment

Recover Deleted Data from SQL Table Using Transaction Log and LSNs

Posted on September 21, 2017 by Andrew Jackson

Introduction At times a user may perform UPDATE operation or DELETE operation in SQL server database without applying the WHERE condition. This is a very common reason for encountering loss of data from SQL Server Tables. As the SQL Server … Continue reading →

Posted in SQL, SQL 2016, SQL Server 2017 | Tagged , , , | 1 Comment

How to Capture Database(s) usage stats using sp_spaceused and PowerShell

Posted on September 11, 2017 by Prashanth Jayaram

The objective of this article is to look at the possible ways of capturing database usage trends using the most commonly available tools and techniques. The integration of SQL, the use of sp_spaceused, and the flexibility offered by PowerShell have … Continue reading →

Posted in JSON, SQL, SQL 2012, SQL 2016, T-SQL | Tagged , , , , | Leave a comment

How to Configure TDE database with AlwaysOn using the Azure Key Vault in SQL Server 2016

Posted on July 28, 2017 by Prashanth Jayaram

One of the recent tasks that I have undertaken seemed rather like an experiment to me. I set out to configure Transparent Data encryption (TDE) using asymmetric key protection with Azure Key Vault with AlwaysOn. That, to me, opened a … Continue reading →

Posted in AlwaysOn, SQL 2016, SQL AZURE | Leave a comment

Migrate an SQL database from Windows to Linux using backup-and-restore and SMB Protocol

Posted on May 16, 2017 by Prashanth Jayaram

In an attempt decouple systems, we may modularize them. In most cases, we would need to move databases from one server to another—sometimes, even move them from Windows to Linux. In the case of moving a database to Linux, SQL Server’s … Continue reading →

Posted in SQL, SQL 2016, SQL Server vNext | Tagged , , , | Leave a comment

Understanding Database Backup Encryption in SQL Server

Posted on May 3, 2017 by Prashanth Jayaram

Terabytes of data, millions of rows; the entire business depends on this — a database administrator’s responsibility is as massive as it sounds. Apart from keeping the data secure, a database administrator also has to keep the system up and … Continue reading →

Posted in SQL, SQL 2012, SQL 2016 | Tagged , , , , , , , | Leave a comment

SQL Server 2016 enhancements – Truncate Table and Table Partitioning

Posted on April 19, 2017 by Prashanth Jayaram

The idea behind this article is to discuss the importance and the implication of SQL Partition and understand the truncate command partitioning enhancements in SQL 2016 One of the biggest challenges for a DBA is to identify the right candidate … Continue reading →

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

Custom keyboard shortcuts in SQL Server Management Studio (SSMS)

Posted on March 27, 2017 by Prashanth Jayaram

People love taking shortcuts because it’s the easiest way to do things faster; computers are no exception. Shortcuts, particularly ones performed by keyboard, can save you hours of time once applied properly. Learning keyboard shortcut saves you a lot of … Continue reading →

Posted in SQL, SQL 2012, SQL 2016 | Tagged , , | Leave a comment