ERROR 2596 : The repair statement was not processed. The database cannot be in read-only mode.
SQL SERVER – Stop SQL Server Immediately Using T-SQL
This question has came up many quite a few times with our development team as well as emails I have received about how to stop SQL Server immediately (due to accidentally ran t-sql, business logic or just need of to stop SQL Server using T-SQL). Answer is very simple, run…
Read MoreSQL SERVER – One Thing All DBA Must Know
FULLY BACKUP DATABASE. Update : I posted this post with only line. However I received many comments and questions asking different questions related to it. I have compiled all of them and modified this post. Most asked Question : What is the best time when database should be backed up?…
Read More
SQLAuthority News – Download SQL Server 2005 Samples and Sample Databases
Microsoft has purchased GitHub, the world’s leading software development platform where more than 28 million developers learn, share and collaborate to create the future for 7.5 Billion dollars.Â
SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey
I will be traveling for next two days to New York and New Jersey for Database Architecture and Implementation Discussion with one of the largest software technology company. The major focus of this firm is environmental product analysis. I will be not able to answer any questions, comments and emails…
Read MoreSQLAuthority News – Microsoft SQL Server Compact 3.5 Server Tools Beta 2 Released
SQL Server Compact 3.5 Server Tools installs replication components on the IIS server enabling merge replication and remote data access (RDA) between SQL Server Compact 3.5 database on a Windows Desktop & Mobile devices and database servers running SQL Server 2005 and later versions of SQL Server 2005. Download SQL…
Read More
SQL SERVER – Two Different Ways to Comment Code – Explanation and Example
SQL Server has two different ways to comment code. Let us learn all of them here in this blog post. Various the options in the blog posts.
SQLAuthority News – Book Review – SQL Server 2005 Practical Troubleshooting: The Database Engine
SQLAuthority.com Book Review : SQL Server 2005 Practical Troubleshooting: The Database Engine (SQL Server Series) (Paperback) by Ken Henderson Link to book on Amazon Short Review : Database Administrators can use this book on a daily basis in SQL Server 2005 troubleshooting and problem solving. Answers to SQL issues can…
Read MoreSQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details
SQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details This error is very common and many times, I have seen affect of this error as Suspected Database, Database Operation Ceased,…
Read MoreSQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Search SQL
In meeting with DBA friends one of my friend suggested while searching for “MSSQL Client” Microsoft returns you suggestion as “MySQL Client“. I did not believe it so I tested it myself. He was correct. Here is the screen shot. Reference : Pinal Dave (https://blog.sqlauthority.com)
Read More