OLAP cube / Analysis Services = error on transport layer

Problem:When connecting to an OLAP cube via Excel by using Windows authentication we receive this error: "An error was encountered in the transport layer"When connecting to Analysis Services via SQL Server Management Studio 2008 R2 by using Windows authentication we receive this error: "Cannot connect to Lake. A connection cannot be made. Ensure that the server is running."The thing is that a connection with a proxy user via an automated SQL Server job in which the cube is deployed and processed worked. Using the credentials of that user when trying to connect to Analysis S...

BinaryData column in SQL Server Profiler

I saved SQL Server profiler on a table for monitoring. There is a Binarydata column in it, how to access the data from BinaryData column in SQL Server Profiler using queries or etc.? Binary data column is rarely used by events in SQL Profiler. In documentation you can usualy find Binary value dependent on the event class captured in the trace.Nothing valuable.Here https://msdn.microsoft.com/en-us/library/ms191283.aspx, in Showplan All Event Class you can find Estimated cost of the Showplan text.In my opinion not valuable as well. If you dig more into documentation, you...

Cumulative sum (progressive total)

I have a cube with the dimension CreatedOn (Time type) and the measure IssueOpened. I need to get the cumulative sum for IssueOpened.For example:2009 IssueOpened=7 OpenedOnTheEndOfPeriod=72010 IssueOpened=12 OpenedOnTheEndOfPeriod=192011 IssueOpened=2 OpenedOnTheEndOfPeriod=21So, I have created the calculated member:sum([CreatedOn].[Y-Q-M].currentmember.level.members(0):[CreatedOn].[Y-Q-M].currentmember.prevmember, Measures.[IssueOpened])But it looks like it doesn't work as I want. Start of dimension:And it looks like a truth at the end of dimension:May be the err...

How do I profile a single SP with SQL Server Profiler?

I'm trying to evaluate the relative performance of using a WHERE... IN clause in my SP vs UNIONs.I've tried looking at the execution time and using SET STATISTICS TIME ON but everything just comes back as taking 0ms all the time.So I'm trying to use SQL Server Profiler. I selected the TSQL_SPs template but even before I run the SP the trace is filling up with garbage. How do I tell it to only capture relevant data for a specific SP? In Sql profiler, when you are creating a new trace, you can change the trace properties. Click on Events selection tab in trace properties a...

How to port WCF/SQL app to (SQL) Azure cloud?

I've got a local app, consisting of a windows service providing the middle/business tier for a SQL Server database (c#, .net 4, SQL Server 2008 R2)Now I'd like to port this app to Windows Azure Cloud (both service and SQL database).Is somewhere a document stating the differences between a local WCF service and a windows Azure Service, same for local SQL Server and SQL Azure?Any pointers how to start porting from WCF to Azure? For SQL Server vs SQL Azure, look at this MSDN page. You'll see a whitepaper link documenting the fundamental differences between SQL Server and SQ...

Implementing a sales tax strategy for Invoices

Here in South Africa we have Value Added Tax (VAT) which is pretty much identical to Sales Tax and is currently fixed at 14%, but could change at any time.I need to include VAT on invoices (which are immutable) consisting of several Invoice Lines. Each line references a Product with a Boolean property, IsTaxable, and almost all products are taxable.I don't want to store pre-tax prices in the database, because that just makes it hard to read the real price that the customer is going to pay and everywhere I display those prices, I then have to remember to add tax. And when th...

SQL Server: getting deadlock victim error on a stored procedure without transaction

I have a table called Storage with this design:CREATE TABLE [dbo].[Storage]( [Id] [INT] IDENTITY(1,1) NOT NULL, [GameId] [INT] NOT NULL, [UserId] [INT] NOT NULL, [Status] [TINYINT] NOT NULL, [CreatedAt] [DATETIME] NOT NULL, [UpdatedAt] [DATETIME] NULL, [Data] [NVARCHAR](MAX) NOT NULL, CONSTRAINT [PK_Storage] PRIMARY KEY CLUSTERED ([Id] ASC)) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]and I get a "deadlock victim error" in stored procedure MMO_Storage_Set:CREATE PROCEDURE [dbo].[MMO_Storage_Set] @Data NVARCHAR(MAX), @GameKey INT, @UserId INT...

I created Analysis services databases by xmla scripts. But I can't show the values in table. e.g. run DAX 'evaluate table_name',there presents nothing

