Monthly Archives: September 2017

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 Database recovery process, Recover SQL Server data, SQL, SQL Server | 1 Comment

SQL Server DB Migration – Cloning a database to another collation

Posted on September 19, 2017 by Prashanth Jayaram

Database migration is a vital task in any environment, complex or otherwise. Seamless migrations are the goal but the efforts required to ensure it are tremendous. A global SQL Server Collation Sequence update is the answer to the puzzle, but … Continue reading →

Posted in SQL, T-SQL | Tagged Cloning a database to another collation, Collation MIgration, Database Collation | Leave a 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 →