Nos encontramos en unos tiempos en los que muchas empresas están migrando a Azure, ya sea total o parcialmente. Uno de los primeros elementos que se aventuran a probar es el almacenamiento y más en concreto el Backup a Azure, ya que sobretodo las empresas pequeñas no tienen un Read More
Como bien sabemos desde hace poco está disponible la preview de SQL Server 2016 para Linux, la RTM tiene previsto lanzamiento en 2017. Nosotros no nos íbamos a quedar atrás y nos hemos puesto a probarlo en nuestro entorno de Azure. Instalando instancia SQL Server Primero de todo vamos a crear un 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: Fran LensConsultor Senior SQL Server & BI con 9 años de experiencia, MCSE Data Platform con conocimientos de Read More
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
Usamos cookies propias y de terceros necesarias para que nuestro sitio web funcione adecuadamente pero también utilizamos otras que nos permiten personalizar el sitio y sus opciones, realizar labores analíticas de tráfico y uso, ofrecer funciones de redes sociales, mejorar la navegación, adaptarse a tus preferencias y poder mostrarte contenido relevante y personalizado. Dispones de más información sobre las mismas en nuestra Política de Cookies. Puedes aceptar todas las cookies pulsando en el botón "Aceptar" o configurarlas a tu gusto o rechazar las no necesarias, a través de las opciones que ponemos a tu disposición. AceptarMás información
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
