Douglas Correa

 

Douglas Correa is a database professional focused on performance tuning database, high-availability, and infrastructure. He has been working with SQL Server for more than ten years. He has performance-tuned databases ranging from 1 gigabyte to terabytes working with PowerShell, SQL Server and Oracle. He has certifications from Microsoft (MCSA SQL Server, MTA Network) and Oracle (OCE, OCA 11g).

• PowerShell AWS Tools for Fast File Copy (last update: 12/18/2017)
  
• Setting SQL Server Configuration Options with AWS RDS Parameter Groups (last update: 3/16/2018)
  

• How to setup and use a SQL Server Stretch Database (last update: 7/31/2018)
  

• Import Active Directory Data to a SQL Server Table (last update: 3/1/2016)
  

• SSIS Transformation Tasks Overview (last update: 6/22/2017)
  

• Access Amazon Redshift data from SQL Server via a Linked Server (last update: 4/5/2018)
  
• Access MySQL data from SQL Server via a Linked Server (last update: 11/21/2016)
  

• Using Microsoft Query in Excel to Retreive SQL Server Data (last update: 11/23/2016)
  

• Using PowerShell to export Active Directory information (last update: 2/22/2016)
  

• SQL Server Replication Error - Cannot generate SSPI context (last update: 9/27/2016)
  

• Tighten SQL Server security with custom server and database roles (last update: 7/26/2017)
  

• Customize SQL Operations Studio Dashboards (last update: 4/17/2018)
  

• More efficient SQL Server UPDATE for VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) data types with the WRITE Clause (last update: 10/24/2018)