Migrating SQL Server Reporting Services
Learn how to migrate SSRS by following a walk through of migrating SSRS 2014 to SSRS 2016.
2020-06-12 (first published: 2019-03-18)
21,760 reads
SSRS
SSRS Reporting Basics: When is SSRS the Right Tool?
SSRS has undergone a number of changes over the past few versions. It remains a very popular reporting tool in companies large and small. In this article, Eugene Meidinger recounts the history of SSRS and explains when it’s the best tool to use. This is the first article of a series on SSRS.
2019-01-10
4,148 reads
Linear barcodes in SSRS using the Barcode Image Generation Library
The open source Barcode Image Generation Library enables insertion of twenty-seven different types of linear barcode symbols into SSRS reports without the use of barcode fonts.
2018-11-12
8,958 reads
RE: Error when using the IN Keyword on 100.000 elements
It's been a laborious and painstaking exercise but I spent all morning creating and testing a dummy table with 3 combinations of 2 columns - clustered and unique nonclustered; clustered and nonclustered & clustered only: In the first 2 instances (clustered and nonclustered (with unique constraint) AND clustered and nonclustered), "selecting *" gave me resultset […]
2005-05-12
RE: SQL Server Analysis Service
Here are some links:http://www.mosha.com/msolap/http://www.sqlserveranalysisservices.com/http://www.databasejournal.com/features/mssql/article.php/1429671http://www.databasejournal.com/features/mssql/article.php/3080511
2005-05-11
Sum and Group by
Hello,I am not sure where I can find anything about grouping by number. To be more specific :Table: 2 columnsNumber of the week Amount 1 502 253 474 155 56 877 268 1059 6710 18 Now I need to get SUM() for every 3 weeks or 6 weeks or any number I need. Can not find how to […]
2005-05-05
RE: The CLR in SQL Server 2005
Your arguement is certainly valid, but there are some very good reasons to abstract your middle tier from your database. First one that jumps out is how poorly TSQL organizes logic. Since TSQL isn't an object based language, encapsulation and reuse make building a good business layer difficult. This does change with CLR in the […]
2005-05-02
Blogs
Types of data consulting engagements and what you can expect from them
There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...
Daily Coping 6 Dec 2022
By Steve Jones
Today’s coping tip is to find a new way to tell someone you appreciate...
What’s next: Job search burnout
I was given 4.5 months notice this past June and was fortunate to find...
Forums
Stairways to ScriptDOM Level 4 – Finding Nuanced Patterns
Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...
The Availability Group Secondary Connection
Comments posted to this topic are about the item The Availability Group Secondary Connection
SSRS Expression Error
I am getting the following error when I try to use the Expression below....
Ask SSC