Wednesday, 7 December 2016

What do you understand by DAC in SQL Server?

Microsoft SQL Server provides a dedicated administrator connection (DAC). The DAC allows an administrator to access a running instance of SQL Server Database Engine to troubleshoot problems on the server—even when the server is unresponsive to other client connections. The DAC is available through the sqlcmd utility and SQL Server Management Studio. The connection is only allowed from a client running on the server. No network connections are permitted.
To use SQL Server Management Studio with the DAC, connect to an instance of the SQL Server Database Engine with Query Editor by typing ADMIN: before the server name. Object Explorer cannot connect using the DAC.

Click here for more
Blogger Widgets

What is the differences in CRM Application Architecture from CRM Online to CRM On-Premises?

  • Sticking with development, on premise allows for custom developed plug-ins. Online allows for this as well, but with limitations. Plug-ins are sandboxed with limited permissions and can only make requests to same CRM tenant or to external web services. Here again, this really comes down to how much customization you intend or foresee happening via plug-ins.
  • For all you SQL gurus out there, online does not allow direct access to SQL data; while on premise does. This will limit your development of custom reports to the use of FetchXML for online, while you can use either FetchXML or direct SQL access for on premise. This could be somewhat of an issue, if you have a development staff versed in SQL, there will be a slight learning process for switching over to FetchXML.
  • CRM Online only offers Claims-Based Authentication and Security where CRM On-Premises offers either Claims-Based Authentication or ADFS. 
  • CRM On-Premises allows unlimited workflows and entities, where Online has a limit of 200 workflows and 300 entities.

Tuesday, 6 December 2016

Types of Views in SQL Server?

Below are the types of View in SQL Server

  • Indexed Views:An indexed view is a view that has been materialized. This means the view definition has been computed and the resulting data stored just like a table. You index a view by creating a unique clustered index on it. Indexed views can dramatically improve the performance of some types of queries. Indexed views work best for queries that aggregate many rows. They are not well-suited for underlying data sets that are frequently updated.
  • Partitioned Views:A partitioned view joins horizontally partitioned data from a set of member tables across one or more servers. This makes the data appear as if from one table. A view that joins member tables on the same instance of SQL Server is a local partitioned view.
  • System Views:System views expose catalog metadata. You can use system views to return information about the instance of SQL Server or the objects defined in the instance. For example, you can query the sys.databases catalog view to return information about the user-defined databases available in the instance. 

What are the major problem areas that can degrade SQL Server performance?

Following are the major problem areas that can degrade SQL Server performance:

  • Poor indexing/Bad indexing
  • Inaccurate statistics
  • Poor query design
  • Poor execution plans
  • Non-set-based operations, usually T-SQL cursors
  • Poor database design
  • Excessive blocking and deadlocks
  • Excessive fragmentation
  • Nonreusable execution plans
  • Frequent recompilation of queries
  • Improper use of cursors
  • Improper configuration of the database log

Thursday, 1 December 2016

What you do to performance tune your SQL Server on regular basis in your current organization?

Below are my regular jobs to keep my SQL Server fast.

  • Identifying problematic SQL queries
  • Analyzing a query execution plan
  • Evaluating the effectiveness of the current indexes
  • Avoiding bookmark lookups
  • Evaluating the effectiveness of the current statistics
  • Analyzing and resolving fragmentation
  • Optimizing execution plan caching
  • Analyzing and avoiding stored procedure recompilation
  • Minimizing blocking and deadlocks
  • Analyzing the effectiveness of cursor use

What do you understand by DVMs in SQL Server?

The DMVs were introduced in SQL 2005, DMVs allow you to get better insight into what is happening in SQL Server.  Without these new tools a lot of the information was unavailable or very difficult to obtain.

Here are some of the more useful DMVs that you should familiarize yourself with:

  • sys.dm_exec_sessions - Sessions in SQL Server
  • sys.dm_exec_cached_plans - Cached query plans available to SQL Server
  • sys.dm_exec_connections - Connections to SQL Server

What is R Services introduced in SQL Server 2016?

SQL Server R Services. R Services (In-Database) provides a platform for developing and deploying intelligent applications that uncover new insights. You can use the rich and powerful R language and the many packages from the community to create models and generate predictions using your SQL Server data.

Microsft CRM versions history

Below is the Microsft CRM versions history:

Microsoft CRM 1.0 (first version)
Microsoft CRM 1.2
Microsoft Dynamics CRM 3.0
Microsoft Dynamics CRM 4.0
Microsoft Dynamics CRM 2011
Microsoft Dynamics CRM 2013
Microsoft Dynamics CRM 2015
Microsoft Dynamics CRM 2016 (Latest version)