About this blog

 
About this blog

Enrique Puig

Data Platform Engineer

epuig@solidq.com 
​SQL-Server
 
Enrique Puig Nouselles

Powershell for the DBA: Cleaning SQL Server backup files

2012-01-24 20:19:00 by Enrique Puig Nouselles

One of the most important tasks for a database administrator is to backup all the databases for security reasons. As a Database administrator we need to make sure that in case of a disaster we will be able to recover our data from any point of time, that’s...

Enrique Puig Nouselles

SQL Server 2008: Managing Resources with Resource Governor

2011-07-20 17:56:38 by Enrique Puig Nouselles

Hi All, Microsoft Spain has published a new article that I wrote a few days ago. The article talks about how to manage your server’s resources with SQL server 2008 using Resource governor. Eladio Rincon helped me out as a technical reviewer, thanks Eladio...

Enrique Puig Nouselles

Checking existing files with Powershell and SQL Server Agent

2011-05-17 16:25:00 by Enrique Puig Nouselles

Sometimes we need to check for some requirements before running a job. For instance, let’s say that we want to check that a file exists before running a job that tries to restore a database. Before running the job we want to make sure that a file named...

Enrique Puig Nouselles

Migrating Jobs with PowerShell

2010-11-22 00:59:10 by Enrique Puig Nouselles

One of the most common tasks when we are migrating SQL Server instances is to move all jobs from the old instance to the new one. Sometimes we have to face migrations that have involved hundreds of jobs. In order to automatize this task we can use PowerShell....

Enrique Puig Nouselles

Uploading files to an FTP server with PowerShell

2010-11-04 20:33:00 by Enrique Puig Nouselles

A few days ago I was working in a project and I had the following situation: I had some SQL server profiler trace files (more than 50), every trace file was around 300MB and I needed to upload all files to an ftp server. Internet connection was not good...

Enrique Puig Nouselles

Nos vamos a las nubes con AZURE!

2010-10-21 20:20:00 by Enrique Puig Nouselles

Mucho se está hablando últimamente de “Cloud Computing” o también conocido como “la nube”. Son muchas las compañías que ofrecen dichos servicios, pero en este caso nos vamos a centrar en los servicios de Microsoft. Estos servicios quedan englobados bajo...

1
Follow us on: