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,607 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,066 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
1,988 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,400 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,271 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,407 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,695 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,542 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,028 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
728 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Immediate Recap: Pounds 124, Clippers 117
No person would create the situation that a eye-catching video game of basketball was...
NFC Wild Card Breakdown: Cowboys vs. Packers
The Fresh Orleans Saints are shed the playoffs for the 3rd instantly time, which...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers