Cloud is changing the way how IT world is evolving. Honestly, just like every product and service, there are always the best practices to follow for optimal outcome. Let us learn about Developing Multi-tenant Applications for the Cloud.
SQL SERVER – Weekly Series – Memory Lane – #013
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…
Read MoreSQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query
Everybody knows about NOLOCK Â but not everyone knows about NOWAIT. They are different and they have an entire different purpose. In this blog post we will not talk about NOLOCK but we will see how NOWAIT will work. The idea of writing about blog post is based on the question…
Read More
SQL SERVER – How to Use Instead of Trigger
A trigger is an exceptional sort of stored procedure which functions when we try to amend the data in a table like inserting, deleting or updating data. It is a database object, executed automatically and is bound to a table. Fundamentally, triggers are classified into two types mainly-
SQL SERVER – TRIM Function to Remove Leading and Trailing Spaces of String – SQL in Sixty Seconds #040 – Video
Trim is one of the most frequently used operation over String data types. A developer often come across a scenario where they have the string with leading and trailing spaces around string. If your business logic suggests that the logs around the spaces are not useful they should be trimmed. However, in SQL Server there is no TRIM function. When a TRIM function is used it will throw an error.
SQLAuthority News – Great Experience at SharePoint Conference Singapore 2013
Last week, I had great pleasure to present at SharePoint Conference Singapore . It was my second time visit to this event and I had a great time attending this event. The event had more than 900 attendees and it was moved to bigger and better location since the last time.…
Read MoreSQL SERVER – Best Practices to Store the SQL Server Backups
Nobody doubts the necessity to create SQL Server backups – I have covered this topic extensively before. The question of where to store the backups however often goes unanswered. I will try to compare some of the most popular options for  this task. For demonstration purposes we will use the…
Read More