If you haven’t heard the term “SQL Server sprawl” before, you will soon enough. The term refers to the large numbers of uncoordinated SQL Server installations in an enterprise. Some of these installations are due to SQL Server being included with many Microsoft products (such as Office and Visual Studio), but also because it was brought in “through the back door” of IT as departments started using it for small applications they needed. Over time, this resulted in many enterprises finding themselves with tens and even hundreds of separate SQL Server machines running one or two applications, with central IT database administrator (DBA) teams frequently quite unaware of them.

 

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access