Power BI Semantic Model Supports Many-to-Many Relationships
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
436 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
436 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
488 reads
Below is the script to find the fragmentation of the indexes created on a database.
SELECT OBJECT_NAME(OBJECT_ID), index_id,index_type_desc,index_level,
avg_fragmentation_in_percent,avg_page_space_used_in_percent,page_count
FROM sys.dm_db_index_physical_stats (DB_ID( N'Database name')...
2015-01-07 (first published: 2015-01-04)
7,254 reads
For years now we have dropped using Cat6 at home for Wifi,
since the Cat5e cables in the house we moved...
2015-01-04
1,220 reads
Below is the query to find out all the Queries and their details like SSID etc. running on the SQL...
2015-01-04
1,610 reads
Wishing you a very happy new year to you. May this year bring success & happiness in your life. Reference : Rohit Garg (http://mssqlfun.com/) You can find and follow...
2015-01-03
24 reads
Many times I was asked how to pass Microsoft certifications and how difficult it is. In my point of view,...
2015-01-03
1,030 reads
Wishing you a very happy new year to you.
May this year bring success & happiness in your life.
Reference : Rohit Garg (http://mssqlfun.com/)
You...
2015-01-03
618 reads
Continuation from the previous 45 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
At the last SQLPort event in December 2014, I have listened to...
2015-01-03
735 reads
While working on a project sometimes it happened that we need to shift the database from one server to another...
2015-01-02
494 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers