max queue depth for transaction log and data file
max queue depth for transaction log should be 32. what about mdf ?? are there any msdn official doc for that ?
subreport spans multiple pages when saved to pdf
hi we run 2016 enterprise. i have a master report calling my subreport multiple times. i should start with the sub. when i run it stand alone and save to pdf, it spans multiple pages which dont want. the sub's report page size shows 8.5in, 11in…
SQL Server Mirroring - Principal Database is not configured for mirroring
Is there any way of figuring out what the real reason is for Mirroring to give up on the Alter Database dbPrincipal Set Partner = 'TCP://Domain + server : Port , etc. There are so many reason why you will get the same error: Principal Database is…
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…
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…
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…
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…
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: …
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…
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
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 ,
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…
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…
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…
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…
Move data file to another drive in AG
What are the steps to move data file to another drive in AG with minimal downtime
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) …
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.
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. …
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…