Tag Archives: milestone

Milestone of 500+ article

Milestone of 500+ article

This post is 504th post in my blog. I have started sharing my knowledge in form of blog article three years back. Initially I, just, wanted to keep my script collection online so that I can find it easily as and when I need it but later on my blog has gained overwhelming response from the community.

I have started my blogging journey with “SQLHub.com” which was focusing on relational database only but later one I think to go beyond relational database and hence I have booked another domain, named “Extreme-Advice.com”.

I have started writing articles in “Extreme-Advice.com” 5 months back only. As soon as I have started “Extreme-Advice.com”, I found I had Alexa rank 1.8+ million world wide and 100K + in India but due to overwhelming response from the reader, I have reached to 19K+ rank in India and 160K+ world wide.

alexa

I don’t like to measure my blog performance by rank or by the hit I used to get. I would always like to know how many people I have helped so far and each email from the reader motivate me to work even harder as a blogger.

Whatever script I develop for my need, I used to share it with my blog reader. I share, mostly, those script which I use myself but out of all scripts some of the scripts are very useful and I would like to keep it handy so that I can easily find it out. Herewith, I am proving bookmark of those script and I hope you too find it useful and keep it handy, you never know, when shall you need it!!!

DBA Related Articles:

  • Query to Find missing job in SQL Server (Click Here)
  • Capture Schema Change in SQL Server to maintain history (Click Here)
  • Capture long running query in SQL Server (Click Here)
  • Analyze IO disk pressure in SQL Server (Click Here)
  • Transactions/Sec and Batch Requests/Sec performance counter in SQL Server (Click Here)
  • Find Disk performance with sys.Dm_io_virtual_file_stats in SQL Server (Click Here)
  • Find currently running session/process in SQL Server database/instance with help of sys.dm_exec_requests and sys.dm_exec_sessions (Click here)
  • use sys.dm_exec_requests and sys.dm_exec_sessions to find who are logged in to your SQL Server Instance (Click Here)
  • Find Pending IO with sys.dm_io_pending_io_requests and sys.Dm_io_virtual_file_stats in SQL Server (Click Here)
  • Find locked table name with duration and count in SQL Server (Click Here)
  • Find Blocking in SQL Server and use it to send an alert (Click Here)
  • Calculate Table & Schema size in SQL Server (Click Here)
  • Get row count for tables quickly in SQL Server (Click Here)
  • Find database restore date in SQL Server (Click Here)
  • Find Database backup history in SQL Server (Click Here)
  • Generate script to create and drop Primary Key and Foreign Key in SQL Server (Click Here)
  • “Max degree of parallelism” or “MAXDOP”, good guy or bad guy? (Click Here)
  • Find SQL Server Agent job ran on specific date with its status (Click Here)
  • Keep watch on your disk space in SQL Server 2008/2005 (Click Here)
  • Keep watch on your database file size in SQL Server 2008/2005 (Click Here)
  • Performance Counter in SQL Server (Click Here)
  • Repl. Pending Xacts performance counter and high value in SQL Server (Click Here)
  • Performance Counter in Microsoft Windows Server 2008 (Click Here)
  • Implementing physical Database Structure in SQL Server (Click Here)
  • Create windows login and user in all databases with dataReader and dataWriter role in SQL Server 2008 (Click Here)
  • Shrink log file for all database in SQL Server 2008/2005 (Click Here)
  • Find user in all database with Sp_MSforEachDB in SQL Server 2005 (Click Here)
  • NOLOCK hint in SQL Server, Good guy or bad guy? (Click Here)
  • LOG Parser – Wonderful yet under-appreciated tool to read log of windows, IIS (Click Here)
  • Read IIS log with LOG Parser in SQL-Like language (Click Here)
  • Add/Remove column in IIS log file (Click Here)
  • Auto IIS log reading with Log Parser (Click Here)
  • Find TCP/IP port of SQL Server 2012 (Click Here)
  • Monitor user login connected to SQL Server (Click Here)
  • Start and stop server side trace profiler automatically in SQL Server 2012 (Click Here)
  • Read SQL Server Profiler Trace files with SELECT statement (Click Here)
  • Search SQL Server Object (Click Here)
  • Mirror backup to take full backup at multiple location in SQL Server (Click Here)
  • Split SQL Server Full backup in multiple files for faster backup (Click Here)
  • Backup and Restore Filegroup in SQL Server (Click Here)
  • Search SQL Server Job based on keyword provided (Click Here)
  • CXPACKET wait stats in SQL Server (Click Here)
  • Script all SQL Server Job automatically by SSIS and SMO (Click Here)
  • List of Table in Filegroup with table size in SQL Server (Click Here)
  • Automatic script backup of email operator in SQL Server by SSIS and SMO (Click Here)
  • Automatic script backup of mail profile in SQL Server by SSIS and SMO (Click Here)
  • GRANT VIEW DEFINATION permission to all Stored Procedures in SQL Server (Click Here)
  • Backup Linked Server script in SQL Server by SSIS (Click Here)
  • Keep watch on heavy software usage directly in production server (Click Here)
  • Get list of failed SQL Server Agent job in SQL Server (Click Here)
  • Get list of SQL Server Jobs from multiple instance via SSIS package (Click Here)

Service Broker Articles:

  • Importance of Service Broker in SQL Server (Click Here)
  • Introduction of Service Broker in SQL Server (Click Here)
  • Enable Service Broker in SQL Server database (Click Here)
  • Small demonstration of Service broker for beginners (Click Here)
  • Find Service Broker Object like Contract, Message Type, Service Name, Queue Name in SQL Server (Click Here)
  • Find Service Broker Queue Count in SQL Server (Click Here)
  • Get Transmission queue row count in Service Broker (Click Here)
  • Purge target Transmission queue of Service Broker in SQL Server (Click Here)
  • Deal with size of Transmission Queue table sysxmitqueue in MSDB database (Click Here)
  • Service Broker implementation between two tables in one database (Click Here)
  • Service Broker Queue Activation and Thread in SQL Server (Click Here)

INDEX Related Articles:

  • Some basics about Index in SQL Server (Click Here)
  • Clustered Index in SQL Server (Click Here)
  • Nonclustered Index in SQL Server (Click Here)
  • Included Column Index with non clustered index in SQL Server 2005/2008/Denali (Click Here)
  • Filtered Index in SQL Server 2008/Denali (Click Here)
  • Cannot create index on view Msg 1940, Level 16, State 1, Line 1 (Click Here)
  • Calculate total size of clustered and non-clustered index for database in SQL Server 2008/2005 (Click Here)
  • Full Text Catalog and Full Text Index (Integrated Full Text Search – iFTS in SQL Server 2008 Part 2) (Click Here)
  • Do you know Index Statistics in SQL Server (Click Here)
  • Index Rebuild or Reorganize in SQL Server (Click Here)
  • Index Fillfactor in SQL Server (Click Here)
  • Find missing Index with DMVs in SQL Server 2005/2008/Denali (Click Here)
  • Find unused index in SQL Server 2005/2008/Denali (Click Here)
  • sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats in SQL Server 2005 (Click Here)
  • Move clustered index to different filegroup in SQL Server (Click Here)

Replication Related Articles:

  • Understanding Replication with implementation of Snapshot replication in SQL Server 2012 (Click Here)
  • Remove Replication from SQL Server 2012 (Click Here)
  • Error Fix – Cannot execute as the database principal(Click Here)
  • Setup Transaction Replication in SQL Server 2012 (Click Here)
  • Add new article in transactional replication in SQL Server 2012 (Click Here)
  • Delete article from transactional replication in SQL Server 2012 (Click Here)
  • Find highest latency in transactional replication in SQL Server 2012 (Click Here)
  • Be familiar with important terms of replication in SQL Server (Click Here)
  • Find Object participated in replication (Click Here)
  • Add table in transactional replication from script in SQL Server (Click Here)
  • Add stored procedure in transactional replication by script in SQL Server (click Here)
  • Forcefully remove replication publisher, subscriber and distributor in SQL Server (Click Here)
  • Move replicated database file to new location in SQL Server 2012 (Click Here)
  • Script backup of replication setup of SQL Server by SSIS and SMO (Click Here)
  • Insert Tracer Token to see replication latency (Click Here)
  • Generate script to add multiple table in replication as article (Click Here)
  • Find undistributed replication command in SQL Server (Click Here)
  • Keep watch on replication undistributed command in SQL Server via SSIS (Click Here)
  • Keep an eye on replication error in SQL Server (Click Here)

Mirroring Related Articles:

  • Setup Certificate mirroring in SQL Server 2008 R2 (Click Here)
  • Check mirroring status from mirroring monitor in SQL Server (Click Here)
  • Find mirroring status by querying sys.database_mirroring in SQL Server (Click Here)
  • Database maintenance in mirroring principal database in SQL Server (Click Here)
  • Mirroring SYNCHRONIZING status and DBMIRROR_DBM_EVENT wait type (Click Here)

Error Handling & Transaction Related Articles:

  • Introduction to Filestream in SQL Server 2012 (Click Here)
  • Error handling with “THROW” command in SQL Server 2012 (Click Here)
  • List of Errors and severity level in SQL Server with catalog view sysmessages (Click Here)
  • Create custom error message by sys.sp_addmessage in SQL Server 2012 (Click Here)
  • Importance of transaction in SQL Server (Click Here)
  • Capture and log error of TSQL code in SQL Server 2012 (Click Here)
  • SET option XACT_ABORT and SQL Server Transaction (Click Here)

 Filestream Related Articles:

  • Introduction to Filestream in SQL Server 2012 (Click Here)
  • Create table with Filestream column in SQL Server 2012 (Click Here)

Microsoft Windows / SQL Azure:

  • What is Cloud Computing? (Click Here)
  • Understanding Microsoft Cloud and its essential part (Click Here)
  • Setup development environment for Windows Azure (Click Here)
  • Create Database and Server in SQL Azure (Click Here)
  • SQL Server 2008 SSMS and lower can’t be connected to SQL Azure (Click Here)
  • DMV to monitor SQL Azure database/Server (Click Here)

Encryption – Decryption:

  • Encryption – Decryption in SQL Server 2008 Part 1 (Click Here)
  • Service Master Key (Encryption – Decryption in SQL Server 2008 Part 2) (Click Here)
  • Database Master Key (Encryption – Decryption in SQL Server 2008 Part 3) (Click Here)
  • Certificate (Encryption – Decryption in SQL Server 2008 Part 4) (Click Here)
  • Asymmetric Key (Encryption – Decryption in SQL Server 2008 Part 5) (Click Here)
  • Symmetric Key (Encryption – Decryption in SQL Server 2008 Part 6) (Click Here)
  • Backup Database with Encrypted Data and Restore it (Encryption – Decryption in SQL Server 2008 Part 7) (Click Here)

Full Text Search:

  • Introduction of iFTS (Integrated Full Text Search – iFTS in SQL Server 2008 Part 1) (Click Here)
  • Full Text Catalog and Full Text Index (Integrated Full Text Search – iFTS in SQL Server 2008 Part 2) (Click Here)
  • FREETEXT Predicate (Integrated Full Text Search – iFTS in SQL Server 2008 Part 3) (Click Here)
  • FREETEXTTABLE Predicate (Integrated Full Text Search – iFTS in SQL Server 2008 Part 4) (Click Here)
  • CONTAINS Predicate (Integrated Full Text Search – iFTS in SQL Server 2008 Part 5) (Click Here)
  • CONTAINSTABLE Predicate (Integrated Full Text Search – iFTS in SQL Server 2008 Part 6) (Click Here)

Reference: Ritesh Shah

http://Extreme-Advice.com

http://www.sqlhub.com

Note: Microsoft Books online is a default reference of all articles .