Welcome to Sql Developer's world
Could not initiate the EventLog Service for the key 'MSSQLSERVER', last error code is 5. Startup error: Unable to initialize error reporting system (reason: 5) in cluster
Hi everyone, I have come across following issue and wanted to share resolution with you. When...
Author: kagana Date: 10/25/2011
SSAS Performance Monitor Counters
Just want to share a frequently asked question about SSAS perf counters. About key counters,...
Author: kagana Date: 03/05/2011
How to cancel long running queries in Analysis Services 2005
Here are steps to kill spid. 1-Open management Studio. 2-Connect AS instance 3-Choose XMLA...
Author: kagana Date: 01/18/2011
How to Configure HTTP Access to SQL Server 2008 Analysis Services on IIS7
Client applications communicate with Analysis Services using XML for Analysis (XMLA) over...
Author: kagana Date: 01/18/2011
Analysis Services 2005 Log File (msmdsrv.log) Readability
Question:You may want to know why msmdsrv.log file is not easy readable and includes...
Author: kagana Date: 07/11/2010
Defragmentation Best Practices for Analysis Services
One of my customer asked about best practice for Analysis Services about defragmentation....
Author: kagana Date: 07/11/2010
Connection Pooling for Analysis Services Datasource in Reporting Services
Problem description ==================== I just wanted to write about how reporting services manages...
Author: kagana Date: 03/23/2010
As 2005/AS 2008 /Vista/win7/win2k8/SSPI=Anonymous behaves differently
I hope that you are doing well. I have found out that when using SSPI=Anonymous keyword in...
Author: kagana Date: 01/08/2010
How to: Verify path for SQL Server Error Log Files
In this post, you can find how to find out sql server error logs files. SQL SERVER 2005 Using SQL...
Author: kagana Date: 10/21/2009
DNS SRV Record Support for SQL Connectivity
PROBLEM DESCRIPTION =================== You may want to use DNS SRV record for your global name to...
Author: kagana Date: 07/09/2009
Learn LinqToSql Part 1
In this blog, I am going to give an example how to use linq to sql in your application Let's create...
Author: kagana Date: 12/23/2008
You may get System.StackOverflowException in your asp.net application if your filter condition has too many "or" in your DataTable.Select function
In your application, if you add too many filter options with "or" condition in your datatable, you...
Author: kagana Date: 12/10/2008
DateTime values supported by Oracle but not Entity Framework
In scenario of OracleDatabase and entity framework with third party driver, In oracle database there...
Author: kagana Date: 11/13/2008
DSNs are listed in registry key but some of them not showing in the ODBC Administrator
Summary=============================When you try to create a system dsn, you may not able to see all...
Author: kagana Date: 11/06/2008
MSJET 4.0 in 64 bit environment
Question:Way of connecting to xls files from 64 bit sql server. Answer: There is no direct way of...
Author: kagana Date: 10/22/2008
SqlGetData function returns SQL_NO_TOTAL (-4) for "StrLen_or_IndPtr " argument in SNAC ODBC
Here is a blog entry about retrieving xml data size from sql server by using ODBC and Sql Native...
Author: kagana Date: 08/26/2008
Coming Soon..
You will see some interesting content here soon...
Author: kagana Date: 01/12/2008
Coming soon..
You will see some interesting content here soon... Cheers Kagan-
Author: kagana Date: 01/12/2008