Saturday, November 26, 2011

How to connect SQL Server using DAC on New Query Window(SSMS)

1. Open the new SSMS
2. Connection to Server window will popup , Please cancel it
3. click the NewQuery (Top Left corner)
4. Enter the following one of the option like  below  connection to Server popup window

Server Name : ADMIN:Servername
(OR)
Server Name : ADMIN:Servername\Instancename

Then you can run the below query to find connection

select * from sys.dm_exec_connections ec
join sys.endpoints ep on (ec.endpoint_id=ep.endpoint_id)
where ep.name='Dedicated Admin Connection'


Other option you can connect cmd prompt
c:\sqlcmd -S Servername -U sa -P 'xxxx' -A

Tuesday, November 22, 2011

SQL Server 2008 Service Pack 3 Cumulative Update 2 Released

Microsoft SQL Server 2008 Service Pack 3 (SP3) is now available for download. While keeping product changes contained, we have made significant investments to ease deployment and management of Service Packs. A few key enhancements for customers in Microsoft SQL Server 2008 Service Pack 3 are :
  • Enhanced upgrade experience from previous versions of SQL Server to SQL Server 2008 SP3. In addition, we have increased the performance & reliability of the setup experience.
  • In SQL Server Integration Services logs will now show the total number of rows sent in Data Flows.
  • Enhanced warning messages when creating the maintenance plan if the Shrink Database option is enabled.
  • Resolving database issue with transparent data encryption enabled and making it available even if certificate is dropped.
  • Optimized query outcomes when indexed Spatial Data Type column is referenced by DTA (Database Tuning Advisor).
  • Superior user experience with Sequence Functions (e.g Row_Numbers()) in a Parallel execution plan.
http://www.microsoft.com/download/en/details.aspx?id=27594

Thursday, November 17, 2011

Unable restart SQL Server services

Error: 9954, Severity: 16, State: 1

Message
SQL Server failed to communicate with filter daemon launch service  (Windows error: The service did not start due to a logon failure.). Full-Text filter daemon process failed to start. Full-text search functionality will not be available.

Solution:
If you have recently changed SQL Server service account password , Please make sure to update the password and restart the services this apply to all SQL Server Services components below.

SQL Server
SQL Servr Agent
SQL server Integration Services
SQL Server Analysis Services
SQL Server Reporting Services
SQL Server Browser
SQL Full-text Filter Daemon Lanuncer

Friday, November 11, 2011

SQL Server Code Name Denali CTP3

SQL Server Code Name "Denali" CTP3 is available to download from Microsoft web site

https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/

Thursday, November 10, 2011

SSIS Log Analyzer

This video demonstrates how to use the SSIS Log Analyzer tool to analyze complex and verbose SSIS logs quickly and easily. You learn how to analyze logs manually by applying row and column filters or by using queries, view performance analysis of package tasks, and identify issues and possible solutions.

Web Link : http://technet.microsoft.com/en-gb/library/hh323822.aspx

SSIS Log Analyzer Tool available from codeplex site: http://ssisloganalyzer.codeplex.com/