MS-SQL Server - SSAS, SSIS & Business Intelligence

SSAS, SSIS & Business Intelligence...

Transform your data with Analysis Services

- Build enterprise-ready analytic solutions to deliver meaningful insights using familiar data visualization tools, such as Power BI and Excel.

https://www.microsoft.com/en-in/sql-server/sql-business-intelligence

https://learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-ver16

Additionally,

Primary and Foreign Key Constraints

https://learn.microsoft.com/en-us/sql/relational-databases/tables/primary-and-foreign-key-constraints?view=sql-server-ver16

Lesson 2: Create and Apply a Naming Standards Policy with Create the Finance policy category

https://learn.microsoft.com/en-us/sql/relational-databases/policy-based-management/lesson-2-create-and-apply-a-naming-standards-policy?view=sql-server-ver16

RAM Configuration

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver16

Calculate total Man hours in SQL Server

https://learn.microsoft.com/en-us/answers/questions/977985/calculate-total-working-hours-in-sql-server

A log shipping configuration does not automatically fail over from the primary server to the secondary server.

https://learn.microsoft.com/en-us/sql/database-engine/log-shipping/about-log-shipping-sql-server?view=sql-server-ver16

WaitTypes
HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING
HADR_DBSTATECHANGE_SYNC
HADR_SEEDING_CANCELLATION

Internal Use

FABRIC_REPLICA_PUBLISHER_SUBSCRIBER_LIST
CHECK_TABLES_SINGLE_SCAN
FABRIC_WAIT_FOR_BUILD_REPLICA_EVENT_PROCESSING
GHOSTCLEANUPSYNCMGR

Basic of Sign Function

https://learn.microsoft.com/en-us/sql/t-sql/functions/sign-transact-sql?view=sql-server-ver16

SYS.Configurations for Buffer Pool

https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-server-configuration-transact-sql?source=recommendations&view=sql-server-ver16

Best of Performance MANGLA

- Major Wait Types.

- Auto Update Stats best practice.

- Native SQL Profiler.

- Global Memory Object status by DBCC.

- Logical & Physical Read for analysing performance.

https://learn.microsoft.com/en-us/sql/relational-databases/reading-pages?view=sql-server-ver16

- Analysing Index Fragmentation

Also, I believe, reading Habit is a good start of learning.

Best Regards

T. Amit Vaid S.