Skip to main content
11 votes
Accepted

SSRS error "something went wrong please try again later" in web portal

After some digging I found plenty of unconnected issues, but finally managed to solve them and wanted to share them all in one place so nobody else waste that much time if hits the same issue (or some ...
Bartosz X's user avatar
  • 503
7 votes

configure: error: SQLite3 library not found

I tried both, sudo apt-get install sqlite and building from source but problem persists. Then I tried the following command and it worked. May be it'll help someone else too. sudo apt-get install ...
MD Ruhul Amin's user avatar
7 votes
Accepted

Rotate table for year-over-year comparison

Yes, more concise ways of pivoting exist for your scenario. Option 1 For instance, you could use the PIVOT operator: SELECT * FROM ( SELECT road_id, insp_year, condition ...
Andriy M's user avatar
  • 23.1k
5 votes
Accepted

Reporting on a SQL DB Server with many write operations and few read operations

I know that when a write is happening to a SQL Server database table, a read to that table will have to wait. This isn't necessarily true. Proper indexing can help mitigate blocking waits by giving ...
Erik Darling's user avatar
  • 41.8k
5 votes

what is the best approach to send report by Email?

Yes sure.. you can use the subscription and delivery of Reporting Services to send a report. The available formats are: XML file with report data CSV (comma delimited) PDF MHTML (web archive) ...
Gabriele Franco's user avatar
4 votes

what is the best approach to send report by Email?

Reporting Services is the generally preferred way of doing this. You can create the reports completely inside the web designer if you have an aversion to using Visual Studio, but really Visual Studio ...
Jonathan Fite's user avatar
3 votes

How do I facilitate access to an Azure based SQL View for non-SQL users on Prem?

You can use Power BI service and Power BI Mobile Apps to share reports with others as explained here. Take a look here at the Publish to Web feature in Power BI. Here you can see how easy is to ...
Alberto Morillo's user avatar
3 votes
Accepted

Why does SSRS not update a report's description?

This is a "known" issue/feature according to Microsoft. Descriptions, parameter defaults, subscriptions, etc. all fall under report "meta data" and are maintained separately on ...
Steve Mangiameli's user avatar
3 votes
Accepted

"Cannot open database version 706. Upgrade the database to the latest version" - when trying to use availability database for read-only access

What do you suggest on above ? I need to keep primary SQL server replica as 2012 for now, and I need to make >async replica (SQL server 2016) to be available for read-only access There is nothing ...
Sean Gallardy's user avatar
3 votes
Accepted

Will an SSRS report on Azure SQL Database work?

You can fetch the data from Azure SQL database but it does not include SSRS so you would need a separate install (Azure VM ?) for that.
Stephen Morris - Mo64's user avatar
3 votes
Accepted

Can I regularly log ship from a source to a target, while running DML on the target?

Except for the changes caused by a stored procedure that I need to regularly run in Target, I want Source and Target to be identical and sync'd up roughly once a day. Is log shipping a suitable ...
J.D.'s user avatar
  • 38k
2 votes

Data into Star Schema's fact or dimension table?

This is a very interesting, but perhaps also a bit too general as a question. My general opinion is that if the cardinality of a dimension starts to approach that of the fact table, then there's no ...
nsousa's user avatar
  • 176
2 votes
Accepted

Reporting Services 2016 Multiple Email Accounts

You can only specify one mail account per SSRS installation.
Henrico Bekker's user avatar
2 votes

Background images in SSRS report resizing on export to PowerPoint

While this is not an answer but a work around that works for me. You need to have both a small image , and a larger version of the image imported into your report. Then use the following code to ...
PeterLLL's user avatar
2 votes

Why does SSRS not update a report's description?

After Steve's Answer I traced SQL Servers activity to find out more: First the initial deployment with "myInitialDescription": exec CreateObject @ItemID='CC754C47-4E02-42A1-9F71-9ABF84FBE30A',@Name=...
Magier's user avatar
  • 4,797
2 votes

How to copy Azure SQL database to on-premises SQL Server daily for reporting?

You can't copy direct from AzureSQL to on-prem SQL (even on-prem SQL running in an Azure VM) that way. To copy the database manually you need to export it via SSMS (or the relevant command line tool) ...
David Spillett's user avatar
2 votes

Login report of Sysadmin

You should write a logon trigger that will log only sysadmins. Here you can find more about logon triggers: Logon Triggers And here is a practical example of its use: SQL Server – Login Auditing ...
sepupic's user avatar
  • 11k
2 votes
Accepted

Login report of Sysadmin

I'd probably look into LOGON trigger and combined with checking login for sysadmin If logon user IS sysadmin, log it; else skip Obviuosly, monitor for performance impact sql server - How to create ...
Jerry Hung's user avatar
2 votes
Accepted

Can I make a short-lived readonly snapshot for reporting in Azure SQL DB?

Azure SQL Database doesn't support Database Snapshots, so there's no other option besides: Running the reporting queries in a SNAPSHOT transaction. or Creating a consistent copy of the database ...
David Browne - Microsoft's user avatar
2 votes

Automate SQL Server reports and send them by mail

I created a stored procedure that takes the data from any table and inserts it to CSV or Excel and send it to email or upload it to SharePoint, it works on SQL Server 2019, you can download it from ...
Poseidon's user avatar
  • 152
2 votes
Accepted

SSRS and Power BI report server on same server?

can we install powerbi and SSRS on windows server 2019 without having issues? Yes, though it's typically best practice to keep different servers decoupled. But you can actually integrate the two: ...
J.D.'s user avatar
  • 38k
1 vote
Accepted

SSRS, Limit Fixed number of Columns in Matrix within a Tablix - issue in sorting matrix data

I have managed to resolve this issue, thought i'll be helpful for others. The order needs to be on the main tablix and not on the inner group or Matrix.
Vinayak's user avatar
  • 21
1 vote

Finding the first parent (manager) of an employee that makes twice as much in a self-referencing table?

Using a recursive function and LATERAL join Next function returns last indirect manager given a employer id. CREATE OR REPLACE FUNCTION fnManager(pid int) RETURNS SETOF employees AS $BD$ DECLARE ...
McNets's user avatar
  • 23.8k
1 vote

Finding the first parent (manager) of an employee that makes twice as much in a self-referencing table?

This is a query you can try. Sure it can be simplified but is a good start I think. The key is to traverse all the managers chain recursively retaining salary information in order to compare later. ...
cachique's user avatar
  • 231
1 vote

Most efficient way to aggregate data to new table

This is what SSAS was made for, and there are a whole host of client tools that can connect to it including Excel. Elaborating SSAS - SQL Server analysis services is a free component of SQL server, ...
RegBes's user avatar
  • 111
1 vote

Any existing programs that track the origin of data in your database?

The answer to the "systems/practices" would be to include a column with all data that is imported that signifies its source. As for whether the issue was caused by your cleaning process, you simply ...
Tony Hinkle's user avatar
  • 7,964
1 vote

Looking for advice on how to integrate data from 100+ client DB's into a centralized reporting database

One possible architecture: Consider the reporting as a data warehouse based solution. Typically a data warehouse is a DB with a schema that represents the required subset of the source systems. ...
Paul Holmes's user avatar
1 vote

Looking for advice on how to integrate data from 100+ client DB's into a centralized reporting database

According to your above description below link will help you and i also working on same scenario.Multiple publisher with single subscriber. Add one more column like server_id with default value like ...
Gulrez Khan's user avatar
1 vote

Looking for advice on how to integrate data from 100+ client DB's into a centralized reporting database

Do we need to consider replicating each database individually and then perhaps use some sort of data virtualization technique to combine data from the various replicated sources? Yes. You can host ...
David Browne - Microsoft's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible