Microsoft SQL Server Community Utilities
As well as the independent SQL communities, there is also a Microsoft run one, the Microsoft SQL Server Community Worldwide ( You can tell it’s the Microsoft one by the catchy title). They do tend to assume worldwide is the United States wide or even the Seattle area so you can drop in to Redmond for SQL school. However don’t let that put you off, there is some really good stuff there including a list of utility scripts here as long as your arm for probing the dark corners of your installations:
- Get a list of databases that are not being backed up
- Logins Permissions Report
- FileGroup Listing - Object (Table/Index) listing in filegroup/files
- SQL Server 2005 - Backup, Integrity Check and Index Optimization
- Find out which SQL Agent jobs are currently executing
- Get facts on whether statistics need to be updated
- Run SQL (T-SQL Statements or Stored Proc) on multiple Servers
- SQL Server data/log usage for each drives
- Find out if your local SQL Server is configured to use /3GB switch or not?
- Identify orphan SQL Server user accounts from your local SQL Server.
- See what's happening behind the scenes of TempDB database.
- Script to find out which login has what server role permissions.
- Create Audit Table
- Drop all foreign keys and tables in a database
- Control Database Mirroring Failover and Failback thru script.
- Defrag indexes from one or all databases.
- Auto Failover SQL Jobs during Database Mirroring Session.
- Backup all User and System Databases excluding Mirror Databases.
- How to determine the space used by Tables in the database.
- Quickly get database information
- Detect highest CPU bound queries
- Get SQL Server Agent job configuration information
- Rebuild all indexes in a user database
- How to get current date and time of a system.
- Changing the owner of DTS Packages
- Get a snapshot of My Computer in SQL Server
- Get details about your database
- Get the Facts about your Backups
- SQLAgent.out Size Alert
- Unrestrict database growth for one and for all
- To Index or to Defrag (Smart INDEX)
- Detect Real-time Deadlocks and Blocks
- Rebuild Indexes Online
- Are your indexes useful?
- Check the status of database mirroring session
- Checking Integrity and Consistency of Databases
- Track daily data growth
- Attach and Detach SQL Server Databases
Andrew Fryer's Blog : Microsoft SQL Server Community Utilities
No comments:
Post a Comment