Category Archives: SQL 2012

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

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

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

SQL: Different ways to generate sequence

Posted on February 6, 2017 by Prashanth Jayaram

There was a question from the op regarding adding a new column to a query output by generating the cyclic sequence numbers from 1 to 3. Select A =identity(int,1,1),B,C from table_abs 1,A,41 2,B,13 3,C,90 4,D,91 5,E,98 6,F,12 7,G,54 8,H,16 For … Continue reading →

Posted in SQL, SQL 2012, Uncategorized | Tagged , , | 2 Comments