Setup SQL Server 2008 R2 Database Mirroring with Automatic Failover Across the Internet
Learn how to setup SQL Server 2008 R2 Database Mirroring with Automatic Failover Across the Internet via VPN and Host File configurations.
Over 12 years working with databases and software industry, started work with SQL Server in version 7.0 and it now examines new techniques with the 2012 version. Specializes in database, focuses on performance tuning, backup/restore, disaster recovery, database mirroring, healthy check, replication, security, query optimization, and code analysis.
With software industry, has experience with ERP, mobile, ETL, Business Intelligence projects, with SQL Server and Oracle databases. Applications developed in Delphi, VB, C#, .NET, C++ and ExtJS Java.
Douglas has some Microsoft certifications, like MCITP in SQL Server DBA-DEV, MCPD in Windows Developer 3.5 and MCTS in .NET Framework 3.5 and Windows Forms Application. On education, has a MBA in Project Management.
Change SQL Server Collation After Installation
In this tip we look at different approaches to changing the SQL Server collation for the instance, database and table columns.
Automated and Formatted Index Maintenance Reports for SQL Server
I want to create T-SQL scripts to fix index fragmentation and to send me an email notification after the index rebuilds or reorgs. I know I can create maintenance plans, jobs and use database mail to do this, but how can I customize this process to only
Rolling up multiple rows into a single row and column for SQL Server
Learn how to roll-up multiple rows into one row and one column with concatenation in SQL Server with FOR XML, STUFF and STRING_AGG.