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
12,893 reads
Ben Kubicek
- Interests: Jesus, playing guitar singing, most sports, running, biking, triathlons
2020-10-29
3,775 reads
Who is the best person for the job?
Sometimes it is hard to admit that you are not the best person for the job that is presented to you.
2020-04-09
138 reads
A tale of updating a legacy system bug
Even simple changes that don't look like they will affect anything often do.
2020-01-07
2,469 reads
How Do You Act When You Need to Learn New Technology?
Today we have a guest editorial from Ben Kubicek as Steve is away from the office. It is hard to be humble, but it is needs to learn something new.
2019-11-27 (first published: 2016-11-07)
507 reads
A Self-Serve System to Refresh Databases (Part 3)
This is the wrap up of this series on a system for developers to restore production database in test. It gets pretty detailed on the web setup side.
2019-05-16
3,016 reads
A Self-Serve System that Allows Developers to Refresh Databases (Part 2)
Dive deep into the details of part 2 in this series of creating a solution so Developers can start a restore of Production to test.
2019-05-09
4,379 reads
A Self-Serve System that Allows Developers to Refresh Databases (Part 1)
Empower developers to refresh their own test systems with production backups.
2019-05-02
6,829 reads
Who should have Sysadmin rights?
The point of this article is that only service accounts and/or specific network sql admin accounts should have sysadmin rights.
2019-03-11
1,625 reads
Two Things I Would Change in SSISDB Setup
I suggest these two changes to the SSISDB setup to prevent issues down the road.
2019-01-11 (first published: 2016-03-29)
5,432 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Using CHOOSE()
Comments posted to this topic are about the item Using CHOOSE()
Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary)
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
The DBA is Dead! Long Live the !
Comments posted to this topic are about the item The DBA is Dead! Long...
Question of the Day
Using CHOOSE()
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers