Skip to content

Database Best Practices Archives

Recent Posts

June 15, 2013 Find all the materialized views in all databases – Netezza
June 1, 2013 Finding SQL Server log file location
May 20, 2013 Query to find permissions granted directly at to specific objects for a specific user – Netezza
May 1, 2013 SQL Server Agent job history getting lost or not populating
April 25, 2013 Query to find the size of each database in Netezza environment
April 12, 2013 Auditing database restore in SQL Server instance
April 1, 2013 Query to find tables consuming more space in a disk – Netezza
March 20, 2013 Query to find database backup time – Netezza
March 12, 2013 Query to find all the resource groups in a Netezza system
November 4, 2012 How to view SQL Server Performance (Perf Mon) counters collected through scheduled data collector sets?
October 28, 2012 How to Schedule a job to collect SQL Server Performance Monitor (PerfMon) counters?
October 18, 2012 Windows cannot access the specified device, path or file
October 4, 2012 Netezza – Not able to drop user
September 18, 2012 SQL Server agent service failing with errors
September 6, 2012 Who changed SQL Server database state to OFFLINE?
August 9, 2012 Happy B’day !!!!!
August 4, 2012 How to make changes to Netezza cron job under NZ account?
May 25, 2012 How to change Netezza database to read only mode?
May 18, 2012 How to Recover sa password
May 11, 2012 Create file encountered operating system error 3
April 20, 2012 SQL Server Maintenance plan not opening
April 10, 2012 Not able to delete SQL Server Maintenance Plan and/or SQL Server Agent jobs
April 4, 2012 Netezza – Scripts to find databases without backups
March 31, 2012 Netezza – Monitor grown defects on disks
February 6, 2012 Error: 9002, Severity: 17, State: 4

Monthly Archives

Copyright © 2013 . All rights reserved.