-
Today’s post is part of the series that I am running under the title " Under Appreciated Features of SQL Server ". The series has been inspired by Andy Warren's editorial on SQLServerCentral.com. The pre-requisite for today’s session is a basic knowledge of connecting to a SQL Server using...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
05-11-2011
Filed under:
Filed under: Development, Administration, T-SQL, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Series
-
Today’s post is part of the series that I am running under the title " Under Appreciated Features of SQL Server ". The series has been inspired by Andy Warren's editorial on SQLServerCentral.com. Microsoft SQL Server 2005 was a completely different SQL Server. The internals had changed...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
05-08-2011
Filed under:
Filed under: Development, Administration, T-SQL, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Series
-
Today’s post is part of the series that I am running under the title " Under Appreciated Features of SQL Server ". The series has been inspired by Andy Warren's editorial on SQLServerCentral.com. How often have you faced a situation wherein while the host operating system is perfectly operational...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
05-05-2011
Filed under:
Filed under: Development, Administration, T-SQL, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Series
-
This is in continuation to my series on the Underappreciated features of Microsoft SQL Server . The series has been inspired from Andy Warren’s editorial on SQLServerCentral.com of the same name . For any system that interfaces with other systems, bulk data transfer is a reality and has an importance...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
05-01-2011
Filed under:
Filed under: Development, Administration, T-SQL, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Series
-
I invite you all to be a part of the webcast series on SQL Server 2008 R2. This webcast series will take you through the features of SQL Server 2008 R2 and help you get a better control over the software solution environment. I will be one of the speakers and will be presenting a session on the “Underappreciated...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
04-28-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities, Community, Debugging, Tech-Ed, CTD, VTD
-
This is in continuation to my series on the Underappreciated features of Microsoft SQL Server . The series has been inspired from Andy Warren’s editorial on SQLServerCentral.com of the same name . Today, we will look at a great new T-SQL enhancement introduced since SQL Server 2005 – the APPLY operator...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
04-27-2011
Filed under:
Filed under: Development, Administration, T-SQL, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Series
-
This is in continuation to my series on the Underappreciated features of Microsoft SQL Server . The series has been inspired from Andy Warren’s editorial on SQLServerCentral.com of the same name . After a number of posts on my visit to Tech-Ed 2011 (India), we are now back on track and will continue...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
04-24-2011
Filed under:
Filed under: Development, Administration, T-SQL, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Series
-
Today, I will be sharing a very small, but important script. Recently, one of the database backups we had received failed to restore. I was faced with a problem of determining whether the problem was with the backup itself, or whether it was an I/O subsystem issue or some other failure. Like with all...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
04-17-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities
-
Here are a couple more SSMS tricks I’ve stumbled upon recently. Both involve the functionality of registered servers. If you really only deal with 1 or 2 servers in your environment, these probably won’t help you out much. But for those of us who have to deal with a large number of...
-
Since the start of the week, I am attempting to explore the concept of contained databases – something that I learnt about during a hands-on lab conducted by Jacob Sebastian. Please read my posts Part 01 , Part 02 and Part 03 in case you missed them. To get us back into context, let’s revisit the definition...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
04-13-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, Denali, #SQLServer, Best Practices, Guidance, Installation, DBA, SSMS, Tools and Utilities, Community, Series, Tech-Ed, #techedin
-
Since the start of the week, I am attempting to explore the concept of contained databases – something that I learnt about during a hands-on lab conducted by Jacob Sebastian. Please read my posts Part 01 and Part 02 in case you missed them. To get us back into context, let’s revisit the definition of...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
04-12-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, Denali, #SQLServer, Best Practices, Guidance, Installation, DBA, SSMS, Tools and Utilities, Community, Series, Tech-Ed, #techedin
-
Yesterday , I attempted to explore the concept of contained databases. Today, we will see how to create our first contained database in the very latest SQL 11 (“Denali”) CTP01. As discussed yesterday, contained databases are new to SQL 11, and hence if you need to experiment with contained databases...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
04-11-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, Denali, #SQLServer, Best Practices, Guidance, Installation, DBA, SSMS, Tools and Utilities, Community, Series, Tech-Ed, #techedin
-
As you know, I had visited Tech-Ed 2011 (India) last month. The last day of Tech-Ed was a special day for DBAs because we had a dedicated DBA track – and to add to it, we had a power packed hands-on lab from Jacob Sebastian and break-out sessions from Pinal Dave, Vinod Kumar, Prem Mehra and Balmukund...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
04-10-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, Denali, #SQLServer, Best Practices, Guidance, Installation, DBA, SSMS, Tools and Utilities, Community, Series, Tech-Ed, #techedin
-
This is one that I figured most everyone would know, but repeatedly over the past couple weeks in my office, I was surprised to find that many people had never seen this before. If you just click on objects in the object explorer, you can’t hold shift to select multiple objects. This leads...
-
As you know, I am documenting my experience at the Tech Ed 2011 (India) held from March 23-25, 2011 at Bengaluru, India. You can find the summary of my experiences on Day 01 and Day 02 at: Day 01 - http://beyondrelational.com/blogs/nakul/archive/2011/03/28/tech-ed-2011-india-day-01-connect-learn-explore...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
03-30-2011
Filed under:
Filed under: Development, Administration, T-SQL, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Community, Series, Tech-Ed, #techedin