Free SQL Server Learning - Making the most out of SQL Server Agent

solving sql server problems for millions of dbas and developers since 2006

SQL Product Highlight

Idera - SQL safe backup

SQL Server backup compression with network fault tolerance and zero impact encryption

Fast, compressed & encrypted SQL backup and restore
SQL Server backup compression of 95%
At least 50% faster than native SQL backups

Learn more!

Manvendra Singh

I'm currently working with Aon Corporation. My 5 years of experience covers SQL 2000, SQL 2005, SQL 2008 and SQL 2008R2. I have rich experience in all database features like Database Mirroring, Replication, Log Shipping, Clustering and Performance Tuning. I have worked on many projects like SQL Server consolidation, SQL Server upgrades, implementing replication, HA / DR solutions, and major performance tuning projects.

You can also follow me on my blog, Twitter, LinkedIn and Facebook.

Database Administration

Database Attach Failure in SQL Server 2008 R2 (2/24/2012)

Database Mirroring

How to add a database file to a mirrored SQL Server database (1/11/2013)
How to move database files of a Mirrored SQL Server Database (5/30/2012)

Indexing

Index Create Memory Setting for SQL Server (12/5/2012)

Install and Uninstall

SQL Server Configuration Manager Cannot Connect to WMI Provider (6/8/2011)

Log Shipping

How to add database file to a Log Shipped database in SQL Server (12/10/2012)

Performance Tuning

Error running the SQL Server Database Tuning Advisor for non SA users (7/8/2011)
Find out which SQL Server instance is consuming most of the CPU (9/17/2012)
How to find out how much CPU a SQL Server process is really using (8/9/2011)
Troubleshooting SQL Server RESOURCE_SEMAPHORE Waittype Memory Issues (1/4/2013)

PowerShell

Enable PowerShell on Windows Server 2008 R2 Core Edition (12/19/2011)
Enable Powershell Remoting on SQL Server Instances (12/1/2011)
Using PowerShell to access event logs for SQL Server (4/30/2013)

Reporting Services Installation

How to add Reporting Services to an existing SQL Server Clustered Instance (10/3/2012)

Restore

How to revert a Database Snapshot to recover a SQL Server database (6/25/2012)

Security

How to connect to SQL Server if you are completely locked out (4/26/2012)
Identify blank and weak passwords for SQL Server logins (9/26/2012)

SQL Server Agent

How to start SQL Server Agent when Agent XPs show disabled (7/12/2012)

SQL Server Configurations

How to allow Ad hoc updates in SQL Server system catalogs (2/11/2013)

SQL Server Management Studio

Property Owner is not available for Database SSMS error (8/17/2011)

Upgrades and Migrations

SQL Server 2008 R2 Upgrade Failure due to Security Group upgrade rule (2/16/2012)

Sponsor Information

Find and fix SQL Server problems before they happen - SQL diagnostic manager now with predictive analysis!

SQL Developer Bundle: Cut out dull work with 12 tools for simpler, faster database development. Free trial

What grade do you think your SQL Servers get? Find out with Edgewood's Health Check consulting services.

The COMPLETE Performance Solution for SQL Server - SQL Sentry

SQL Server Data Tools - Got questions? Get the answers here!

Copyright (c) 2006-2013 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | user groups
Some names and products listed are the registered trademarks of their respective owners.

Edgewood Solutions LLC | MSSharePointTips.com | MSSQLTips.com