-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Lets discuss this in a better and interesting way : Business Manager – Login ‘guyxyz’ is causing lot of issues and we need to know who created this login without…
Today I faced a situation where new LUN’s where added to a server and SQL was clustered on top of windows cluster. I wanted to use the new LUN’s to…
Trace flags are real helpful when it is used for a specific requirement. Trace flag can set a specific server characteristic or turn off a behavior. We have Global and Session level…
Recently I had to Install SQL Server 2008 Standard on a cluster and our setup was giving error like ‘Value cannot be null;Parameter=Connection’ This issue was fixed when I tried Slipstreaming.…
Today the concept of ‘contained databases’ caught my attention and it was indeed good to know that this feature can be really helpful as contained databases can be moved from…
Need to quickly find OS info? Just run ‘msinfo32’ and it will pull you all the info you need just in few seconds. I normally run this to check if…
Recently I received an error while installing SQL Server 2008 R2 Developer Edition.The error was saying about ‘File format is invalid’. Resolution : This erorr comes up when you have…
Full text search service will be offline and effort to make it online will fail.When you check the logs you can see the error “The SQL Server FullTextSearch (MSSQLSERVER) service…
Today I was going through a user question in one of the blog and it was related to ‘Max user connections to SQL Server’ If you run ‘ Select @@MAX_CONNECTIONS ‘ you will get…
Recently was observing log file growth for tempdb and noticed that SQL Server Engine will apply a CHECKPOINT automatically when the log file size reach a threshold of 70% (When autogrowth is disabled…
Cloud & SQLSailor 