I want to create many Analysis Services Databases, but don't want to create Analysis Services Tabular Projects manually. So I run some xmla scripts. The databases are constructed After running, but I can't show or use the values in the table. when I run the DAX script 'evaluate table_name', there present nothing.the example xmla scripts:{"create": { "database": { "name": "SQA_200_12", "compatibilityLevel": 1200, "model": { "culture": "en-US", "dataSources": [ { "name": "SqlServer localhost SQATables", "connectio...

How to enable Full-text Indexing in SQL Server 2005 Express?

I am trying to enable Full-text indexing in SQL Server 2005 Express. I am running this on my laptop with Vista Ultimate.I understand that the standard version of SQL Server Express does not have full-text indexing. I have already downloaded and installed "Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2" (download).I have also ensured that both the "SQL Server (instance)" and "SQL Server FullText Search (instance)" services are running on the same account which is "Network Service".I have also selected the option to "Use full-text indexing" in...

Connect my Azure Web App to On-Premises SQL Server

I have a new web app in Azure that im trying to connect to my on-premises SQL server and following the instructions on this link.I have opened up our firewall and configured an IP address to route it through port 1433.I have setup, in Azure a Biz Talk hybrid connection (i have set the host name to the IP address and said port) and the Connection manager has been installed locally.I have set the following connection string in web.config<add name="MyContext" providerName="System.Data.SqlClient" connectionString="Data Source=<IPADDRESS>\<SQLINSTANCE>,1433;Initi...

How can I profile SQL-Server from a Linux Desktop ?

We are developing a .NET Core application on Linux. We use JetBrains Rider. I wanna to profile SQL-Server (remote or local) from my Linux dev machine. How can I do that (from Linux) ? You can download SQL-operations studio to manage SQL server on Linux:However, a profiler is not included (at least not yet - AFAIK). But I had the same problem earlier on with no profiler being present when having SQL-Server Express. So I forked ExpressProfiler from Codeplex and fixed some bugs. The resulting windows-forms application is here.However, you can only run that with mono. But b...

performance significantly reduced when inner join table and views

I have three views in my sql server:CREATE VIEW [dbo].[v_CompanyLabelCreate] AS SELECT c.Id AS Id, c.[Name] AS CompanyName, CASE WHEN r.ApprovedPatentCreativeApplication > 2 OR r.ApprovedCopyRightBookApplication + r.ApprovedCopyRightSoftwareApplication > 4 OR NumberInProduction + NumberNotInProduction > 10 THEN N'创造型' ELSE NULL END AS Label FROM Company c INNER JOIN ResearchInfo r ON c.Id = r.CompanyID WHERE c.Submitted = 1CREATE VIEW [dbo].[v_CompanyLabelHighPotential] AS SELECT c.Id AS Id, c.[Name] AS CompanyName, CASE WHEN si1.Income >= 100...

Creating a slicer using DAX in PowerView

I am working to make a dashboard in MS PowerView but having some trouble creating "slicers" for my dashboard. A slicer is basically a filter for the whole dashboard which filters out the whole display based on what is selected. For example, I am working with a survey so if we click on person type 1 under the "person" slicer, only responses from person type 1 will show.I am trying to make a slicer based on statistical measure type. Basically, I want a slicer with 3 different statistical measures: average, median, and mode. So when "average" is selected only those graphs usin...

How to replicate MIN and MAX in SQL

I have an excel formula that I need to recreate in SQL:=MIN(150,0.75*MAX(100-0-0/0.9,0))It can be done with nested case statements, but I am using a program to generate SQL which currently does not support this:selectcase when 150 < case when 0.75*100-0-0/0.9 < 0 THEN 0 ELSE 0.75*100-0-0/0.9 ENDTHEN 150ELSE 0.75*100-0-0/0.9ENDIs there another way of doing this without creating a stored procedure?Please note: I cannot use any new functionality from SQL Server 2012 or onwards. MIN and MAX in SQL Server don't work with a delimited list; they get to mi...

Unable to read trace definition file Microsoft Analysis Services TraceDefinition 12.0.5553 when running SQL Server profiler

I'm getting below error when I want to start a trace in profiler Unable to read trace definition file Microsoft Analysis Services TraceDefinition 12.0.5553.xml. Click OK to retrieve it from server. Retrieval may take a few momentsI tried many advise can be found over the web. no luck so far.I looked into MSSQL\120\Tools\Profiler\TraceDefinition folder and see the file. there are bunch of the same xml with different version there. So I delete the 5553 file and the ran profiler. I was able to start a trace and the next time I opened profiler, I got the same error.I looked in...

SQL analisys server profiler Server side too many records

I managed to create a server side trace on my analysis server which runs in background.Somehow it has too many records for each entry. On the print screen you can see about 30 records they all refer to the same entry, it should have been only two, two for entry (Session initialize and Audit login) and one for exit (audit Logout). Why are there so many and how to filter them?print screen from the profilerThat's the code i used to create the server side profiler<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Create xmlns="http://schemas....

Page 1 of 140  |  Show More Pages:  Top Prev Next Last