How to resolve connection errors when loading data in SSAS Tabular project
This post actually applies to both multidimensional (cube) projects and Tabular projects which manage data source connectivity in a similar...
2015-01-09
581 reads
This post actually applies to both multidimensional (cube) projects and Tabular projects which manage data source connectivity in a similar...
2015-01-09
581 reads
Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular...
2015-01-05
474 reads
Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular...
2015-01-05
422 reads
This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer. What is it and why...
2014-12-20
682 reads
Can an SSRS report be designed to drill-through to an Excel workbook in-context (showing only the same filtered detail data)?...
2014-12-01
1,607 reads
Please join my associates and I for an all-day SQL Server Upgrade workshop on November 3rd
If you are planning an...
2014-10-21
745 reads
Requirement: Allow users to enter comments after they review results from a Power Pivot model and then show the comment...
2014-10-06
940 reads
Thank you to the Microsoft MVP Program for awarding me MVP for six years running! I love this program and...
2014-10-05
425 reads
The other day a secondary family member said “we’re still on Microsoft 2010”. Another said “My friend is using Windows...
2014-08-06
542 reads
I just received some bad news and found out that a friend passed away today. Reed Jacobson was one of...
2014-07-16
501 reads
Here’s how these tools can make Kubernetes security easier and help you avoid common...
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
We are in the process of upgrading to SQL Server 2022 and would like...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers