A part from performance many times we faced challenges related to space of our database. Sometimes our database is actually taking huge space and sometimes it our mistake due to which it took space. It is worst condition when you are on a dedicated hosting or cloud hosting with limited space. In such case “Compression” …
When we heard “Kill” then first impression of this word is very bad. We always scare with this word. In real world we never want this action from anyone but in SQL Server case it is very helpful and help us many times. This feature we can use but very carefully. It is something like …
Dear Friends, In my last article (TIP 87) I wrote about PWDENCRYPT. I forgot to write few details but thanks to all my talented friends & blog readers who guided me by providing there feedback on post. I respect their inputs and always interested to get more inputs. Thanks to all of you. Now I …
I the last tip TIP#88 we saw how to encrypt a password. Now in this tip I would like to share how to check encrypted password ? Means once you stored your encrypted password in database now next step is to compare that particular password with your input password and return results accordingly. The …
Security is always a concern for every database developer. How to secure valuable information is one of the major and important aspect. The first approach toward security to have a strong username & password and the next step is to have password in encrypted form. Now this article will help you to encrypt your password …
Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which SQL Server provides. By using this stored procedure we can easily determine all the dependencies of particular table. The stored procedure is sp_msdependencies We can use this stored procedure as shown below Execute sp_msdependencies …
It might be already known to you but I thought for sharing because I frequently use this command and it is very useful command. When someone wants to determine detail of a function or stored procedure he/she can use this useful command. The syntax is very simple. Just write sp_helptext Storedprocedure/ functionname For example …
One of the good sentence I remember “When someone has teeth he/she is not having nuts and when someone has nuts he/she not having teeth”. Just joke a part. You understand what I mean to say here. If you have the resources then utilize it. One of the most most important aspect in performance …
In last TIP #78 we have discussed Change tracker (CT) which was introduced in SQL SERVER 2008. CT feature only tracks which row is changes means on which row Insert/update/delete operation is performed but it does not track what exact value is changed. If we want an audit of database means whatever changes occurred …
I am pretty much sure by the title of this post you had idea of the post content. Although I am late to post this feature but anyways Change Tracking (CT) is a feature came in SQL SERVER 2008. As the name mention it track the changes like DELETE, INSERT , UPDATE type DML …