Debunking the Myths: Cloud HA and DR common misconceptions

Learn more about SQL Server tools



solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips
































Top SQL Server Tools






















   Got a SQL tip?
            We want to know!


MSSQLTips Authors

Check out the talented and community minded MSSQLTips.com authors that have been helping the SQL Server community since 2006. From start to finish, the MSSQLTips.com authors have invested the time to share their knowledge and answered your questions to help you resolve tricky SQL Server issues. If you love their tips, let them know!

If you are interested in joining the ranks as an MSSQLTips.com author, click here for more information and to get started.

Thank you,
The MSSQLTips.com Team

linkedin  twitter 
Aaron Bertrand is a Senior Consultant at SQL Sentry, Inc., and has been contributing to the community for over a decade, first earning the Microsoft MVP award in 1997.

Author Since: 2010

Tip Contributions: 60

Microsoft MVP


Robert Biddle is a Data Architect with over 10 years of experience working with databases. He specializes in data warehousing and SSIS.

Author Since: 2014

Tip Contributions: 1


Tim works as a DBA and developer and also teaches Automating ETL on Udemy.

Author Since: 2013

Tip Contributions: 15


linkedin  googleplus  twitter 
Edwin Sarmiento works as a SQL Server DBA for The Pythian Group in Ottawa and is a SQL Server MVP.

Author Since: 2008

Tip Contributions: 73

Microsoft MVP


linkedin  twitter 
K. Brian Kelley is a SQL Server author and columnist focusing primarily on SQL Server security.

Author Since: 2008

Tip Contributions: 103

Microsoft MVP


linkedin  twitter 
Percy Reyes is a Senior Database Administrator focused on SQL Server Internals with over 10+ years of extensive experience managing critical database servers.

Author Since: 2014

Tip Contributions: 1


linkedin 
Andy Novick is a SQL Server Developer in the Boston area with 25 years of database and application development experience.

Author Since: 2006

Tip Contributions: 27

Microsoft MVP


linkedin 
Erin Youtzy has been dabbling in SQL at the workplace since she earned her BS degree in 2004. She is currently a DBA at UNM.

Author Since: 2014

Tip Contributions: 1


linkedin  googleplus  twitter 
Jeremy Kadlec is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com, Baltimore SSUG co-leader and SQL Server MVP since 2009.

Author Since: 2006

Tip Contributions: 224

Microsoft MVP


Jeffrey Yao is a senior SQL Server consultant, striving to automate DBA work as much as possible to have more time for family, life and more automation.

Author Since: 2014

Tip Contributions: 4


Rick Dobson is a Microsoft Certified Technical Specialist and well accomplished SQL Server and Access author.

Author Since: 2011

Tip Contributions: 14


Cate Murray is responsible for managing the nationally-based talent acquisition strategies of the Apex Systems PMO and Business Analysis Practice.

Author Since: 2014

Tip Contributions: 1


Svetlana Golovko is a DBA with 13 years of the IT experience (including SQL Server and Oracle) with main focus on performance.

Author Since: 2012

Tip Contributions: 16


linkedin  googleplus 
Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and Microsoft Certified IT Professional.

Author Since: 2012

Tip Contributions: 32

Microsoft MVP


Sadequl Hussain has been working with SQL Server since version 6.5 and his life as a DBA has seen him managing mission critical systems.

Author Since: 2009

Tip Contributions: 12


John Grover is a 25-year IT veteran with experience in SQL Server, Oracle, clustering and virtualization.

Author Since: 2013

Tip Contributions: 5


linkedin  googleplus 
Greg Robidoux is the President of Edgewood Solutions and a co-founder of MSSQLTips.com.

Author Since: 2006

Tip Contributions: 194


linkedin 
Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

Author Since: 2012

Tip Contributions: 45


Carla Abanes works for a private bank in Singapore as a SQL Server DBA.

Author Since: 2014

Tip Contributions: 2


linkedin  twitter 
Daniel Farina was born in Buenos Aires, Argentina. Self-educated, since childhood he showed a passion for learning.

Author Since: 2013

Tip Contributions: 18


linkedin  googleplus  facebook  twitter 
Datta Sindol has over 5 years of experience in the IT industry working with SQL Server, SSIS, SSAS, SSRS.

Author Since: 2011

Tip Contributions: 29


Erica Woods has nearly a decade in the IT staffing world, an MBA, and is a member of the Professional Association of Resume Writers and Career Coaches.

Author Since: 2014

Tip Contributions: 2


Koen Verbeeck is a BI professional, specializing in the Microsoft BI stack with a particular love for SSIS.

Author Since: 2013

Tip Contributions: 12


Ben Snaidero has been a SQL Server and Oracle DBA for over 10 years and focuses on performance tuning.

Author Since: 2011

Tip Contributions: 38


Dr. Dallas Snider is an Assistant Professor in the Computer Science Department at the University of West Florida and has 18+ years of SQL experience.

Author Since: 2013

Tip Contributions: 27


Varinder Singh is a SQL Server production DBA in the Boston area with 20+ years of database, SSIS, SSAS and SSRS administration experience.

Author Since: 2014

Tip Contributions: 1


Brian P ODwyer is a BI Analyst at Cook Children's Health Care System who knows both Infrastructure and SQL server

Author Since: 2014

Tip Contributions: 6


Richard Vantrease is a lead SQL Server DBA for a large company. His specialties include architecture, the data engine and automation.

Author Since: 2014

Tip Contributions: 4


linkedin 
Brady Upton is a Database Administrator and SharePoint superstar in Nashville, TN.

Author Since: 2011

Tip Contributions: 44


linkedin  googleplus  twitter 
Dave Bennett is a Senior SQL Server DBA for a major telecommunications company. He has been working in technology for over 20 years.

Author Since: 2014

Tip Contributions: 1


linkedin  twitter 
Tibor Nagy is a technical and business professional from the financial industry. His experience includes SQL Server 2000-2008, DB2 and MySQL.

Author Since: 2010

Tip Contributions: 20


linkedin 
Simon Liew is a Microsoft Certified Master: SQL Server 2008. He is a SQL Consultant in Sydney, Australia.

Author Since: 2013

Tip Contributions: 4


Bernard Black is a DBA for Beacon Health System in South Bend, IN and has been working with databases for over 15 years.

Author Since: 2014

Tip Contributions: 1


linkedin 
Sherlee Dizon is an IT consultant and web application developer with over 14 years of experience as a software and web developer.

Author Since: 2011

Tip Contributions: 5


Edgewood Solutions is a technology company focused on Microsoft SQL Server and founder of MSSQLTips.com.

Author Since: 2006

Tip Contributions: 47


Arshad Ali is a SQL and BI Developer focusing on Data Warehousing projects for Microsoft.

Author Since: 2009

Tip Contributions: 104


Derek Colley is a SQL Server DBA based in Manchester, UK, with a focus on performance management and data architecture.

Author Since: 2013

Tip Contributions: 18


linkedin  googleplus  twitter 
Tim Ford is a Senior Database Administrator and SQL Server MVP. He has been working with SQL Server since 1999.

Author Since: 2007

Tip Contributions: 102

Microsoft MVP


Bhaskar Sarma is a MSSQL DBA working in HealthCare since 2005.

Author Since: 2014

Tip Contributions: 1


Manvendra Signh has over 5 years of experience with SQL Server and has focused on Database Mirroring, Replication, Log Shipping, etc.

Author Since: 2011

Tip Contributions: 29


Mike Eastland has been a SQL Server DBA since 1999. His main areas of interest are monitoring and the automation of administrative tasks.

Author Since: 2013

Tip Contributions: 4


linkedin 
Norman Chan is a SQL Server DBA with over 12 years of IT experience as a software developer and DBA.

Author Since: 2012

Tip Contributions: 4


linkedin  twitter 
Pavel Pawlowski is Lead BI Specialist in Tieto with focus on Microsoft SQL Server and Microsoft BI platform.

Author Since: 2013

Tip Contributions: 5


linkedin 
Tim Wiesman is a SQL Server DBA and Python Developer in Las Vegas.

Author Since: 2012

Tip Contributions: 6


Graham Okely is a contract SQL Server DBA and has been working with database systems since 1984 and has been specializing in SQL Server since 2007.

Author Since: 2013

Tip Contributions: 4


linkedin  googleplus  twitter 
Mohammed Moinudheen is a SQL Server DBA with over 6 years experience managing production databases for a few Fortune 500 companies.

Author Since: 2011

Tip Contributions: 15


linkedin  twitter 
Alan Cranfield is a versatile SQL Server DBA with over 10 years experience managing critical systems in large distributed environments.

Author Since: 2009

Tip Contributions: 10


linkedin  googleplus  twitter 
Sr. DBA Thomas LeBlanc MCITP 05/08 DBA & 08 BI has spoken at the PASS Summit 2011/12, SQL Rally & many SQL Saturday’s.

Author Since: 2009

Tip Contributions: 4


Kun Lee is a database administrator and his areas of interest are database administration, architecture, data modeling and development.

Author Since: 2008

Tip Contributions: 30


linkedin  googleplus  twitter 
Rick Krueger is a Lead Development DBA, BI Developer, and speaker with 18 years of experience, based in the Twin Cities.

Author Since: 2013

Tip Contributions: 2


linkedin  googleplus 
Ray Barley is a Principal Architect at RDA Corporation and a MSSQLTips.com BI Expert.

Author Since: 2008

Tip Contributions: 106


linkedin  twitter 
Chad Churchwell is a SQL Server professional specializing in High Availability, Disaster Recovery, and Replication.

Author Since: 2012

Tip Contributions: 13


Andy Brown is a director of Wise Owl, a UK training company, and creator of many SQL Server blogs, tutorials and videos.

Author Since: 2013

Tip Contributions: 1


linkedin  googleplus  facebook 
Basit Farooq is a Senior Database Administrator and has worked in the IT industry for 11+ years.

Author Since: 2012

Tip Contributions: 7


Douglas Castilho has been a SQL Server DBA over 6 years, focuses on tuning, backup, disaster recovery, mirroring, T-SQL, PL-SQL and .NET

Author Since: 2013

Tip Contributions: 2


Tim Mitchell is a business intelligence architect, author, speaker, and SQL Server MVP. He specializes in SSIS.

Author Since: 2013

Tip Contributions: 1

Microsoft MVP


linkedin  googleplus  twitter 
Siddharth Mehta is an Associate Manager with Accenture in the Avanade Division focusing on Business Intelligence.

Author Since: 2009

Tip Contributions: 50

Microsoft MVP


Murali Krishnan is a Lead Consultant with vast experience in Database/BI Design, Development and Administration.

Author Since: 2011

Tip Contributions: 7


Lin Liu is a SQL server DBA and consultant in the San Francisco area. He is specializes in SQL administration and architecture solutions.

Author Since: 2013

Tip Contributions: 1


linkedin  googleplus 
Tim Cullen has been working in the IT industry since 2003 and currently works as a SQL Server Reports Developer.

Author Since: 2007

Tip Contributions: 36


Mike Bishop is a Boston-based DBA and data architect with 20+ years of database management experience.

Author Since: 2013

Tip Contributions: 1


linkedin  twitter 
Seth Delconte is a Microsoft Certified Trainer and Database Administrator, and works primarily on SQL Server development.

Author Since: 2012

Tip Contributions: 2


linkedin  googleplus  twitter 
Jugal Shah has 8+ years of extensive SQL Server experience and has worked on SQL Server 2000, 2005, 2008 and 2008 R2.

Author Since: 2010

Tip Contributions: 41

Microsoft MVP


twitter 
Dan Quinones is an Architect/Systems Engineer with over 11 years of experience specializing in Microsoft Server and Database technologies.

Author Since: 2012

Tip Contributions: 5


Mickey Stuewe is a Microsoft Certified Professional in Querying Microsoft SQL Server 2012. She has been with Microsoft development products like SQL Server, SSRS, Excel, and VB since 1995.

Author Since: 2013

Tip Contributions: 1


Burt King is a Senior DBA and has worked with SQL Server since 1997 and enjoys working on large clustered solutions.

Author Since: 2011

Tip Contributions: 3


linkedin  twitter 
Rajendra is a Consultant DBA with 4+ years of extensive experience in database administration including SharePoint databases.

Author Since: 2011

Tip Contributions: 10


John Garcia is a SQL Server Database Administrator in Alpharetta, GA with over 12 years of experience.

Author Since: 2012

Tip Contributions: 1


linkedin 
Matteo Lorini is a DBA and has been working in IT since 1993. He specializes in SQL Server and also has knowledge of MySQL.

Author Since: 2009

Tip Contributions: 31


linkedin 
Albert Hetzel works as a SQL Server Developer for a Dallas technology company.

Author Since: 2012

Tip Contributions: 1


linkedin 
Armando Prato has over 24 years of industry experience and has been working with SQL Server since version 6.5.

Author Since: 2007

Tip Contributions: 34


linkedin  googleplus  twitter 
Marlon Ribunal is a data specialist for an aerospace & defense company. He is passionate about SQL Server, data, and BI.

Author Since: 2012

Tip Contributions: 1


Dale Kelly has been in the computer industry since the late 80s and is currently a Sr. DBA responsible for 26 SQL Servers.

Author Since: 2012

Tip Contributions: 5


Ashish Kumar Mehta has been contributing to the MSSQLTips.com community since 2009 with over 60 tips.

Author Since: 2009

Tip Contributions: 79


linkedin 
Chris Allaire has been developing applications on SQL Server for the last 12 years and specializes in SSIS and data integration.

Author Since: 2012

Tip Contributions: 1


linkedin  googleplus  twitter 
John Sterrett is a DBA and Software Developer with expertise in data modeling, database design, administration and development.

Author Since: 2010

Tip Contributions: 8


linkedin 
Diana Moldovan is a DBA and data centric applications developer with 6 years of experience covering SQL 2000, SQL 2005 and SQL 2008.

Author Since: 2011

Tip Contributions: 14


googleplus  twitter 
Atif Shehzad is a passionate SQL Server DBA, technical reviewer and article author.

Author Since: 2008

Tip Contributions: 45


Peter Tran is a Senior Performance Tech Lead @ PROS Revenue Management;(NYSE: PRO), where he focuses on server-side (Java, JDBC, database) performance on SQL Server.

Author Since: 2012

Tip Contributions: 1


linkedin  twitter 
Robert Pearl is a SQL MVP, and President of Pearl Knowledge Solutions, Inc., offering SQLCentric monitoring and DBA services.

Author Since: 2011

Tip Contributions: 8

Microsoft MVP


David Bird has years of IT Experience working as a DBA and programmer on Windows, UNIX, and mainframes.

Author Since: 2008

Tip Contributions: 5


linkedin  googleplus  twitter 
Scott Shaw is a Lead SQL Server DBA with extensive experience running SQL Server in a virtualized environment.

Author Since: 2011

Tip Contributions: 10


Shawn Melton started his IT career in 2002 and has experience working with SQL Server 2000, 2005, 2008, and 2008 R2.

Author Since: 2011

Tip Contributions: 7


linkedin 
Brent Shaub has been creating, renovating and administering databases since 1998.

Author Since: 2011

Tip Contributions: 8


linkedin 
Nitansh Agarwal is a lead with 4+ years of extensive experience in database administration where he handles large critical databases.

