By Reinaldo Kibel, Database Strategist, Infrastructure Engineering and Operations, Dell Technologies
At Dell, we really like Microsoft SQL Server. We use roughly 25,000 SQL Server databases across the company to power more than 1,500 applications in every area of the business: manufacturing, marketing, finance, e-commerce—you name it.
To better manage all these databases, my team built a tool called SQL Dashboard. We use it not only for basic database asset management but also to do performance monitoring and health assessment—do the databases have enough storage and compute power? About 1,000 Dell architects, system engineers, app developers, and database administrators (DBAs) around the world use this tool.
We developed a second tool called SQL Grid, which is an internal private cloud for creating and running SQL Server databases. To obtain physical servers, teams must go through requisition and approval processes that slow down development and test work. To address this, we created a pool of virtual machines dedicated to SQL Server database requests. With SQL Grid, teams can procure a database within minutes, use it for hours, days, or weeks, then release it back to the pool.
We recently upgraded both SQL Dashboard and SQL Grid to Microsoft SQL Server 2017 to give Dell teams access to all the exciting new features available. As a result, we’re seeing benefits like: