SQL DBA Support by T. Amit Vaid S. - Knowledge Centre for DBAs

Pages

  • Home
  • SQL Performance
  • About Us
  • TempDB
  • © Copyright
  • Memory
  • QUERIES BANQ
  • Missing Notification
  • Contact Me

Wednesday, May 31, 2023

MS-SQL Server - Configuration & Junction Table

Configuration & Junction Table


SQL Server Configuration Manager
https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-ver16

Junction Table
https://learn.microsoft.com/en-us/sql/ssms/visual-db-tools/map-many-to-many-relationships-visual-database-tools?view=sql-server-ver16

Creating a join on 2 SQL Tables in the gallery
https://powerusers.microsoft.com/t5/Building-Power-Apps/Creating-a-join-on-2-SQL-Tables-in-the-gallery/td-p/29188

Rich Text Format (RTF) Data Type
If you want to store it as a rtf document type, then varbinary(max)

View or change the compatibility level of a database

https://learn.microsoft.com/en-us/sql/relational-databases/databases/view-or-change-the-compatibility-level-of-a-database?view=sql-server-ver16

Drag and Drop not working in Report builder

https://learn.microsoft.com/en-us/answers/questions/541956/drag-and-drop-not-working-in-report-builder

Educational SQL Resources

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

Any query will be considered.


T. Amit Vaid S.

Posted by Anonymous at 11:45 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Top Labels / Tags

  • DBA Support
  • SQL Support

My Wish

  • Wishlist

Favorite Blogs & Sites

  • SQL DBA

DBA Projects

  • BHP Billiton
  • Driscolls
  • GE Money
  • NBC Universal
  • Santander
  • Sinclair Knight Merz
  • State Street
  • Telstra

SQL DBA Support - Knowledge Centre for DBAs

Loading...

Contact Form

Name

Email *

Message *

Featured Post

MS-SQL Server - SANSQL And AD

Search This Blog

Popular Posts

  • MS-SQL Server - मोर यानि ज्यादा (Part III)
  • MS-SQL Server - मोर यानि ज्यादा (Part II)
  • MS-SQL Server - मोर यानि ज्यादा
  • MS-SQL Server - Visiting Error Logs
  • MS-SQL Server - MIG On Idea
  • MS-SQL Server - Modifying Scheduled Jobs
  • MS-SQL Server - Divides one number by another, Physical Joins, SQLSORT_NORMMUTEX and Cycle error log
  • MS-SQL Server - भूतल / Baseline
  • MS-SQL Server - UCS_TRANSPORT_STREAM_CHANGE & Key Problem of GUID N Network
  • MS-SQL Server - General Discussion

About Author

This blog is a journey of SQL Server Professional.


I usually work as a DBA and have been working for performance tuning and high availability features. You can find some of the articles from my own personal real time experience.

Regards,
T. Amit श्याम वैद S.
Average Study 5th Class from Govt. School, New Delhi
(not Pandit by Profession/Religion)
NickName Goldy
Home Page

Eg. Calculation of DB Size If 55000 KB = 53.710 MB then If 6000 MB = 5.859 GB then

Written more than 50 DBA Scripts.

Followers

