(Thomas LaRock) Are you afraid of deploying (or supporting) an instance of Windows Server Core?

(Chad Churchwell) So I am using this new technology called Availability Groups that was introduced in SQL Server 2012. I have heard I can offload my backups to a secondary replica, but I am not sure how that works or how to configure those backups. Are there any limitations?

(Pinal Dave) Recently I noticed a very interesting question on Stackoverflow. A user wanted to add a particular column between two of the rows. He had a experience with MySQL so he was attempting following syntax. Following syntax will throw an error.

(Derek Colley) Occasionally, new development work submitted from your developers (or indeed written by you, the data professional) can fail due to unforeseen execution errors. These errors are despite testing on your dev/test/QA platform.

(Luiz Santos) Applications connecting to SQL Server sometimes experience connections breaks due back-end failures. In general, they tend to be uncommon in LAN environment and more frequent in WAN topologies, when connectivity tends to be challenged by geographically dispersed links.

(Richard Carr) A common error when writing SQL triggers is to forget that an operation that affects multiple rows will cause a trigger to execute only once. One example of the problem can be solved using UPDATE statements that include joins.

(Pinal Dave) I love tricky questions – they are fun and educating. Yesterday I was presenting in one of the largest organization in India on SQL Server Performance Tuning Subject.

We all understand the importance of preparing for an interview: doing our homework on the company, clearly articulate what we can bring to that position, and projecting good body language throughout. But what are some of the things we need to remember as we are walking out of that interview?

(Vishal Gajjar) You can start/stop SQL Server services using Services Console or SQL Server Configuration Manager. You can also perform these operation using command line in Windows. For this you must run command prompt with Administrative privileges.

(Hemantgiri S. Goswami) Were you ever asked to generate string Permutations using TSql? I was recently asked to do so, and the logic which I could manage to come up at that point is shared in the below script.