Articles

In this section, you can find all the articles I have written for other websites and online magazines since 2005. The latest articles are related to SQL Server administration; you can also see a few about .NET programming (in Spanish), which were written in 2005. 

My passion for SQL Server drove me to write more about SQL Server topics for over 12 years — although most of them are published on this blog, nowadays I mostly write articles about SQL Server administration for MSSQLTips.com.

SQL Server Database Administration (published at MSSQLTips.com)

---

Database Console Commands DBCCs

• Error 601: Could not continue scan with NOLOCK due to SQL Server data movement (last update: 8/19/2014)
• How to use DBCC CHECKPRIMARYFILE to attach several SQL Server databases in seconds (last update: 9/23/2014)

In-Memory OLTP

• Microsoft SQL Server 2014 In-Memory OLTP: How fast is it? (last update: 11/5/2014)

Indexing

• Script out all SQL Server Indexes in a Database using T-SQL (last update: 12/18/2014)
• SQL Server Index Report with Included Columns, Storage and more for all Tables in a Database (last update: 2/3/2015)

Monitoring

• Reviewing Logical Hard Drive details using T-SQL and OLE Automation Procedures(last update: 2/23/2015)

Profiler and Trace

• Using the SQL Server Default Trace to Audit Events (last update: 1/22/2015)

Replication

• SQL Server Replication Error - The specified LSN for repldone log scan occurs before the current start of replication in the log (last update: 8/15/2014)
• SQL Server Transactional Replication Error: Could not find stored procedure error and how to recover it by using sp_scriptpublicationcustomprocs (last update: 7/24/2014)

Security

• Script to Drop All Orphaned SQL Server Database Users (last update: 12/11/2014)

SQL Server Installation

• Steps to install a stand-alone SQL Server 2017 instance (last update: 7/30/2018)

SQL Server and .NET Programming (In Spanish)

---

• Funcionalidad de XmlTextReader (26 December 2005)
• Ideología y Desarrollo de Clases .net [Parte II] (26 December 2005)
• Funcionalidad de iTextSharp usando Visual Basic .net (25 December 2005)
• Ideología y Desarrollo de Clases .net [Parte I] (25 December 2005)
• Funcionalidad de iTextSharp usando Visual C# (24 December 2005)
• Crear y configurar un directorio virtual IIS para SQLXML mediante código C# .NET (21 December 2005)
• Acceso a SQL Server mediante una URL usando Stored Procedures (4 December 2005)
• Configuración de Directorios Virtuales IIS para SQLXML 3.0 (4 December 2005)
• Administrando archivos y grupo de archivos de una base de datos SQL Server™ (16 November 2005)
• Funcionalidad XML de SQL Server (4 December 2005)
• Modificando el Código Intermedio de Microsoft - MSIL ( 31 October 2005)
• Uso de las vistas de esquema de información de SQL SERVER (18 October 2005)
• Vista encriptadas y no encriptadas en Microsoft SQL Server (12 October 2005)
• Subconsultas para SQL Server (4 October 2005)
• CAPÍTULO V: manejo de trazados (4 October 2005)
• Arquitectura XML en .NET Framework (4 October 2005)
• Xtensible Markup Language y Visual Basic .NET
• CAPÍTULO IV:  LA BROCHA (3 September 2005)
• CAPÍTULO III: FORMAS BÁSICAS GDI+ (3 September 2005)
• CAPÍTULO II: Creando objetos Graphics, Pen y Font, y manejando las estructuras Pens y Color (3 September 2005)
• APLICACIONES MDI (3 September 2005)
• Historia de Visual Basic. NET (3 September 2005)
• Arquitectura del espacio de nombres de .NET (2 September 2005)
• Enlace de Datos con ADO .NET [Parte I] (5 August 2005)
• Enlace de Datos con ADO .NET [Parte II] (5 August 2005)
• Conceptos y principios orientado a objetos (19 July 2005)
• Identificación de un modelo de objetos (13 July 2005)
• Construyendo software de alta calidad (13 July 2005)
• Personalizando el Control DataGrid (13 July 2005)
• Menú Formato (13 July 2005)
• Componentes PrintDocument y PrintDialog (16 June 2005)
• Editor de Texto (16 June 2005)
• El componente ErrorProvider (15 June 2005)
• Datasets Tipificados (15 June 2005)
• Explorador de Formulario (6 June 2005)
• Graficador de funciones (2 May 2005)
• Limpiar una DataGrid (30 April 2005) 
• Control de Excepciones .NET (30 April 2005)
• GUI+: Interfaz Avanzado de Diseño de Gráficos (10 April 2005)
• Arquitectura y funcionalidad de ADO .NET (18 March 2005)
• Usando el control ListBox (7 March 2005) 
• Explorador de Carpetas y Archivos (7 February 2005)
• Filtrar las columnas de una tabla y realizar búsquedas en un DataSet (23 January 2005)