Blog Archive

  • ►  2025 (32)
    • ►  June (7)
    • ►  May (3)
    • ►  April (3)
    • ►  March (5)
    • ►  February (2)
    • ►  January (12)
  • ►  2024 (40)
    • ►  December (6)
    • ►  November (2)
    • ►  October (3)
    • ►  September (6)
    • ►  August (4)
    • ►  July (4)
    • ►  June (5)
    • ►  May (4)
    • ►  April (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (1)
  • ▼  2023 (315)
    • ►  November (3)
    • ►  October (12)
    • ►  September (9)
    • ►  August (1)
    • ►  July (9)
    • ►  June (30)
    • ▼  May (70)
      • MS-SQL Server - Configuration & Junction Table
      • MS-SQL Server - Virtual Machine Stuck
      • MS-SQL Server - Uniqueidentifier
      • MS-SQL Server - Duplicate, NC Index & A Quality of...
      • MS-SQL Server - विचार
      • MS-SQL Server - Hang, Threads, Fix 2705 & WaitTypes
      • MS-SQL Server - The Attraction of I (आई)
      • MS-SQL Server - Identity, Keys & Constraints, Sche...
      • MS-SQL Server - अंतर
      • MS-SQL Server - अनदेखा
      • MS-SQL Server - अनुसरण
      • MS-SQL Server - Technicality of Zero if Null
      • MS-SQL Server - विचार का जिक्र
      • MS-SQL Server - Block एक क्षण
      • MS-SQL Server - Certification Courses, LogShipping...
      • MS-SQL Server - विचार
      • MS-SQL Server - Business RFC, Waittypes, Buffer Ma...
      • MS-SQL Server - Smallmoney DataType & Understandin...
      • MS-SQL Server - Fix Error of Message 245 & Access ...
      • MS-SQL Server - Joint Mentor
      • MS-SQL Server - सच से शांति (Part II)
      • MS-SQL Server - विचार
      • MS-SQL Server - सच से शांति
      • MS-SQL Server - Database Mail
      • MS-SQL Server - अनदेखा
      • MS-SQL Server - Best Role for Key Stored Procedure...
      • MS-SQL Server - Topics for Today
      • MS-SQL Server - Smallint, Core Based Licensing & U...
      • MS-SQL Server - विचार
      • MS-SQL Server - Mohambu 'LOAD'
      • MS-SQL Server - Sync & ASYNC_NETWORK_IO Waittype
      • MS-SQL Server - विश्वास
      • MS-SQL Server - UTC Datetime & Network Configuration
      • MS-SQL Server - Most Hangs by RAM, Backup, Buffer ...
      • MS-SQL Server - प्रभाव
      • MS-SQL Server - Server Roles
      • MS-SQL Server - विचार
      • MS-SQL Server - Just Date & Ambiguous Column Error
      • MS-SQL Server - Tail Log Backup, NTLM & Joins
      • MS-SQL Server - SSIS एक तारा (Part 3)
      • MS-SQL Server - Timestamp in Full-Text Search
      • MS-SQL Server - Memory Usage
      • MS-SQL Server - विचार
      • MS-SQL Server - DMV & NORECOMPUTE
      • MS-SQL Server - Freelancing, Builds & Dynamic Data...
      • MS-SQL Server - Special Characters & Objects
      • MS-SQL Server - Humble Request
      • MS-SQL Server - More Records
      • MS-SQL Server - Input Perameters & Various Data Types
      • MS-SQL Server - विचार (A Punjabi)
      • MS-SQL Server - Concept of Receiving Alerts
      • MS-SQL Server - Target Recovery Time & Trim
      • MS-SQL Server - जैसा डेटाबेस वैसी एप्लीकेशन (एक मन...
      • MS-SQL Server - May be dream but a story to learn
      • MS-SQL Server - GAM, SGAM, PFS & Hung Process by B...
      • MS-SQL Server - विचार
      • MS-SQL Server - Partitioning & Much of Gulal (By W...
      • MS-SQL Server - SSAS, SSIS & Business Intelligence
      • MS-SQL Server - विचार
      • MS-SQL Server - हिसाब ने दिया बड़ा जवाब
      • MS-SQL Server - Best and Some Key System Procedures
      • MS-SQL Server - विचार
      • MS-SQL Server - Virtual Machine, Switch Table & Pr...
      • MS-SQL Server - इक्यावन से शुरुवात
      • MS-SQL Server - SUM & AVG Functions
      • MS-SQL Server - Raiserror, Diagram & Type of Joins
      • MS-SQL Server - Mechanism of Database
      • MS-SQL Server - विचार
      • MS-SQL Server - Structure by Database Diagram
      • MS-SQL Server - AdventureWorks Sample
    • ►  April (102)
    • ►  March (55)
    • ►  February (7)
    • ►  January (17)
  • ►  2022 (47)
    • ►  December (41)
    • ►  November (6)
  • ►  2011 (1)
    • ►  June (1)

Labels/Tags

A Divine Technology (1) acid properties (1) aggregate (1) Aggregate functions (1) alter Index (1) Always Encrypted (1) Architect (1) architecture (2) Assessment Questions (1) Attribute (1) Backup (1) Bak (1) best practices (1) Best seller industry (1) BI Talk or BAAT (1) Business (1) Business in Standard Edition (1) collation settings (1) Communication (1) Compiler (1) configuration (1) Configuration Manager (1) CPU high (1) cumulative updates (1) Cycle Error Log (1) Database Role (1) Datatypes (1) DBA Support (11) Deadlocks (1) Delete (1) Dense Rank (1) Determination (1) Devotion (1) Dhaak (1) Dhab (1) Dhai (1) Dhurbi (1) diff (1) Distribution Database (1) DNS Server (1) drop table (1) duplicate records (1) eBook (1) Enable Filestream storage (1) Enable Trace (1) Exam for Tuning & Tracing (1) Failover Cluster (1) fatal errors (1) Filestream (1) flush cache (1) Ganga (1) Ghorak (1) Group by clause (1) Hang (1) Help (3) Hex (1) high availability (1) hostname (1) hotfixes (1) index reorganize (1) Index Update (1) isolation level (1) Isolation levels (1) Joins (2) jor jemry (1) Karta a worker (1) Lakshya (1) Language (1) latch (1) LCK_M_RIn_U (1) linked server (1) Lock Escalation (1) logshipping (1) Logspace (1) MAH of OS (1) Manclute (1) Materialized view (1) maxdop (1) May be Dream (20) mirroring (1) Msdb database (1) MTA Certification (1) Mushk (1) NEANJ (1) Neash-adro (1) Network Issues (1) numeric datatype (1) OLEDB (1) OLTP (1) Opposite (1) parameters (1) Partitioned tables (1) Patching and Upgrade (1) PCI compliance (1) Pearl (1) Peer to Peer Replication (1) performance (1) Pivot (1) Ponk (1) Powershell (1) Query JOANS (1) Race Conditions (1) Raid Level (1) Rank (1) Re-Claim Space (1) Reason DB (1) recommendations (1) Redundancy with Replication (1) remove column (1) Reorganize (1) Replication (1) Replication prerequisites (1) Restore Headeronly (1) Retry Attempts (1) Robocopy (1) Sample database (1) SANSQL (1) Scenario (1) SHLEIVA (1) Show Tables (1) Slab (1) Spatial (1) SQL Environment (1) SQL Profiler (1) SQL Server Agent (1) SQL Server FAQs (1) SQL Server hangs or hung (1) SQL server practical (1) SQL Support (4) SSIS (2) t-sql functions (1) table Hints (1) TABLOCKX (1) tail log backup (1) Tail-log backup (1) tech antons (1) Technical Reason for Indexing (1) timestamp autoupdate (1) Total vs Target Memory (1) Transactions (1) trn (1) Truncate table (1) Ujajwa (1) Unique index (1) Update Statistics (2) Victory for Sure (1) Vishwas (1) VM Hang (1) Voice Network Team (1) Wishlist (1) Workbench (1)

Contributors

  • Sheetal Vaid
  • अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog

Total Page views

Simple theme. Powered by Blogger.