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 [...]
Posts Tagged ‘audit’
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
0
Hot topics to work on in SQL 2008
Posted: 2nd July 2010 by Deepak in SQL DBATags: audit, compression, data collector, management, policy, resource governor, vldb, warehouse, workload
I am working on some of following topics that are considerably new in SQL 2008. Leave a comment, if you have more topics like these or experience to share with us? Prepare a Audit script using SQL 2008 feature for High, Moderate or Low category servers Setup a Central Management Servers Standardize & implement Data [...]
