What is Your Favorite Database?
SQLAuthority News – Author Visit – MVP Global Summit 2009 – Seattle and Redmond
MVP Global Summit 2009 is just a less than a week away and I am very all ready for attending my first MVP Global Summit. Microsoft Most Valuable Professionals (MVPs) are invited to attend the MVP Global Summit at the Washington State Convention & Trade Center in Seattle and at…
Read MoreSQL SERVER – Disable Windows Authentication – Remove Windows Authentication Login Account
I just received following email from one of the blog reader. Question : “How to disable Windows Authentication?” Answer : It can not be disabled. Windows Authentication is the most secure way to login in system. Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQLAuthority News – Ahmedabad User Group Meeting February 21 2009
We had Ahmedabad SQL Server User Group meeting on February 21, 2009 and it was wonderful to see so many people showing up for meeting. Gradually our group is growing and more and more developers and DBA are showing up. We had two session in this meeting. From the feedback…
Read MoreSQL SERVER – Download – Microsoft SQL Server 2008 Management Studio Express
Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SQL Server 2008 Management Studio Express combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server…
Read MoreSQL SERVER – My Observation – Effect of Clustered Index over Nonclustered Index
Note: This article is re-write of my previous article SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index. I have received so many request that re-write it as it is little confusing. I am going to re-write this with simpler words. Query optimization is one art which…
Read MoreSQLAuthority News – Ahmedabad User Group Meeting February 21 2009
It is my pleasure to announce that SQL Server User Group Meeting is held on February 21, 2009. This is the second meeting of year 2009 and will be one interesting meeting as we will have back to back two presentation from SQL Experts. The agenda of meeting will be…
Read More