Create Sparklines in SSRS
When creating a SSRS report, you want to add lines that display trends. Sparklines that were introduced in SQL Server 2008 R2...
2011-11-14
3,908 reads
Samuel Vanga
#SSRS error – An item with the same key has already been added
Here is a simple yet annoying error I ran into while creating a dataset. Below is the query that I...
2011-11-10
2,197 reads
Column alias in order by and where
If you ever wonder why column alias can be used in order by and not in where clause, it’s the...
2011-11-08
6,854 reads
BI Pyramid (read categories of users in a BI solution)
Purpose of any business intelligence solution is to provide users information and enable them to make intelligent decisions that benefit their...
2011-11-01
808 reads
Hello…
Here i come… this is my first post at http://svangasql.wordpress.com. Here, you will see posts related to sql server, reporting...
2011-09-07
515 reads
Blogs
Why is shrinking IT budgets a good thing?
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Prepping for Certification, Part 3 of ?
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers