Continuing with my previous entry today we will see how to limit the maximum number of simultaneous connections by Remote Desktop to our server. Since we have a server with limitations in Hardware is possible that having many connections at a time with a lot of workload slow down our Server, being almost Read More

Many times we encounter the problem of working with a client, and this provides us with a user account within their server.That user account may be used by another person, since in some cases they do not usually create a new one. And this is Read More

 Within days, June 20th, will be one year since I joined Avanade Spain, so I think that is a good moment to stop and think over all learned in the last 366 days.  I can safely say that this was the year that I’ve grown Read More

Time ago, I created an automated batch procedure to create an SQL Server 2008 R2 Installer with Integrated SP1, known as Slipstream, now in SQL Server 2012 this was replaced with a new funcionality called Product Updates.  With the Product Updates funcionality we can integrate Read More

After a failed update from SQL Server 2005 to SQL Server 2008 R2 SP1, I decided to use the Repair option of the installer, the SQL Server resource was repaired correctly, but the SQL Server Agent couldn’t start.    The Agent service didn’t appear in the Read More

A friend asked me about a dynamic script to reduce the DB Log File based on the total size of DB Data Files, here is the answer:

A few days ago i was looking for a script to let me know when was the last execution of a job, so I can review the jobs that were not executed in the last year and delete the ones not needed, but i couldn’t Read More