274 questions
1 answer
Best and most efficient way to convert a VARCHAR(10) to a Date for filtering
We have a "Blob" Table with a Date and a Data Type of VARCHAR(10). What is the best and most efficient way to convert that to a Date so that we can look back and filter based on the last 3-years? Thanks in advance for your review and am hopeful…
SQL Server | SQL Server Transact-SQL
asked 2026-03-09T16:08:28.7233333+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(310.4, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Bobby P
231
Reputation points
commented 2026-03-09T17:53:50.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(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
27,096
Reputation points
1 answer
One of the answers was accepted by the question author.
Blocked process report vs sp_who2 BlkBy
I've enabled the "blocked_process_report" extended event in SQL Server 2019 but I'm getting a lot more hits than I see from sp_who2 (or sp_WhoIsActive) in their associated "BlkBy" (or "blocking_session_id") columns. I'm…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
660 questions
asked 2026-03-08T10:43:48.53+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(44.800000000000004, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Peter Bishop
236
Reputation points
accepted 2026-03-09T14:02:42.7233333+00:00
Peter Bishop
236
Reputation points
1 answer
sql server 2022 wın 11 pro da kurulum sırasında sürekli aynı hata veriyor. ve kuramıyorum
kurumda yaşadığım probleminin sebebi nedir.? 2019, 2022, 2025 sqlserver kurulumlarıda aynı şekilde hata verdi.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
660 questions
asked 2026-03-05T23:46:06.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(28.799999999999997, 56.00000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Destek Bilgisayar
0
Reputation points
commented 2026-03-09T13:00:48.7666667+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(137.6, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Anjan Kumar Chippa (Quadrant Resource LLC)
0
Reputation points Microsoft External Staff
Moderator
1 answer
sql server 2019 kurulum problemi
Hatalı kurulan SQL Server 2019 bileşenleri nasıl tamamen kaldırılır? temizleme işini otomatik yapacak bir uygulamanız yok mu ?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
660 questions
asked 2026-03-05T20:51:37.03+00:00
Destek Bilgisayar
0
Reputation points
commented 2026-03-09T12:59:42.4166667+00:00
Anjan Kumar Chippa (Quadrant Resource LLC)
0
Reputation points Microsoft External Staff
Moderator
2 answers
ACE.OLEDB.12.0 provider is not registered on the local machine
Hello, We have a client that tried to import an excel using the import and export wizard and he recceived the following error: The operation could not be completed. Additional information: The 'Microsoft.ACE.OLEDB.12.0' provider is not…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
660 questions
asked 2026-03-04T07:35:23.9466667+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(108.80000000000001, 63%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Admin Team TGS
0
Reputation points
commented 2026-03-09T11:44:38.94+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(233.6, 6%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Nithin Krishna Madadi
0
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
Point in time restore after initial backup
Hello, I have a specific question to which i coulnd't really find an exact answer. I have a scenario in which let's say I have an initial full backup(no backups present before that) that for some reason is slow and takes let's say 5 hours, starting at…
SQL Server | SQL Server Transact-SQL
274 questions
asked 2026-03-06T12:46:29.77+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(12.8, 42%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Duygu Hasan
20
Reputation points
commented 2026-03-09T08:19:04.81+00:00
Duygu Hasan
20
Reputation points
2 answers
One of the answers was accepted by the question author.
Benefits and disadvantages of WITH (NOLOCK)
Benefits and disadvantages of WITH (NOLOCK). Also is there other commands that can serve different use cases.
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,715 questions
SQL Server | Other
14,698 questions
asked 2024-05-30T15:12:46.18+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(294.40000000000003, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jonathan Brotto
420
Reputation points
answered 2026-03-09T07:11:23.8066667+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(188.79999999999998, 27%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Muhammad Ayoub
0
Reputation points
1 answer
Get Data With Power BI - unable to get data from SQL Server
in taking course via learn.microsoft.com - get data with power bi, I receive (for 2 days now) msg - Unable to Connect. "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server…
SQL Server | Other
14,698 questions
asked 2026-02-28T15:53:48.6066667+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(256, 55.00000000000001%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK3%3C/text%3E%3C/svg%3E)
KF-3028
0
Reputation points
commented 2026-03-09T06:02:06.4533333+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,560
Reputation points Microsoft External Staff
Moderator
3 answers
Assessment for SSISDB and SSIS Catalogue
Hi all, I'm using tools Migrate SQL server to migration assessment at SSMS v22, but SSISDB database did not appear in Database selection something's wrong at my SSMS ? thanks for all reply regards, Urbel
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
604 questions
asked 2026-02-25T06:50:22.2766667+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(108.80000000000001, 96%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
Urbel
460
Reputation points
commented 2026-03-09T05:24:03.74+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
920
Reputation points Microsoft External Staff
Moderator
1 answer
Cannot install SQL Server 2025 Express with WinGet
Running the following script code: winget install --id Microsoft.SQLServer.2025.Express -s winget Echos the following message: Microsoft (R) SQL Server Installer Copyright (c) 2025 Microsoft. All rights reserved. Operation finished with result:…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
4 questions
asked 2026-02-26T08:21:03.1133333+00:00
PtJade Ceramic
0
Reputation points
commented 2026-03-09T05:17:48.9466667+00:00
Akhil Gajavelly
1,560
Reputation points Microsoft External Staff
Moderator
2 answers
Unable to connect to SQL Server for Learning Labs
It has happened in several labs (Get data in Power BI and Prepare data for analysis in Power BI). I've tried clearing cookies/cache but still just get error messages. DataSource.Error: Microsoft SQL: A network-related or instance-specific error occurred…
SQL Server | Other
14,698 questions
asked 2026-02-25T21:18:47.5066667+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(160, 78%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Ammo Parmar
0
Reputation points
answered 2026-03-09T05:09:13.6166667+00:00
Akhil Gajavelly
1,560
Reputation points Microsoft External Staff
Moderator
1 answer
cannot open or create sql agent alerts
When I try opening an existing alert in SSMS (SQL Agent - Alerts) or create a new alert, I receive the following error: The Show details button contains the following: =================================== Cannot show requested…
SQL Server | Other
14,698 questions
asked 2026-02-24T22:02:13.37+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(140.8, 88%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Charles Burschtin
0
Reputation points
commented 2026-03-09T05:02:23.1966667+00:00
Akhil Gajavelly
1,560
Reputation points Microsoft External Staff
Moderator
2 answers
How does one go about buying a SQL license?
I know this sounds like it should be simple, but it's not. The marketplace goes nowhere, call MS, they don't call back. I assume I need to find a licensed partner, but that is also no response. Can anybody point me to somebody that I can give money to…
SQL Server | Other
14,698 questions
asked 2026-02-24T15:24:35.8666667+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(96, 81%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jim
386
Reputation points
commented 2026-03-09T04:59:25.17+00:00
Akhil Gajavelly
1,560
Reputation points Microsoft External Staff
Moderator
1 answer
Migrating Large Size scale Database
Hi all, what is alternative method to migrating side by side large size Database thanks for all reply regards, Urbel
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
604 questions
asked 2026-02-24T02:50:57.9666667+00:00
Urbel
460
Reputation points
commented 2026-03-09T04:54:15.2933333+00:00
Akhil Gajavelly
1,560
Reputation points Microsoft External Staff
Moderator
2 answers
Microsoft Partner Information
Dear Team, There is a Procurement of SQL Server 2025 Licenses is under process in our Organization. My question is regrading the Ressler partner of Microsoft that How much time the following Organizations are Microsoft reseller Partners?. Pakistan…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
660 questions
asked 2026-02-23T09:48:54.5466667+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(105.60000000000001, 89%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Ahmed Ali - Assistant Director (IT)
1
Reputation point
commented 2026-03-09T04:33:03.4533333+00:00
Akhil Gajavelly
1,560
Reputation points Microsoft External Staff
Moderator
1 answer
Install Component Package on Visual Studio Installer 22
Hi expert, I need install SSMS 22 by offline with input this command vs_SSMS.exe --layout C:\SSMS_Layout --all.. but this command install ALL PACKAGES Component I only need component package of Management Studio 22 anyone know the Packages Component…
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
604 questions
asked 2026-02-23T06:09:43.0066667+00:00
Urbel
460
Reputation points
commented 2026-03-09T04:28:10.5066667+00:00
Akhil Gajavelly
1,560
Reputation points Microsoft External Staff
Moderator
2 answers
Where to find Standard Runtime SQL 2025 (version 17)
Where to find Standard Runtime SQL 2025 (version 17) that is used by Microsoft Dynamics GP?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
660 questions
asked 2026-02-22T22:20:02.2566667+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(32, 86%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Cindy Mikeworth
21
Reputation points
commented 2026-03-09T04:21:10.8+00:00
Akhil Gajavelly
1,560
Reputation points Microsoft External Staff
Moderator
3 answers
One of the answers was accepted by the question author.
SQL Server: What exactly is for fee and when I must to pay?
Previously, I have used only MySQL, PostgreSQL and SQLite but currently considering the Microsoft SQL Server for commercial usage. Not sure I can pay for that while my applications are small and does not give the revenue. Currently I am confused when I…
SQL Server | Other
14,698 questions
asked 2026-03-06T00:28:13.7166667+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(108.80000000000001, 77%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Takeshi Tokugawa
20
Reputation points
accepted 2026-03-09T00:45:26.6766667+00:00
Takeshi Tokugawa
20
Reputation points
2 answers
How deploy copilot using Vscode when running PowerBI backend?
I'm hosting a 2022 SQL Server Adminstrator on an Office instance of m365, but the boot screen doesn't allow for adminstrator privelege access for the powerbi backend. How to fix?
SQL Server | Other
14,698 questions
asked 2026-02-25T22:25:54.2266667+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(153.6, 26%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Garrett Settles
0
Reputation points
edited an answer 2026-03-08T09:45:17.1633333+00:00
kagiyama yutaka
1,165
Reputation points
2 answers
Sql server 2025 standard version features
Which features we need to select while installing the sql standard 2025 for production environment,For 2019 and 2022 we select all client tools but here we have no clarity, so please suggest as soon as possible
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
660 questions
asked 2026-03-07T14:43:44.19+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(201.6, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anandhswarupp
205
Reputation points
commented 2026-03-08T02:07:10.99+00:00
Anandhswarupp
205
Reputation points