-
It's time for a change. This website, BeyondRelational.com , is rolling out a new Blogs module with improved features, feedback and social opportunities. All 146 of my posts have been moved to the new location: http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx?tab=default . All future...
-
Often, students and colleagues come up to me and enquire how do they get started learning about some of the newest technologies. They generally do not seem to have issues with getting the study materials (most common study materials are the many blogs on the Internet and MSDN documentation). The one...
-
A lot changed on the technology space this month. Today, I would write about a couple of these announcements that are bound to dominate the technology space in 2012. There are a lot of new announcements coming through, but below are the products that I would be watching out for. New Server Systems! SQL...
-
I recently had the opportunity to view some of the newest courses from Pluralsight , an organization that offers online training courses for developers. One of the courses that I viewed was the SQL Server Questions & Answers ( http://www.pluralsight-training.net/microsoft/Courses/TableOfContents...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
02-22-2012
Filed under:
Filed under: Development, Administration, T-SQL, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Community, Myths
-
All systems are susceptible to failure. No software is perfect, and therefore it is natural that SSMS too will fail. Today, I have put together some of the most common failures that I have experienced with SSMS and their known workarounds. The reason I have kept this part of the tutorial as a L200 is...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
02-15-2012
Filed under:
Filed under: Development, Administration, Tips, SQL Server, #SQLServer, Guidance, SSMS, Tools and Utilities, Community, Series, VTD
-
As mentioned in Part 01 of this tutorial series, one of the key responsibilities of SSMS was to replace the erstwhile SQL Server Enterprise Manager – the interface that is used to manage & maintain the SQL Server instance configuration. In addition to the tools and utilities available within the...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
02-12-2012
Filed under:
Filed under: Development, Administration, T-SQL, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Guidance, DBA, SSMS, Tools and Utilities, Community, Series, Debugging
-
One of the most important aspects of SQL Server administration and maintenance is the ability to review and changing the existing configuration of the server. In Part 01 of this tutorial series, I had mentioned that one of the key responsibilities of SSMS was to replace the erstwhile SQL Server Enterprise...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
02-08-2012
Filed under:
Filed under: Development, Administration, Tips, SQL Server, #SQLServer, #TSQL, Guidance, DBA, SSMS, Tools and Utilities, Community, Series
-
The SQL Server Management studio contains many pop-up utilities and tools that help in improving the productivity of our day-to-day database administration and maintenance tasks. While most of these would be implemented using T-SQL code in production, these tools & utilities are a great way to get...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
02-05-2012
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Guidance, DBA, SSMS, Tools and Utilities, Community, Series
-
The SQL Server Management Studio (SSMS) continues to fascinate me with it’s immense wealth of features geared towards developer & administrator usability. What’s more amazing is that some features perform multiple useful functions depending upon the context. Today, we will have a look at one such...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
02-01-2012
Filed under:
Filed under: Development, Administration, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Community, Series
-
The SQL Server Management Studio is truly an Integrated Development Environment. There are utilities, tools and graphical designers available within SSMS which are useful to audiences of multiple levels. The graphical designers are a set of utilities, which allow one to perform basic SQL Server development...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
01-29-2012
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Guidance, DBA, SSMS, Tools and Utilities, Community, Series
-
For those who have worked in Enterprise environments, documentation is of utmost importance. Documentation can be in the form of a text-based document, or a graphical document (in the form of a diagram). A data dictionary is a centralized repository of information about data such as meaning, relationships...
-
More often than not, there is a myth in the developer community that Microsoft SQL Server does not provide the debugging abilities that other IDEs provide. Even SQL Server 2000 provided basic debugging ability. Starting Microsoft SQL Server 2005, the product now comes with it’s own Management Studio...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
01-22-2012
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, Denali, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Community, Series, Debugging
-
As you know, we are exploring the world of graphical tools & utilities that are available to us out of the box in a Microsoft SQL Server installation. In the previous part of the tutorial, I provided an introduction to the SQL Server Management Studio (SSMS) and the Query Editor window. I hope that...
-
Managing multiple instances of SQL Servers and databases is a challenging task, having a third party tool is not a problem however it is always BEST to manage the show using SQL Server Management Studio (SSMS). SQL Server tools are easy to use and help to manage multi-server management through automated...
-
Per Books-On-Line, The Microsoft SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. The SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
01-15-2012
Filed under:
Filed under: Development, Administration, Tips, SQL Server, #SQLServer, #TSQL, Guidance, SSMS, Tools and Utilities, Community, Series