2024-04-29
441 reads
Reporting Services (SSRS)
SSRS 2022 Install, Setup and Configuration
This article includes all of the steps you need to take to install and configure SQL Server Reporting Services 2022.
2024-03-08
Building a Database Dashboard with SSRS
Learn how to create a dynamic database dashboard that tracks key metrics using SQL Server Reporting Services. From setting up to deploying your report.
2023-07-17
6,384 reads
2022-04-06
42,819 reads
SSRS IIF, Switch and Choose Functions for Dynamic and Appealing Reports
Learn how to use IIF, Switch and Choose logical functions in SSRS reports to make your reports more dynamic and more appealing to report users.
2021-10-13
Upgrade and Migrate SSRS Report Server and Retain Server Name
In this article we look at how to do a side by side install of SQL Server Reporting Services to minimize downtime for the migration.
2021-03-23
Using an RDL File Locally in .NET to Print Reports
The need to print doesn't seem to go away. Using RDL format report file you can print local reports in .net to PDF without having to connect to a Reporting Service Server.
2021-01-18
10,807 reads
SSRS Install, Setup and Configuration
In this article we cover all of the steps required to install, setup and configure SQL Server Reporting Services.
2020-12-31
Ensure that SSRS is Working while Using Availability Groups
This article explains how to get around one of the issues when the SSRS databases are part of an Availability Group.
2020-11-17
4,941 reads
Cross Tab Report in SSRS
This tip provides a step by step process to create a cross tabulation report in SQL Server Reporting Services.
2020-09-30
Blogs
Spark Connect Dotnet Variant Data Type
By Ed Elliott
All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...
A New Word: Opia
By Steve Jones
opia – n. the ambiguous intensity of eye contact The entry for this says...
Friday Flyway Tips: Searching a Migration
By Steve Jones
This was actually a cool tip I saw internally from one of the product...
Forums
Table Partitioning SQL server 2022
Hi All, I am currently testing the Table Partitioning to implement in SQL server...
STRING_AGG's behavior
Comments posted to this topic are about the item STRING_AGG's behavior
The Role of Databases in the Era of AI
Comments posted to this topic are about the item The Role of Databases in...
Question of the Day
STRING_AGG's behavior
Executing the following script (Sql Server 2022), you get the table t0 with 10 rows:
CREATE TABLE t0
( id INT PRIMARY KEY
, field1 VARCHAR(1000)
, field2 VARCHAR(MAX));
INSERT INTO t0
SELECT
gs.value
, REPLICATE ('X', 1000)
, REPLICATE ('Y', 1000)
FROM generate_series(1, 10, 1) gs;
GOWhat happens if you execute the following statements?
select STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;