There was a question from one of the users on buffer storage usage.The question was something like this ‘I want to make a table into buffer storage and keep as…
There are couple of new DMV’s which came to my attention today and I would like to share them with you all. sys.dm_os_windows_info: This DMV will get you OS related…
One of my favorite DBCC Command is DBCC SQLPERF(logspace) This will give you log space usage overview quickly.
Recently I was asked this question by a user.His backup detected log corruption and he was looking for the safest way to recover from the error. As the error was…
If you are in a situation that you need not want server to be rebooted after SQL Server 2008 R2 install,then follow the below steps You can bypass the “Restart…
Recently I was asked this interesting question – I need to revoke all privileges from a single table in the database,how can I do that? Solution is simple – Using…
Here is a wonderful demo of SQL Server 2012 integrated with Microsoft Kinect.Use your hands and legs working with databases ! http://www.youtube.com/watch?feature=player_embedded&v=Mx-Y8KFFHpE#! Dont you think this is a cool stuff.
Great news! By the end of the year SQL Azure will support 150GB databases.Current limit is 50GB.
You can easily find that using SELECT LOGINPROPERTY(‘TestUser’, ‘IsLocked’) You can unlock the login using ALTER LOGIN [XYZ] WITH PASSWORD = ‘****’ UNLOCK ; GO…
Today I came across an error Property Owner is not available for Database ‘[DBName]’. This property may not exist for this object, or may not be retrievable due to insufficient…