Author Since: 2011

Tip Contributions: 6


linkedin 
Eli Leiba is a senior application DBA, a teacher and a senior database consultant with 19 years of RDBMS experience.

Author Since: 2011

Tip Contributions: 5


linkedin 
Vamsi Bogullu is a Database Architect administering database servers, developing applications and designing enterprise BI solutions.

Author Since: 2010

Tip Contributions: 3


Tal Olier is a database expert currently working for HP holding various positions in IT and R&D departments.

Author Since: 2008

Tip Contributions: 3


linkedin  twitter 
Alex Tocitu is an engineer with an MSEE in Automation and MBA in Finance.

Author Since: 2011

Tip Contributions: 6


Bru Medishetty focuses on Performance Monitoring and Tuning as well as planning and implementing Disaster Recovery solutions.

Author Since: 2010

Tip Contributions: 7


linkedin  googleplus 
Thomas LaRock is a seasoned IT professional with over a decade of experience. He is a Senior DBA for Confio Software and SQL Server MVP.

Author Since: 2009

Tip Contributions: 20

Microsoft MVP


linkedin  googleplus  twitter 
Ken Simmons is a database administrator, developer, SQL Server book author and Microsoft SQL Server MVP.

Author Since: 2008

Tip Contributions: 24


linkedin  googleplus 
Wayne Ackman has held the position of Senior Database Administrator with various corporations using SQL Server over the last two decades.

Author Since: 2010

Tip Contributions: 1


linkedin  googleplus  twitter 
Ranga Narasimhan has been in IT for over 10 years working on Siebel, Visual Basic, Crystal Reports and SQL Server.

Author Since: 2008

Tip Contributions: 8


linkedin  googleplus  twitter 
Charley Hanania is based in Zurich and is a Principle Consultant at QS2 – Quality Software Solutions.

Author Since: 2009

Tip Contributions: 11

Microsoft MVP


linkedin  googleplus  facebook  twitter 
Sankar Reddy is a Database Engineer/DBA and SQL Server MVP. He has been working with SQL Server since 2003 in a variety of roles.

Author Since: 2009

Tip Contributions: 7

Microsoft MVP


Author Since: 2010

Tip Contributions: 1


linkedin  googleplus  twitter 
Michelle Gutzait has been involved in IT for 20 years as a developer, business analyst and database consultant.

Author Since: 2009

Tip Contributions: 6


Author Since: 2009

Tip Contributions: 1


Chad Boyd is an Architect, Administrator and Developer with technologies such as SQL Server, .NET, and Windows Server.

Author Since: 2007

Tip Contributions: 67


Author Since: 2009

Tip Contributions: 6


linkedin  googleplus 
Hilary Cotter is a SQL Server MVP specializing in replication and Full-Text Search.

Author Since: 2009

Tip Contributions: 1

Microsoft MVP


linkedin 
Nitin Rana is a Microsoft Certified Professional and currently has over 12 years of IT experience with the SQL server core components.

Author Since: 2008

Tip Contributions: 2


Author Since: 2008

Tip Contributions: 1


Author Since: 2008

Tip Contributions: 1


Hal Hayes is a managing Consultant at Excella Consulting.

Author Since: 2008

Tip Contributions: 2


linkedin 
Rob Fisch has worked with SQL Server since version 6.5 as a dba, developer, report writer and data warehouse designer.

Author Since: 2007

Tip Contributions: 18


Author Since: 2007

Tip Contributions: 1


Enrique Garcia is a Software Developer and his area of interests are database performance and .Net development.

Author Since: 2007

Tip Contributions: 1


Jay Dave has over 10 years of experience in the IT industry working as a trainer, software developer, etc.

Author Since: 2007

Tip Contributions: 5


Author Since: 2007

Tip Contributions: 1



 
Sponsor Information







Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | events | first timer?
Some names and products listed are the registered trademarks of their respective owners.