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)

Tutorials DBA Dev BI Career Categories Webcasts Whitepapers Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Douglas Correa

More SQL Server Solutions