|
|
-
|
|
The server principal is not able to access the database under the current security context, is the error message appears for those users who was able to access the database / application earlier especially after refreshing database from production to d...
|
|
-
|
|
Couple of week back I have received a special gift, from the person whom I admire as a elder bro and mentor – Satya SkJ. Recently he has written a cook book on SQL Server 2008 R2 Administration, forward written by MVP Brad McGehee, and reviewed by Vinod ...
|
|
-
|
|
Microsoft has recently released a Cumulative Update (CU) # 16 for SQL Server 2008 SP1 which contains hotfixes which were resolved after SQL Server 2008 SP1; once you will install / apply this CU the server version would be 10.00.2850.00 As always ...
|
|
-
|
|
Friend of my mine and fellow MVP Jecob Sebastian is running SQL Server DBA Quiz 2011 on his community web site – BeyondRelational. He asked me to submit question as a Quiz Master, so, here is my question for you all : You have an SQL Server Integr...
|
|
-
|
|
While working on an assignment of troubleshooting performance issue few month back I have come across a situation where I have to provide good information about the different waittypes and what they do, while researching a good documentation on wait type...
|
|
-
|
|
When we have Peer to Peer (P2P) replication in place on SQL Server 2008, probably we would see a conflict 1) conflict of type 'Update-Update' was detected at peer 2 between peer 1 (incoming) 2) conflict of type 'Update-Delete’ was detected at peer 2 bet...
|
|
-
|
|
Few month ago I have written a post about what is Auto Growth and what is the best practice for Auto Growth. In this post I have discussed about why should we have Auto Growth for databases set in a fixed MB instead in percentage and how it will impact...
|
|
-
|
|
Most of the time, due to different business requirements we do have to work on various RDBMS systems, Oracle and MS SQL Server are the widely used and popular RDBMS. Sometimes we need to import/export data from/to SQL Server and for that we’ve to use Lin...
|
|
-
|
|
Often I see a question in community on how to quickly check the status of the database mirroring, sometime in busy environment and busy server launching database mirroring keep us waiting for a while, so is there a way we can check database mirroring statu...
|
|