MSSQLTips Author Profile - Edwin Sarmiento


Today's Site Sponsor

	SQL Compare quickly and easily compares and synchronizes SQL Server database schemas

Today's Tip Tips By Category Latest Tips Top 10 Tips Suggest a Tip Search By Tip ID

Tools Tutorials Webcasts Whitepapers Blogs Forums Forums - Active Forums - Unanswered RSS Feeds

Join MSSQLTips Authors Contribute Giveaways Feedback User Groups Follow us on Twitter Follow us on LinkedIn

About Us Advertise Copyright Disclaimer Feedback Privacy Statement

Search By Tip ID Search By Category

Author - Edwin Sarmiento

Edwin Sarmiento works as a SQL Server DBA for The Pythian Group in Ottawa, ON in Canada. Prior to joining Pythian, he was a senior systems engineer/DBA for Fujitsu Asia Pte Ltd in Singapore and is responsible for maintaining 200+ servers and databases for a global client in 10 countries. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases. He lives up to his primary mission statement - "To help people grow and develop their full potential as God has planned for them". He wants the whole world to know that the FILIPINO is a world-class citizen and brings JESUS CHRIST to the world.

Backup and Recovery

Automate Restoration of Log Shipping Databases for Failover in SQL Server 2000 (6/10/2008)
Automating SQL Server 2005 Express Backups and Deletion of Older Backup Files (4/28/2008)
Check for full SQL Server database backups before generating any other types of backups (11/10/2009)
SQL Server backup and restore of the Resource database (7/21/2008)

Clustering

Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 1 (2/13/2009)
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2 (3/2/2009)
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 3 (3/17/2009)
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 4 (4/2/2009)

Common Table Expressions (CTE)

Recursive Queries using Common Table Expressions (CTE) in SQL Server (6/16/2008)

Database Administration

Administering your Windows Internal Database (MICROSOFT##SSEE) instance (9/5/2008)
Configuring Windows Instant File Initialization for SQL Server 2005 (8/28/2008)

Database Mirroring

DDL Trigger

Using the EventData() Function with DDL triggers in SQL Server 2005 (8/27/2008)

Disaster Recovery

Encryption

Implementing Transparent Data Encryption in SQL Server 2008 (5/28/2008)

LINQ - Language Integrated Query

Creating LINQ to SQL Object Models using SqlMetal (8/27/2009)
Introduction to Language Integrated Query (LINQ) (5/20/2008)
Querying SQL Server databases using LINQ to SQL (7/7/2008)
Reading XML documents using LINQ to XML (6/24/2008)
Using Stored Procedures with LINQ to SQL (7/17/2008)

Policy Based Management

Evaluating and Implementing Policies in Multiple Instances in SQL Server 2008 (5/7/2008)

PowerShell

Backup SQL Server Databases with a Windows PowerShell Script (10/20/2009)
Check the Last SQL Server Backup Date using Windows PowerShell (7/1/2009)
Checking SQL Server Agent jobs using Windows PowerShell (7/21/2009)
Connecting to SQL Server via Windows PowerShell with SQL Server authentication (2/22/2010)
Find SQL Server Instances Across Your Network Using Windows PowerShell (5/20/2010)
Generating SQL Scripts using Windows PowerShell (9/22/2009)
Introduction to Windows PowerShell for the SQL Server DBA Part 1 (2/4/2009)
Introduction to Windows PowerShell for the SQL Server DBA Part 2 (3/9/2009)
Retrieve a List of SQL Server Databases and their Properties using PowerShell (5/26/2009)
Retrieve Default SQL Server Backup Folder using PowerShell (4/15/2010)
Using PowerShell with SQL Server Management Objects (SMO) (5/6/2009)

Reporting Services

Installing SQL Server 2005 Reporting Services 32-bit on a 64-bit Windows Server system (11/13/2009)

Security

Extending the REVERT statement using the WITH COOKIE clause in SQL Server 2005 (1/6/2009)

Service Packs / Patches

Slipstream Service Packs and Cumulative Updates on a SQL Server 2008 Installation (12/16/2009)

SQL Server 2008

Exploring Database Backup Compression in SQL Server 2008 (6/5/2008)
Implementing Data Compression in SQL Server 2008 (9/12/2008)
SQL Server 2008 T-SQL Auditing Commands for SELECT statements (12/30/2008)

SQL Server Agent

An alternative to SQL Server email alerts (11/12/2008)

Stored Procedures

Switching Stored Procedure Execution Context in SQL Server using the REVERT clause (9/9/2008)

Surface Area Configuration Manager

Using the SQL Server Surface Area Configuration Command Line Tool (1/29/2009)

Sponsor Information

Free SQL Server performance monitoring dashboard – Idera SQL check

Try Red Gate SQL Multi Script: Execute multiple scripts against multiple SQL Servers with one click!

You don't know, what you don't know about SQL Server... Customized Consulting and Training

Make the most of MSSQLTips...Sign-up for the newsletter

Free whitepaper - Developing Something for Nothing with SQL Server: A Closer Look at SQL Server Express

Idera - SQL comparison toolset

Idera SQL comparison toolset is a set of products that perform object and data comparison, as well as synchronization. No need to purchase two separate products…get both in a single toolset! The tools are easy-to-use and can save hours of development time and make object and data comparison and synchronization quick and easy.

Download now!

More SQL Server Tools

SQL comparison toolset

SQL Backup

SQL Prompt

SQL diagnostic manager

SQL compliance manager