SSRS – Embedding Refreshable Reports in Office Tools
Have you ever experienced this?
You have developed a set of Reporting Services report that your users love and they often...
2012-02-20 (first published: 2012-02-14)
2,695 reads
Devin Knight
Whitepaper – Extending Reporting Services with Custom Code
Today Pragmatic Works released a whitepaper I wrote and I thought I would share it with you. Prepare for Marketing...
2012-02-08
1,643 reads
SQL Saturday Jacksonville and Precon with Kevin Kline
I’m so excited to tell you about SQL Saturday 130 in Jacksonville coming April 28th. This is the 5th year...
2012-02-07
1,044 reads
SSRS – Using Analysis Services Dynamic Management Views to Build Dynamic Reports
Dynamic Management Views are a very powerful tool that are part of Analysis Services in 2008 and 2008 R2. They...
2012-02-01
2,318 reads
SSRS - Custom Code with External Assemblies
In a previous post I wrote about how you can use embedded custom code to extend the capabilities of Reporting...
2012-01-31 (first published: 2012-01-26)
24,231 reads
Session Code – Extending Reporting Services with Custom Code
This is my wish list of things I’d like to cover in todays session at 11 AM EST https://www1.gotomeeting.com/register/935071481 but...
2012-01-19
3,516 reads
January 2012 Speaking Events
It has been a quiet past few months while my family has adjusted to having
two new additions (twins!), but...
2012-01-10
913 reads
SSRS - Embedded Custom Code
When developing reports in Reporting Services you will often use the built-in
expression language to make report data and formatting...
2012-01-12 (first published: 2012-01-05)
4,593 reads
SSAS – Display Folders
Display folders are an often used tool in Analysis Services to help end users navigate through a cube or dimension...
2011-12-27 (first published: 2011-12-20)
6,439 reads
SSAS – Deployment Wizard
The Analysis Services Deployment Wizard is an often under utilized but important tool when moving your OLAP database throughout your...
2011-10-26
7,396 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers