SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
291 questions
1 answer
12. METADATA
Tell me all i need to know about metadata in MSSQL databases
SQL Server | SQL Server Transact-SQL
asked 2026-05-16T01:05:55.4333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 67%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGV%3C/text%3E%3C/svg%3E)
Gurdeep Vaidya
0
Reputation points
commented 2026-05-16T02:02:02.1133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 52%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
Trevor Waldenburg
0
Reputation points
1 answer
11. DATABASE REPLICATION
Tell me all i need to know about replicating between databases
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
708 questions
asked 2026-05-16T01:05:08.7033333+00:00
Gurdeep Vaidya
0
Reputation points
commented 2026-05-16T02:01:23.3033333+00:00
Trevor Waldenburg
0
Reputation points
1 answer
10. DATABASE PARTITIONING
Tell me all i need to know about data partitioning in MSSQL
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
291 questions
asked 2026-05-16T01:03:50.1533333+00:00
Gurdeep Vaidya
0
Reputation points
commented 2026-05-16T01:59:42.59+00:00
Trevor Waldenburg
0
Reputation points
1 answer
9. DATABASE ENCRYPTION
Tell me all i need to know about encryption in mssql - keys, certificates, password etc...
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
708 questions
asked 2026-05-16T01:03:45.03+00:00
Gurdeep Vaidya
0
Reputation points
commented 2026-05-16T01:57:41.2666667+00:00
Trevor Waldenburg
0
Reputation points
1 answer
8. DATABASE AUDIT
Tell me all I need to know about audits in MSSQL and some example code
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
291 questions
asked 2026-05-16T01:02:05.9833333+00:00
Gurdeep Vaidya
0
Reputation points
commented 2026-05-16T01:57:07.3466667+00:00
Trevor Waldenburg
0
Reputation points
1 answer
6. DATABASE BACKUP
Tell me all I need to know about how to backup a database and types of backups
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
291 questions
asked 2026-05-16T00:59:57.9+00:00
Gurdeep Vaidya
0
Reputation points
commented 2026-05-16T01:53:03.9233333+00:00
Trevor Waldenburg
0
Reputation points
1 answer
5. LOG SHIPPING
Tell me all I need to know about database log shipping and some example code
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
291 questions
asked 2026-05-16T00:59:49.25+00:00
Gurdeep Vaidya
0
Reputation points
commented 2026-05-16T01:52:03.2733333+00:00
Trevor Waldenburg
0
Reputation points
1 answer
4. DATABASE MIRRORING
Tell me all i need to know about database mirroring in MSSQL and some example code
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
291 questions
asked 2026-05-16T00:58:31.7933333+00:00
Gurdeep Vaidya
0
Reputation points
commented 2026-05-16T01:49:46.38+00:00
Trevor Waldenburg
0
Reputation points
1 answer
3. SERVER AND DATABASE ROLES
Tell me everything i need to know about roles in MSSQL and some example code
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
291 questions
asked 2026-05-16T00:55:17.7666667+00:00
Gurdeep Vaidya
0
Reputation points
edited a comment 2026-05-16T01:42:57.2533333+00:00
Trevor Waldenburg
0
Reputation points
1 answer
2. USER MANAGEMENT AND SECURITY
Tell me all i need to know about MSSQL user managment and security and some example code
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
291 questions
asked 2026-05-16T00:53:30.67+00:00
Gurdeep Vaidya
0
Reputation points
edited a comment 2026-05-16T01:42:34.51+00:00
Trevor Waldenburg
0
Reputation points
1 answer
1. SSIS SERVICES
Tell me everything i need to know about SSIS services and some examples of projects
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,792 questions
asked 2026-05-16T00:50:45.94+00:00
Gurdeep Vaidya
0
Reputation points
edited a comment 2026-05-16T01:29:45.7066667+00:00
Trevor Waldenburg
0
Reputation points
4 answers
One of the answers was accepted by the question author.
SSRS Going Away?
I was informed by my IT department that the next upgrade they are making to upgrade our SQL server will not be supporting SSRS. I couldn't find any information to back-up their claim from Microsoft's website, other than that in SQL Server 2022,…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,159 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,738 questions
asked 2024-04-19T19:31:42.4666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 18%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Colin Sachs
85
Reputation points
commented 2026-05-15T18:32:59.75+00:00
Colin Sachs
85
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Server temporal tables - storing the user who deleted a row
Hi all; I am going to use temporal tables to keep a full audit trail of all changes to records in my key tables. One thing I have already implemented is each of those key record models implements: public interface IAuditTrail { /// <summary> …
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,858 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,738 questions
asked 2023-07-28T14:54:27.87+00:00
David Thielen
3,231
Reputation points
commented 2026-05-15T16:21:16.3933333+00:00
Erland Sommarskog
134K
Reputation points MVP
Volunteer Moderator
2 answers
Stored Procedure running longer hours
Hello, I am facing currently issue as stored procedure running very longer hours although my DB is not that big means around 20 GB. We are also running OLA's maintenance solution for Update Stats Daily and Index maintenance weekly basis. Stored procedure…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
291 questions
asked 2026-03-21T16:55:37.63+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pdsqsql
436
Reputation points
commented 2026-05-15T12:08:11.7433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 57.00000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECA%3C/text%3E%3C/svg%3E)
CHIPPA ANJAN KUMAR
0
Reputation points
1 answer
How To send mail with attachment from SQL MI
Hi Team, I am using msdb.dbo.sp_send_dbmail to send mail from sql mi. I need to send this mail with attachment. Since SQL MI does not support file attachment i am looking for the alternatives. I have one https service like https://test/getfile service…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,738 questions
asked 2024-05-17T08:52:23.3666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 93%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERY%3C/text%3E%3C/svg%3E)
Radhakrishnan, Yadu Krishnan (Allianz Technology)
0
Reputation points
commented 2026-05-15T11:00:49.47+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 33%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Simon Dooley
0
Reputation points
1 answer
SSRS 2017 to 2022 migration users report that favorited linked reports disappear from the Browse tab
ISSUE: After SSRS 2017 to 2022 migration users report that favorited linked reports disappear from the Browse tab after page refresh, even though the favorite is still saved in the Favorites tab. When users try to re add the favorite - they get error:…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,159 questions
asked 2026-05-15T10:15:41.8533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 69%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
RajeshKumar G
20
Reputation points
edited the question 2026-05-15T10:20:34.77+00:00
RajeshKumar G
20
Reputation points
0 answers
SQL Snapshot Replication Fails with BCP EOF / NULL Errors (Works in Transactional Replication)
Issue: We have Snapshot Replication on a production server that was working fine but recently started failing with the below error: Agent message code 20037. The process could not bulk copy into table "XXX". Message: End of file…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,738 questions
asked 2026-04-29T12:20:04.25+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 81%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Parag Nimbhore
5
Reputation points
commented 2026-05-14T15:34:54.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 30%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Matthew Williamson
0
Reputation points
1 answer
SQL Server 2022 Express installation error -2061893606 and service error 1067
Hello, I have a problem installing Microsoft SQL Server 2022 Express for EBP Gestion Commerciale ELITE 2025. Errors: Error -2061893606 SQL Server service (EBP) cannot start Error 1067 Shared Memory Provider, error: 40 What I already tried: …
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
708 questions
asked 2026-05-14T10:18:59.6533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 92%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
Youssef Maach
0
Reputation points
commented 2026-05-14T12:04:35.8933333+00:00
Erland Sommarskog
134K
Reputation points MVP
Volunteer Moderator
2 answers
how to fix physica; sector size when PC has m.2 drives
LargeSectorSizeCheck Checks whether any disk intended for SQL Server data has a physical sector size greater than 4 KB, which is currently unsupported. Warning One or more disks intended for SQL Server data have a physical sector size greater than 4 KB.…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
708 questions
asked 2026-05-12T11:49:12.42+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 41%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Peterson Gideon
0
Reputation points
commented 2026-05-14T09:53:58.8966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
1,820
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Express ODBC Connection
Hi, I am trying to connect UPS WorldShip to a SQL server to pull shipping data. It keeps telling me the connection has failed, this is a replacement server, the old server still connects. I turned off the firewall on the server for testing, I…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,738 questions
asked 2026-05-13T11:23:01.49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 39%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Brian Branco
0
Reputation points
commented 2026-05-14T09:05:41.2133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Garikapati
1,315
Reputation points Microsoft External Staff
Moderator