-
SSMS, or SQL Server Management Studio is a wonderful tool, and those who frequent this blog will notice that I tend to try and make day to day task simpler using the SSMS. In a development environment, databases are created and backups restored often. Most developers have rights to the development instance...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
06-22-2011
Filed under:
Filed under: Administration, Tips, SQL Server, #SQLServer, Best Practices, Guidance, Installation, DBA, SSMS, Tools and Utilities, Connect Cases
-
Today’s post takes me back to the days when I was learning SQL Server at the engineering school about 8 years ago. I learnt SQL 7 and SQL 2000 and then as I joined my present employer, SQL 2005 came along. While SQL 7/2000 had the Enterprise Manager, SQL 2005 onwards we have the SSMS – SQL...
-
A nice new little add-in available for SSMS on Codeplex . It helps with repetitive tasks involved with SSAS such as processing and deployment. As the site says, the goal for the Analysis Services Helper is to fill in gaps in the toolset inside SSMS, and decrease time spent on administrative or repetitive...
-
A couple of months ago, I ran into a strange issue. Whenever I fired the “RECONFIGURE” statement, the SQL Server returned an error message - “Ad hoc update to system catalog is not supported.” I was able to trace this to the fact that somebody had set the “allow updates”...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
06-15-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities, Myths, Connect Cases
-
I recently completed running a series on the “ Underappreciated Features of Microsoft SQL Server ”, under which I introduced the SQLCMD mode available within the SQL Server Management Studio. SQLCMD mode is a means of using SQLCMD functionality within the SSMS, which would normally have been...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
06-12-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities
-
In May 2011, I presented an Exclusive Microsoft VTD Webcast on the “ Underappreciated Features of Microsoft SQL Server ”. It was an exclusive webcast series wherein industry experts came in and presented on various topics to create a scalable and secure environment for solution with SQL Server 2008 ...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
06-08-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities, Community, Series, Debugging, Tech-Ed, CTD, VTD
-
SQL Server Management Studio (SSMS) is the powerful tool for any developer/DBA to intereact with the SQL Server. It has lot of features that many people do not aware of. In this series of blog posts I am going to show you some features which are very helpful and not known by many people. While modifying...
-
Attention – ALL Professional Developers, Project Managers, Architects, IT Managers, IT Administrators and Implementers of Ahmedabad! Community Tech Days/Tech-Ed On The Road is back, and everyone is invited! The focal point of the day would be some of the best sessions from TechEd India 2011, and will...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
06-05-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities, Community, Series, Debugging, Tech-Ed, CTD, VTD
-
Many time in forums, I have seen question about Enterprise Evaluation Edition expiration. So idea of this blog post is to avoid repetitive screenshots (which i love to put in my replies as they are more powerful). So here we go… If you have SQL Server 2005/2008/2008 R2 Enterprise Evaluation edition and...
-
As you probably know by now, I use the Template Explorer a lot and encourage everyone to do the same. It is a great tool within the SSMS, and most developers and administrators adopt it with a smiling face. You can read all about it via the following posts: Template Explorer – Underappreciated features...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
06-01-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities, Myths, Connect Cases
-
Earlier this month, I presented a webcast on the “ Underappreciated features of Microsoft SQL Server ” during the “ Exclusive Webcast series on Microsoft SQL Server ”. As one of the developer productivity features provided with the SSMS, I presented the Template Explorer . The session received a very...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
05-29-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities, Community, Series, Debugging, Tech-Ed, CTD, VTD
-
Earlier this month, I presented a webcast on the “ Underappreciated features of Microsoft SQL Server ” during the “ Exclusive Webcast series on Microsoft SQL Server ”. As one of the developer productivity features provided with the SSMS, I presented the Template Explorer . The session received a very...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
05-25-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities, Community, Series, Debugging, Tech-Ed, CTD, VTD
-
I hope that all of you had a chance to participate in my session on the “Underappreciated Features of Microsoft SQL Server” during the Exclusive SQL Server Webcast series on Security & Scalability . If not, I trust the recorded sessions would be up soon for you to see. I will share the location of...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
05-22-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities, Series, Debugging
-
I hope that all of you had a chance to participate in my session on the “Underappreciated Features of Microsoft SQL Server” during the Exclusive SQL Server Webcast series on Security & Scalability . If not, I trust the recorded sessions would be up soon for you to see. I will share the location of...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
05-18-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities, Series, Debugging
-
I hope that all of you had a chance to participate in my session on the “Underappreciated Features of Microsoft SQL Server” during the Exclusive SQL Server Webcast series on Security & Scalability . If not, I trust the recorded sessions would be up soon for you to see. I will share the location of...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
05-15-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities, Series, Debugging