Hi everyone, I have come across following issue and wanted to share resolution with you.   When you install Sql Server 2008 on to windows 2008 cluster, sql server agent might fail with following error message and resource may not become online.  ...

  Just want to share a frequently asked question about SSAS perf counters. About key counters, here is list below:     Performance Object Counter Logical Disk All/All Process Private Bytes – msmdsrv.exe MSAS:Memory Memory Usage Kb MSAS...

  Here are steps to kill spid. 1-Open management Studio. 2-Connect AS instance 3-Choose XMLA command (shown below) 4-Execute following xmla command to find out spids <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">  ...

  Client applications communicate with Analysis Services using XML for Analysis (XMLA) over TCP/IP or HTTP. Analysis Services provides an XMLA listener component that handles all XMLA communications between Analysis Services and its clients. The...

  Question:You may want to know  why msmdsrv.log file is not easy readable and includes extra spaces between each characters in log file? Answer:This happen because the SSAS 2005 RTM version run first and create the Unicode file without the...

  One of my customer asked about best practice for Analysis Services about defragmentation. Answer is, yes we recommend defragmentation if you see fragmentation when using analysis services or after processing. There isn’t really anything special...

I have two ways of executing same statement. In following two scenarios, both returns different result. Basically my query runs against AdventureWorks DW. select {[Measures].[Reseller Sales Amount]} on columns, [Geography].[Country].[All Geographies]...

Problem description ==================== I just wanted to write about how reporting services manages connections with Analysis Services Data Source. Reporting Services, when connecting to Analysis Services as a data source initiates a separate connection...

I hope that you are doing well. I have found out that when using SSPI=Anonymous keyword in connection string to connect Analysis Services which is hosted on Vista or later versions like Windows 7, Windows 2008 etc.., you get following error message: Either...

In this post, you can find how to find out sql server error logs files. SQL SERVER 2005 Using SQL Server Configuration Manager: SQL Server Configuration Manager is a tool to manage the services associated with SQL Server. The features however are more...

PROBLEM DESCRIPTION =================== You may want to use DNS SRV record for your global name to resolve to an SQL server instance SERVERX\INSTANCE1. In internet I saw some sites are talking about it was possible to achieve this using a DNS SRV record...

When you use Visual Studio 2008 on vista ( or windows 2008) machine, when you try to run your project by using Visual Studio asp.net development server, you may experience "Page can not be displayed" or similar error messages and as a result of this,...

In this blog, I am going to give an example how to use linq to sql in your application Let's create a c# console application first: -File->New Project-> Visual C#->Console Application Next step should be creating Linq to Sql Classes -Right Click...

In your application, if you add too many filter options with "or" condition in your datatable, you may get StackOverflowException exception in your application. Queries: In the DataTable.Select method the below queries are executed. If you have a condition...

In scenario of OracleDatabase and entity framework with third party driver, In oracle database there might be some invalid date values (like 00-000-00) which cannot be accepted by Entity framework (system.datetime specifications doesn't meet with this...

Summary ============================= When you try to create a system dsn, you may not able to see all dsns listed in DSN list. This might be the fact that default value of ODBC DataSources is edited and set to a value different than "value not set" by...

Question:Way of connecting to xls files from 64 bit sql server. Answer: There is no direct way of doing this action however we have different ways of workaround this issue since we don’t have JET provider for 64 bit Here are more details and possible...

Here is a blog entry about retrieving xml data size from sql server by using ODBC and Sql Native client -Create following stored procedure in sql server 2005 -Create a system DSN with name testxml and use SQL Native Client as provider -Open Visual c+...

You will see some interesting content here soon... Cheers Kagan-