Enrique Puig

Explore articles and content from this author

Enrique Puig

2 articles published

14 min read

Monitoring SQL Server Backups

One of the most important tasks for the** **DBAs is to ensure that there is a maintenance plan to recover data from a given disaster.  As a DBA we need to design a maintenance plan according to our scenario and business requirements. Do we want to be able to recover data at any point of time? How much data loss can we accept? All these questions and many more must be answered before designing the plan.

11 min read

Comparing SQL Server table schemas with PowerShell

As a SQL Server DBA or SQL Server developer sometimes is necessary to know whether two tables have equal schemas or not. For example, a few months ago I had to consolidate two SQL Server instances in just one. One of the main problems were the collisions between Databases and Tables. I found out that both instances had Databases with equal name and the same thing happened with tables inside those databases.