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

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Douglas Correa

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).

Cloud Computing

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

Import and Export

Import Active Directory Data to a SQL Server Table (3/1/2016)

Integration Services Development

SSIS Transformation Tasks Overview (6/22/2017)

Linked Servers

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

Microsoft Excel Integration

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

PowerShell

Using PowerShell to export Active Directory information (2/22/2016)

Replication

SQL Server Replication Error - Cannot generate SSPI context (9/27/2016)

Security

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

SQL Server Operations Studio

Customize SQL Operations Studio Dashboards (4/17/2018)

More SQL Server Solutions