SSRS export to Excel converts DateTime Column to Text Column
Recently we observed a weird issue with SSRS export to Excel. One of the datetime column in the report was...
2013-07-02
1,735 reads
Mirrored Database as SSRS Data Source
Recently one of our report started to fail with error like Unable to Connect to Database error. Then only we...
2012-11-13
1,092 reads
SSRS: FORMAT option for milliseconds
Some of our reports have hyperlink enabled on few metrics which points to an internal website. Recently there was a...
2012-05-21
2,016 reads
SQL SERVER Replication – Troubleshooting Steps for Beginners
Few days back there was a replication issue in one of the QA servers. Since the DBA was out of...
2012-04-03 (first published: 2012-03-26)
5,409 reads
Converting SQL SERVER DateTime? Test it thoroughly….
Today one of my user complained that a report was missing one particular ticket from the output. The report in...
2012-03-08 (first published: 2012-02-28)
4,279 reads
Passing BIGINT data to SSRS Sub Report
Few days back one of my team mate complained to me that one particular sub report is failing randomly with
Error:...
2012-02-27
1,444 reads
SSRS 2008 Error – The report definition is not valid
Recently I downloaded a file from one of our production server, did some changes and reviewed it in BIDS and...
2012-02-27
4,702 reads
Dundas Dashboard – My observations
Dundas Data Visualization Inc, is well-known to SSRS developers. Microsoft had earlier acquired their SSRS controls (Charts, Gauges & Map) and integrated...
2012-02-04
1,544 reads
SQL SERVER connectivity error: SQL Server does not exist or access denied
Recently I was troubleshooting a connectivity issue in a development environment from an application. The application was using the connection...
2012-01-16
50,120 reads
Review of my blog posts in 2011
The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog.
Here’s an excerpt:
The concert hall at the Syndey...
2012-01-02
731 reads
Blogs
Prepping for Certification, Part 4 of 4
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
Flyway Tips: Automation Assistance in Flyway Desktop
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Forums
what are the downsides of TDE not running vs running?
hi for the 2 years i've been here I believe we've had "encryption" turned...
Help! MEMORY_ALLOCATION_EXT wait stalls
Hi I have an overnight process that moves allot of claims records Been working...
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers