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 More
SQLAuthority 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
SQL SERVER – Disabling Indexes – Non Clustered Indexes
I came across a fantastic T-SQL script that offers an additional feature for changing the recovery mode while enabling and disabling indexes.
SQLAuthority Author Visit – A True Outsourcing Giant and Technology Leader DigiCorp in Ahmedabad India
Last week, I happen to visit one of the tech company in Ahmedabad, India. I visit different IT organization for two purpose – learn more about technology advancement in different organization and help them with any issues if they are facing with Microsoft technology and in particular SQL Server. I…
Read MoreSQL SERVER – Find Current Location of Data and Log File of All the Database
As I am doing lots of experiments on my SQL Server test box, I sometime gets too many files in SQL Server data installation folder – the place where I have all the .mdf and .ldf files are stored. I often go to that folder and clean up all unnecessary…
Read More