Fast Guide: SQL Server Reporting Services
Check out this collection of best practices, troubleshooting advice and perfomance tips for working with SSRS in SQL Server 2005.
Finding a Work-Life Balance
Like most everyone who works hard in our industry, I’ve run into more than a few conflicts trying to balance work and life. Personally, the further I progress in my career, the blurrier the lines become between work time, family/me time, and just plain lazy downtime. It’s quite easy to say that you’re going to spend X hours at work, and the rest of the time is mine, but the reality is ...
Integrating Visio 2007 with SQL Server Analysis Services
This article shows how Microsoft Office Visio 2007 can be used to visualize cube data created using SSAS
Centralising Reporting Services Stylesheets
Continuing on with his series on Reporting Services, Adam Aspin takes another look at stylesheets in your reports. This time with custom assemblies and the CLR to enhance the capabilities of your SSRS system.
East Iowa SQL Server Users Group
A new SQL Server user's group in Iowa is having a meeting next week.
Formatting SSAS Measures - SQL School Video
ln this SQL School video, learn how you can format the various measures in your SSAS cubes.
Detecting When a Login Has Implicit Access to a Database
Yesterday I blogged about how to figure out what database principals corresponded to what server principals . The key is to match up the SIDs between sys.server_principals and sys.database_principals. But I also stated there were 3 cases where the logins...
Introduction to SQL Server 2008 Report Builder 2.0
I have heard that there is a new version of Report Builder in SQL Server 2008. Can you provide some details and examples?
The LEVEL_UNIQUE_NAME Intrinsic Member Property
SSAS Architect Bill Pearson examines another intrinsic member property, LEVEL_UNIQUE_NAME, which allows us to exercise a great deal of presentation “sleight of hand” in working with MDX in Analysis Services, as well as within Reporting Services and various other reporting applications that can access an Analysis Services cube.
Union Benefits
IT is an industry that hasn't adopted a union, at least not yet. Many IT workers hope it never happens, but what if it does? This Friday Steve Jones asks what benefits you might want from a union.
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers