Browse by Tags

• Administration
• DBA
• Design
• Maintenance
• Maintenance Plans
• Scripts
• SQL Server
• SQL Server Management Studio
• Standard Reports
• Tips

• Backup Meta-Data

  I'm working on a PowerShell script to show me the trending durations of my backup activities. The first thing I need is the data, so I looked at the Standard Reports in SQL Server Management Studio, and found a report that suited my needs, so I pulled Read More... Posted Tuesday, March 30, 2010 8:46 AM by BuckWoody | 3 Comments Filed under: DBA, Design, SQL Server, SQL Server Management Studio, Scripts, T-SQL, Administration, Maintenance Plans, Maintenance, Metadata, Standard Reports

• System Variables, Stored Procedures or Functions for Meta Data

  Whenever you want to know something about SQL Server’s configuration, whether that’s the Instance itself or a database, you have a few options. If you want to know “dynamic” data, such as how much memory or CPU is consumed or what a particular query is Read More... Posted Thursday, March 11, 2010 6:42 AM by BuckWoody | 0 Comments Filed under: Tips, DBA, SQL Server, T-SQL, Administration, Metadata