Step - By - Step: Know CHECKDB and its activities

Good Article written by Author of the famous DBCC CHECKDB command

http://www.sqlskills.com/blogs/paul/checkdb-from-every-angle-complete-description-of-all-checkdb-stages/


...Happy SQLing / Thanks for Visiting and Sharing your Views

Popular SQL Server Blogs

Every one wants to be on top of technology and its updates and so am. In general on a daily practice, I have this list of blogs that I read through. hope you find it helpful

CSS SQL Server Engineers
SQL Server Blog
All Things SQL Server
All Things SQL Server
SQL Server Developer Center
SQL Server Forums
http://www.brentozar.com/
http://www.sqlskills.com/
http://sqlmag.com/
http://www.sqlservercentral.com/
http://sqlserverperformance.wordpress.com/
http://ola.hallengren.com/
http://www.sqlperformance.com/

You will find lot of information and solutions for any SQL Server related issues in these knowledge banks.



...Happy SQLing / Thanks for Visiting and Sharing your Views

T-SQL: Easy & Quick Search of Keyword inside the Stored procedures, Views, Functions

This is one of my favorite tool that I use most often rather than depending on third party GUI tools.
I often use this to figure out if I want to know where a particular function or procedure or String or Author is being called.

Searching a keyword in SQL server is as simple as  a simple SELECT.


/**Search with in a Database***/ 
SELECT * FROM SYS.all_sql_modules WHERE DEFINITION LIKE '%<KEYWORD>%'

/***To Search across the Server and all Databases***/  
EXEC sp_MSforeachdb "USE [?]; SELECT '?', OBJECT_NAME(OBJECT_ID), * FROM SYS.ALL_SQL_MODULES WHERE DEFINITION LIKE '%<KEYWORD>%'"


Although there are couple of free tool out there in the Internet, One of the ones of my likes is SQLSearch by Red-Gate software


...Happy SQLing / Thanks for Visiting and Sharing your Views

T-SQL to Know and compare Deprecated features with in SQL Server

Here's an easy approach to know the deprecated features with in your SQL Server.


SELECT * FROM sys.dm_os_performance_counters WHERE OBJECT_NAME LIKE '%Deprecated Features%'

You can also compare this DMV with SYS.all_sql_modules to identify the deprecated features in the stored procedures.




...Happy SQLing / Thanks for Visiting and Sharing your Views

SQL Server DBA Online Training

Hello Friends,

I am coming up with a training program to help aspired DBA's who are interested to improve technical skills and learn good stuff. This training would be targeted on Basic & Intermediate knowledge Levels. Would also be helpful to assist in resolving their day to day tasks/issues at work.

Hope this helps the fresh college graduates and also experienced candidates to acquire right knowledge and find a better job.

Please find attached the training flyer for more details and feel free to reach out to WAY2SQLDBA@gmail.com for any SQL needs.

 

Combination of right attitude and passion towards troubleshooting and debugging activities is the Key to be a Successful Database Administrator.

...Happy SQLing / Thanks for Visiting and Sharing your Views