Monthly Archives: March 2012

Microsoft Assessment and Planning (MAP) Toolkit – Version 6.5 – Part 1

MAP provides detailed readiness assessment reports and executive proposals with extensive hardware and software information, and actionable recommendations to help organizations accelerate their IT infrastructure planning process, and gather more detail on assets that reside within their current environment. This … Continue reading

Posted in SQL Server | Tagged , | Leave a comment

Script to find when a table was last modified

I have had a question from one of my collegues, how to find when was a table last modified. Here is what I suggest to use to find when was tables schema changed and when was the last user update/delete … Continue reading

Posted in SQL Server, T-SQL Scripts, Tricks | Tagged , | Leave a comment

SQL Server configurations List

Was just checking sql server configuration of my sql installation via t-sql and found a way of listing which sql server configurations can be changed dynamically. Here is the list of SQL Server configurations with their descriptions, that can be … Continue reading

Posted in SQL Server, T-SQL Scripts, Tricks | Tagged | Leave a comment

Read SQL Server error Log and SQL agent log

Often DBA’s need to quickly look at sql server error log and agent logs to find something speicific, and it takes awful lot of time to go through a huge error log file; and you want to get the information … Continue reading

Posted in SQL Server, sql server error log, T-SQL Scripts, Tricks | Tagged , , , | Leave a comment

User ‘public’ does not have permission to run DBCC showfilestats for database ‘ testing’

User ‘public’ does not have permission to run DBCC showfilestats for database ‘ testing’ This error message is raised when your user account does not have the db_owner role of a database meaning you are not the owner of the … Continue reading

Posted in SQL Server, T-SQL Scripts, Tricks, Troubleshooting | Tagged , , | Leave a comment

Ever wonder what rules does System consistency checker validate

System consistency checker is a tool to check for conditions that prevent a successful SQL Server Installation. This is an essential tool and is triggered a couple of times by the sql setup. System consistency checker (SCC) checks the system … Continue reading

Posted in Setup, SQL Server, System Consistency Checker | Tagged , | 5 Comments

Starting my Journey to MCM SQL Server 2008

Today is 1st of March 2012 and I am inspired enough to start my journey towards MCM sql server 2008. First things first after 6 yrs 7 months of my total SQL DBA experience I need to revise and get … Continue reading

Posted in MCITP, MCM, MCTS | 2 Comments