MSSQLTips Author Profile - Edwin Sarmiento

join the MSSQLTips community


Today's Site Sponsor

	Find performance issues related to Analysis Services memory limits.

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

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

Author - Edwin Sarmiento
	Bio is coming soon...

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/8/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)
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)
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

The SQL Toolbelt – all 13 Red Gate SQL Server Tools.

Make the most out of SQL Server - Guaranteed Results - Innovative SQL Server DBAs

Changing careers? Becoming a SQL Server Professional? Look no further...

Learn SQL Server 2008, Performance Tuning, Development, Administration, DR, Replication and more from these web casts

All SQL Server, all the time! Sign-up for the MSSQLTips newsletter!

Interested in SharePoint? Love the tips? Check this out...

Free whitepaper - How to Achieve 40:1 Backup Compression with LiteSpeed® for SQL Server’s

Idera - SQL compliance manager

SQL compliance manager is a comprehensive auditing solution that tells you who did what, when and how on your SQL Servers. SQL compliance manager helps you ensure compliance with regulatory and data security requirements.

Download now!

More SQL Server Tools

SQL diagnostic manager

SQL Nitro

SQL comparison toolset

SQL compliance manager

SQL defrag manager

Copyright (c) 2006-2010 Edgewood Solutions, LLC All rights reserved
privacy statement | disclaimer | copyright | advertise | write for mssqltips | feedback | about
Some names and products listed are the registered trademarks of their respective owners.