SQL SERVER – How to Script Statistics from SSMS? – Scripting Statistics is Disabled in SSMS
SQL SERVER – Statistics for Read-Only Database are in TempDB
SQL SERVER – Building Three-Part Name from OBJECT-ID – Database Name, Schema Name, TableName
SQL SERVER – MySQL – Order Column by Nearest Value for Any Integer
Here is a very interesting question I received, which is based on my MySQL courses. The same script works on SQL Server as well as MySQL. Let us understand how to Order Column by Nearest Value for Any Integer.
SQL SERVER – SQL Server Configuration Checking – A Must Do for Every DBA – Notes from the Field #004
SQL SERVER – Export Data AS CSV from Database Using SQLCMD
We have covered multiple times in this blog that we can import CSV to Database very easily. However, recently I received a very interesting question where the user wants to export data with the help of SQLCMD.
Personal Technology – A Quick Note on Good Elevator Etiquette
SQL – Everything about Data Magazine – FREE to Subscribe
Print media is gradually fading out as we are moving to the new exciting world of digital gadgets. I have seen quite a lot of friends who used to tell me that they will never buy kindle or ebook reader as they do not like reading electronically. However, the same set of people I have seen now a days sporting kindle or flipping electronics magazine in their smart phones.




