Move from Scan to Seek
As a SQL optimization best practice, Scans are bad, Seeks are good.
Database
ASP.NET with MySQL: Configuration Error (MySql.Web.v20)
Integrating MySQL db with a ASP.NET and got stucked in "Parser Error Message: Could not load file or assembly 'MySql.Web.v20, Version=6.9.4.0'". Learn how to address this through MySQL .NET Connector installation.
SQL Server: Cool tips & tricks
These cool T-SQL tips & tricks that can prove very handy and help resolving/addressing some of your SQL Server works with comparatively less effort and quickly.
Know Your Database Statistics?
Its very important to know your database stats while planning for some architectural update or database migration. The beforehand information would always add a plus to mitigate any risk and proactively take actions. Below is SQL Server…
Reverse Data Synchronization
Synchronization of data from Production to Development environment is merely a task of taking backup of Production DB, restoring it to Development environment and running to cleanup scripts to hide/overwrite user-specific critical information. This is pretty straight…