SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
1 answer
How can I use a AzureAD account as administrator for SQL Server Master Data Services
I have tried setting up master data services on my Windows 10 laptop with a SQL Server 2019 Developer edition. On the step of creating the database, I tried using my AzureAD account, as this is the user I use to login to WIndows, but the installer…
asked 2020-08-25T08:44:19.937+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(259.20000000000005, 37%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
Guido de Vries
1
Reputation point
commented 2020-09-01T00:46:59.367+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
One of the answers was accepted by the question author.
Question about obtaining MCSE: Data Management and Analytics
Dear MS, I have a question about obtaining the MCSE: Data Management and Analytics certification. Currently I am in possession of both a MCSA: SQL Server 2012/2014 and a MCSA: BI Reporting certification. However, the documentation on how to…
asked 2020-08-31T15:13:38.393+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(70.4, 84%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mans Scholten
21
Reputation points
commented 2020-08-31T15:48:42.52+00:00
Dave Patrick
426.3K
Reputation points MVP
4 answers
Connection string mvc app
I created a Web Application using mvc.app and connection to SQL Server. Application authenticates user via ADFS. How should I form my connection string, so the application will work with the SQL permission granted to the user? i.e. I have a user named…
asked 2020-08-27T22:33:36.227+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(179.20000000000002, 13%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET0%3C/text%3E%3C/svg%3E)
TomaszW-0873
131
Reputation points
answered 2020-08-31T15:03:53.363+00:00
TomaszW-0873
131
Reputation points
3 answers
SCOM 2019 - Reports Missing - Using SQL Server 2016 SSRS
Have reinstalled the reporting services role and using SQL Server 2016 SSRS. Get the Application Monitoring and Windows Server Reports folders but then nothing else after that. I know there is a fix for this on SQL Server 2017 SSRS but that option is…
asked 2020-08-27T10:26:50.7+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, 17%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Dujon Walsham
6
Reputation points
answered 2020-08-31T14:56:47.87+00:00
Dujon Walsham
6
Reputation points
1 answer
One of the answers was accepted by the question author.
pulling a calculated field from two separte fields
Hello, I have a table that is fed by a dataset. The dataset is a stored procedure that returns two lines associated with each employee. They are sorted by the indicator so line 1 is always followed by line 2. For example: …
![](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(249.60000000000002, 69%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
2 answers
Tirning off the usage of Buffer Pool Extension
We are using the SQL Server 2016 Standard with Buffer Pool Extension enabled on SSD drive. For external nightly maintenance we need to turn off an extensive writing on this SSD. So we have scheduled the turning off BPE. Checked it on the testing…
asked 2020-08-26T06:56:14.527+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, 28.999999999999996%, 11%)' 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)
Александр Розенбаум
11
Reputation points
commented 2020-08-31T12:02:27.757+00:00
Ronen Ariely
15,096
Reputation points
4 answers
DBCC memory : Current commited vs Page free vs Page allocated vs pages in uses
Current commited vs Page free vs Page allocated vs pages in uses~~~~ <<< What are their relationship
asked 2020-08-28T17:47:33.123+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, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,321
Reputation points
answered 2020-08-31T09:57:34.717+00:00
Shashank Singh
6,246
Reputation points
2 answers
One of the answers was accepted by the question author.
Display all employee.
Below is data and query attached21355-q.txt, i want to display all employee from #tbl_employee_Master ,but asd.sal_ID is null from #tbl_assign_Allowance_Deduction ,means that emp_ID exit or not in #tbl_assign_Allowance_Deduction table ,
asked 2020-08-30T08:44:21.753+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, 75%, 11%)' 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)
Analyst_SQL
3,551
Reputation points
commented 2020-08-31T09:40:48.077+00:00
Analyst_SQL
3,551
Reputation points
2 answers
One of the answers was accepted by the question author.
Avoiding CSV injection vulnerability in SSRS
I'm trying to find a way to avoid CSV injection when i export a report to CSV format is SSRS (Microsoft Reporting Services). The "manual way" to do it is to add an apostrophe (') to each cell. That will "convert" everything to text…
asked 2020-08-30T16:57:59.253+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, 73%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EID%3C/text%3E%3C/svg%3E)
Igal Drayerman
21
Reputation points
accepted 2020-08-31T09:33:00.363+00:00
Igal Drayerman
21
Reputation points
3 answers
Querying SQL Server 2012 Training Kit
Apologies in advance, this is very new to me. My boss wants me to start learning SQL queries to assist with reports at work, and the company uses SQL Server 2012. I've been given the Querying Microsoft SQL Server 2012 Training Kit book (textbook and…
asked 2020-08-27T12:18:13.17+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, 69%, 23%)' 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)
AmyKernow
1
Reputation point
commented 2020-08-31T09:03:40.997+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(236.8, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
EchoLiu-MSFT
14,576
Reputation points
4 answers
One of the answers was accepted by the question author.
Move on-prem SQL server VM to azure SQL VM
I am moving a clients servers to azure. We have been using ASR for past migration and plan to do the same. We dont have SA on SQL server licensing. The issue is when you move all the servers with ASR i do not see an option to make the migrated server…
asked 2020-08-26T21:22:26.727+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(60.8, 23%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Brice Milla
31
Reputation points
commented 2020-08-31T08:56:24.05+00:00
Ronen Ariely
15,096
Reputation points
2 answers
sys.dm_db_log_stats :log_truncate_holdup_reason : OLDEST_PAGE
for full mode database, I did some transaction , and then backup the transaction log . and then I will see sys.dm_db_log_stats :log_truncate_holdup_reason : OLDEST_PAGE there is some definition on the following but I am still a bit confused of this…
asked 2020-08-24T11:01:20.317+00:00
sakuraime
2,321
Reputation points
commented 2020-08-31T07:40:17.047+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, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
3 answers
Move data file to another drive in AG
What are the steps to move data file to another drive in AG with minimal downtime
asked 2020-08-29T11:59:20.153+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(128, 32%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chaitanya Kiran
101
Reputation points
answered 2020-08-31T07:37:55.803+00:00
m
4,271
Reputation points
2 answers
SQL AG restoring the tlog stuck
Hello I have 2 SQL servers, both are: Microsoft SQL Server 2014 (SP3-CU4) (KB4500181) - 12.0.6329.1 (X64) Jul 20 2019 21:42:29 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor) …
asked 2020-08-29T21:23:32.013+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(291.2, 48%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Steven Balderrama
21
Reputation points
answered 2020-08-31T07:35:28.91+00:00
Shashank Singh
6,246
Reputation points
2 answers
Reporting URL not working
All, Reporting URL is not working. How to troubleshoot the issue. However http://localhost/Reports is working, and 'http://Servername/Reports' is not working. Please assist to troubleshoot the issue.
asked 2020-08-24T12:49:20.033+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(92.8, 17%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vinay Kumar Gandla
1
Reputation point
commented 2020-08-31T06:21:20.943+00:00
ZoeHui-MSFT
34,351
Reputation points
1 answer
SSRS report when run manually in Reporting Services never finishes. Same report when run via a report subscription runs in less than a minute.
I created a report subscription for a SSRS report and it runs and is delivered within one minute. The same report when run manually in Reporting Services never finishes. The report simply calls a stored procedure which selects from a SQL view. …
asked 2020-08-29T14:23:28.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(147.20000000000002, 82%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tom Stone
521
Reputation points
answered 2020-08-31T06:19:21.87+00:00
ZoeHui-MSFT
34,351
Reputation points
1 answer
SSRS report in Visual Studio takes 2 minutes to run, the deployed report when run from Reporting Services takes forever. Why?
I have a report that runs in 2 minutes in Visual Studio connected to the production database (16k rows, 50 columns), but it takes more than 16 minutes when run by Reporting Services in production after deployment (I have to cancel each time). Both…
asked 2020-08-27T17:11:38.327+00:00
Tom Stone
521
Reputation points
commented 2020-08-31T05:48:11.037+00:00
ZoeHui-MSFT
34,351
Reputation points
2 answers
How to decide SQL server 2017 License ? What is user means ? If I use only sa user from application user access then shall I need to purchase that SQL user license ?
How to decide SQL server 2017 License ? What is user means ? If I use only sa user from application user access then shall I need to purchase that SQL user license ?
asked 2020-08-29T13:03:57.127+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(144, 5%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Goutam Kumar Das
1
Reputation point
answered 2020-08-31T05:45:22.817+00:00
m
4,271
Reputation points
3 answers
How to upgrade SQL Server 2012 to SQL Server 2017, shall I need to purchase 2017 License.
How to upgrade SQL Server 2012 to SQL Server 2017, shall I need to purchase 2017 License.
asked 2020-08-29T13:01:15.377+00:00
Goutam Kumar Das
1
Reputation point
answered 2020-08-31T05:18:28.68+00:00
m
4,271
Reputation points
1 answer
How to show #ERROR as Zero or as Nothing in matrix cell when groups and calculated field are based on switch-function in SSRS?
Imagine simple BI task: We have two grouping columns and one calculated field. like select group1, group2, sum(sales) Sum_of_sales from dbo.table1 group by group1, group2 When for some combination of grouping columns there's no ROW in dataset -…
asked 2020-08-28T17:31:47.12+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(236.8, 13%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPI%3C/text%3E%3C/svg%3E)
Petr Ilin
1
Reputation point
answered 2020-08-31T04:10:49.113+00:00
ZoeHui-MSFT
34,351
Reputation points