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).
Amazon AWS
- 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)
Azure
- How to setup and use a SQL Server Stretch Database (last update: 7/31/2018)
Import and Export
- Import Active Directory Data to a SQL Server Table (last update: 3/1/2016)
Integration Services Development
- SSIS Transformation Tasks Overview (last update: 6/22/2017)
Linked Servers
- 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)
Microsoft Excel Integration
- Using Microsoft Query in Excel to Retreive SQL Server Data (last update: 11/23/2016)
PowerShell
- Using PowerShell to export Active Directory information (last update: 2/22/2016)
Replication
- SQL Server Replication Error - Cannot generate SSPI context (last update: 9/27/2016)
Security
- Tighten SQL Server security with custom server and database roles (last update: 7/26/2017)
SQL Operations Studio
- Customize SQL Operations Studio Dashboards (last update: 4/17/2018)
T-SQL
- More efficient SQL Server UPDATE for VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) data types with the WRITE Clause (last update: 10/24/2018)
