SQL Reports Archives - SQL Authority with Pinal Dave

Who Dropped Your Table? – SQL in Sixty Seconds #112

August 28, 2020

SQL in Sixty Seconds, SQL Reports, SQL Scripts, SQL Server, SQL Server Security

Who Dropped My Table? – I was recently asked this question in Comprehensive Database Performance Health Check. Let us learn about it today.

SQL SERVER – User Statistics Report for Database – SSMS

June 16, 2020

Pinal Dave

SQL Tips and Tricks

SQL Reports, SQL Server Management Studio, SQL Server Security, SSMS

Once we isolate the user, it was easier for us to get the performance back to the original level. Learn about User Statistics Report for Database – SSMS.

SQL SERVER – Fix Error: Currently This Report Does Not Have Any Data to Show, Because Default Trace Does Not Contain Relevant Information

May 26, 2020

Pinal Dave

SQL Tips and Tricks

Schema, SQL Reports, SQL Scripts, SQL Server, SQL Server Configuration, SSMS

If there is a way to fix the error which they get when they try to open Schema Changes History. The error was related to Not Have Any Data to Show.

SQL SERVER – Finding User Who Dropped Database Table

November 23, 2018

Pinal Dave

SQL Tips and Tricks

Schema, SQL Reports, SQL Scripts, SQL Server, SQL Server Security

Though I mainly focus on SQL Server Performance Tuning as my primary consulting engagement, there are moments when I am asked questions from my regular clients which are not related to SQL Server Performance and they still expect me to answer. I think it is totally fair, no one wants to go to find a new consultant for some simple questions. Recently my customer wanted to know who dropped the database table from their primary database.

SQL SERVER – Reporting Services Not Starting After Maintenance Window

October 25, 2018

Pinal Dave

SQL

Reporting Services, SQL Error Messages, SQL Reports, SQL Server

This is the issue faced on my test server and I found something interesting. In this blog, we would learn about one of the reasons why SQL Server Reporting Services (SSRS) couldn’t start after regular maintenance.

SQL SERVER – Generating In-Memory OLTP Migration CheckList

September 5, 2018

Pinal Dave

SQL Tips and Tricks

In-Memory OLTP, SQL Migration, SQL Reports, SQL Server

During recent Comprehensive Database Performance Health Check, one of my customer asked if I can also help them to check their readiness of In-Memory OLTP Migration as well as the help them build a checklist which can help them with In-Memory OLTP Migration.

SQL SERVER – The Report Server Cannot Open a Connection to the Report Server Database. (rsReportServerDatabaseLogonFailed)

March 22, 2018

Pinal Dave

SQL

Reporting Services, SQL Connection, SQL Error Messages, SQL Reports, SQL Server

When my clients contact me for any issue, I always try to help them or redirect them to someone who can help them better than me. Once a client contacted me for an issue with SQL Server Reporting Services. As usual, I didn’t give up, but I investigated error message and applied a logical approach to fixing it. Let us see how to fix the error related to report server database.