Consolidation by definition is the process of combining multiple SQL Server Databases & Servers running on different machines (could be geographically separated) onto a smaller number of more powerful machines in a central location. However in my opinion regarding SQL, its a process of getting organized, spending for what you need or use, and [...]
Posts Tagged ‘license’
SQL Server Consolidation & Virtualization Practice..
Posted: 22nd December 2010 by Deepak in SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: DBA, hyper-v, license, sql, sql consolidation, sql cost cutting, sql p2v, upgrade, virtual server, virtualization, vmware
0
Scripts to prepare SQL Server Inventory
Posted: 21st December 2010 by Deepak in Scripts, SQL DBA, SQL Dev, UncategorizedTags: audit, authentication, collation, configuration, installation, license, MAP, page file, properties, service account, sql inventory
You never know, when you may need to rebuild a SQL sever with exact properties and configurations. Although there are dozen of 3rd party tools and software available in market to prepare enterprise level SQL Server inventory hosted in your environment like Microsoft Assessment and Planning (MAP), but keeping your own DBA script handy is [...]
