The biggest request we keep on getting in SQL in Sixty Seconds is tricks with SQL Server Management Studio. It seems like SSMS is our favorite tool and we all want to share our neat tricks with everybody. Today I am going to share very popular and most requested SQL Server Tip. Sample data and test database is very common when working in a development environment. A developer often creates interesting samples as well challenging objects in their database. The architects work on databases and hand it over to developers, later developer hand it over to DBA. In simple words, in many cases the database move from one place to another place. It is not always possible to back up and restore databases. There are possibilities when only part of the database (with schema and data) has to be moved.
SQLAuthority Guest Post – Lessons from Life – Practice Let Go – Srini Chandra (Author of 3 Lives, in search of bliss)
I often see developers working hard on project, personal development and professional development. The ultimate goal is to progress and achieve something. The definition of progress and growth is very complex and the journey to achieve that is more complex than solving Fermat’s Last Theorem (Â x3Â +Â y3Â =Â z3). The question is now…
Read MoreSQL SERVER – 2012 Functions – FORMAT() and CONCAT() – An Interesting Usage
Before continuing this blog post I would like to bring your attention to two of my earlier blog post where I have written in depth about FORMAT and CONCAT function. String Function – FORMAT() – A Quick Introduction String Function – CONCAT() – A Quick Introduction Read the above two blog posts…
Read MoreSQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name
Place: Any Developer Shop Scenario: A developer wants to drop a column from a table Time: Any Day – usually right before developer wants to go home The developer rushes to the manager and following conversation begins: Developer: I want to drop  a column from one of the tables. Manager:…
Read MoreSQL SERVER – Example of Width Sensitive and Width Insensitive Collation
I had a great time writing blog post SQL SERVER – Effect of Case Sensitive Collation on Resultset. It was interesting to see lots of questions related to collation based on this blog post. However, one of the question, I find very interesting and though to share today here. Question: What is…
Read MoreSQL SERVER – Switch Between Two Parenthesis using Shortcut CTRL+]
Earlier this week I wrote a blog post about SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis, I received quite a lot of positive feedback from readers. If you are a regular reader of the blog post, you must be aware that I appreciate the learning shared by…
Read MoreSQL SERVER – Effect of Case Sensitive Collation on Resultset
Collation is a very interesting concept but I quite often see it is heavily neglected. I have seen developer and DBA looking for a workaround to fix collation error rather than understanding if the side effect of the workaround. Collation is a very deep subject. Earlier I wrote an article…
Read More