Advertisements
-
Personal Links
Verified Services
My Blog is ranked amongst the Top 50 SQL blogs worldwide
http://blog.feedspot.com/sql_blogs/DZone MVB
Microsoft
Advertisements
Category Archives: SQL
Importance of Memory Setting in SQL Server
Memory is one among the resources forming the performance triangle—CPU and storage being the other two. If one is hit, the other two take the load to try to bring the performance to acceptable levels, but there’s always the trade-off. … Continue reading
An overview of SQL Server backup-and-restore process
In a manner of speaking, planning and implementing a SQL Server backup design is an art. Backup, Restoration, Recovery, Business Continuity Plans (BCP), and Disaster Recovery (DR) are different phases of data revolving around the discussions involving data backup. In … Continue reading
SQL Server – Internals of sp_spaceused
This article is an effort to dissect the output of the sp_spaceused stored procedure. Introduction Understanding the database usage internals and the growth trends play a vital role in the defining the right sizing of the database. sp_spaceused is probably an administrator’s … Continue reading
Posted in SQL
Tagged database size, datasize, Index Size, sp_spaceUsed, sp_spaceused internals, unallocated, unused
Leave a comment
Different methods to write PowerShell output to a SQL table
PowerShell has become the ultimate choice for many database administrators because of its efficient way of handling and managing automation in a simple, quick way. It’s built on .NET Framework and uses Object Models such as COM, ADSI, ADO, and … Continue reading
Monitoring SQL Server database status changes using T-SQL and PowerShell scripts
Monitoring a SQL Server database is a critical component of database administration. Ninety percent of the organizations expect the number of databases to increase over the next twelve months. An increase in data volumes can have negative effects on the … Continue reading
Recover Deleted Data from SQL Table Using Transaction Log and LSNs
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
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
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
Multi-server Script to Find Orphaned Data Files using PowerShell
In this article, we take the sledgehammer approach in searching for MDFs and then comparing them against files which are available on the listed drive. The idea behind this is to generate a report of detached database files across multiple … Continue reading
Planning a SQL Server Backup and Restore strategy in a multi-server environment using PowerShell and T-SQL
This post demonstrates one of the ways to gather an inventory of database backup information. The output of the script includes various columns that show the internals of a database, backup size, and gives the latest completion statuses and the … Continue reading
