SSRS NoRows – Display a custom message when there is no data
In this short post, I’ll discuss NoRowsMessage property. When there is no data for a data region, the message you...
2012-03-06
1,846 reads
Samuel Vanga
Introducing SQL Roundup
Following in the foot steps of John Sansom (b|t), I’m going to post a roundup of links from other blogs every Friday. I’ll...
2012-03-02
978 reads
Write a Variable To a File Using SSIS
Problem
I’ve a SSIS package. When it fails execution, I want to write a custom message including the package name and error...
2012-02-29
5,899 reads
Creating Your First SSAS 2012 Tabular Project
No matter how simple it is, new things come with some confusion; at least until you get used to it....
2012-02-21
4,572 reads
Be careful with two digit years
I recently had a scary conversation with a user, which can be broken down to:
User: Why would the data have...
2012-02-14
757 reads
LAST_VALUE() Analytic Function–SQL Server 2012
Earlier, i discussed FIRST_VALUE() function. FIRST_VALUE() returns the first value from an ordered set of records. Similarly LAST_VALUE() returns the last...
2012-02-07
2,699 reads
Data Labels, Axis Interval, Rotate Label Text: SSRS Nugget
Charts present summary data in a visually appealing format. Following is a chart for sales over month:
Before
I frequently use a few...
2012-02-01 (first published: 2012-01-31)
7,926 reads
Read contents of a file to variable – SSIS
Sometimes you will find the need to import a file to a variable using SSIS. In this post, I’ll use Script...
2012-01-24
1,841 reads
#meme15 – Use. Twitter. Why?
Should an average Jane or Joe professional use twitter?
Yes.
Why?
Because, I’m using it.
Not enough reasons? <grumpy face> I knew you wouldn’t...
2012-01-16
669 reads
FIRST_VALUE() Analytic Function–SQL Server 2012
Given a customer table:
CREATE TABLE Customers
(CustId INT, OrderDate DATE, OrderAmount MONEY) ;
INSERT Customers VALUES
(1, ’2011-12-03', 12500)
, (1, ’2011-10-07', 15000)
, (1,...
2012-01-10
836 reads
Blogs
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers