First of all – I must confess that I was not aware of this feature till I noticed it today. At home, I have multiple monitors, but when I am traveling, I have single laptop along with me. It is often that when I am working with SQL Server I have to refer web for information on the subject I am working on. Let us understand about SSMS Browser in this blog post.
SQL SERVER – Connecting to Server Using Windows Authentication by SQLCMD
Recently I got a call from an old friend I used to call “DJ”. Here is the exact conversation we had about SQLCMD.
SQL SERVER – FIX – ERROR – Service Logon Failure (ObjectExplorer)
Just another day I received following error while starting my agent. As soon as I received following error I felt like Deja Vu. I had similar feeling few days ago. I quickly looked at my blog post history and I found out following article SQL SERVER – Fix : Error…
Read MoreSQLAuthority News – Facebook Page and Twitter – Connect Using Social Media
I often get question if I am active on social media. I am very much active on social media. I have noticed that we have all are active on Facebook, I have created Facebook page where you can do discussion and follow on my updates. SQLAuthority.com Page I am very…
Read MoreSQL SERVER – SQL Server Compression Estimator
I recently come across an interesting tool called ‘SQL Server Compression Estimator’. I find this tool very interesting. This tool is a pretty decent tool and I used it on a couple of my personal server and it gave me a good estimate.
SQL SERVER – Attending MVP Open Day – May 2011
The MVP Open Day is an exclusive event for Asia Pacific & Greater China MVPs. MVPs from the region gather and have great time together. It is mix of education, fun and networking. I have previously written my experience over here. SQLAuthority News – MVP Open Day South Asia –…
Read MoreSQLAuthority News – Restart Remote Computer – Shutdown Remote Computer
I often work with multiple computer system. This machines are different machines. When I login using remote desktop to different machine, I often want to restart or shutdown the computer. Remote desktop does not let me shutdown computer when I have remote system as Windows 7. At this time, I…
Read More
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.