-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Denali comes up with a Task List feature out of box with SSMS.This will help you to add your tasks and mark them complete when they are finished. I liked…
By default TCP/IP protocol will be disabled for SQL Server Developer Edition of SQL Server.You would require to enable the same to use a port other than the default one.…
Do a full backup or differential backup will clear the tran_log? I am interested to see your response and a justification for your answer is most accepted. Answer(Posted on 19th May…
There should be a definite plan to implement a cluster upgrade,and its important to have a proper checklist for the same: 1. Take database backup’s including system databases. 2. Script out all…
Database mirroring is a wonderful concept and I have observed that there are some misunderstood concepts too within Mirroring.Below are couple of them : Witness server – There is a…
This table is the datastore for all the messages in sql server system.The severity of the message is also included.I was curious to understand messages are generated in what all…
Recently came across an interesting situation where I was installing SQL Server 2005 Developer(RTM) and Enterprise on QA and PRODUCTION environments respectively. During install I got an error, which said…
I have been working on various configure options which sql will allow its users to do and they are really interesting. Note : Changing these options should be done only…
Cloud & SQLSailor 