T-SQL Tuesday: A Day in the Life of a BI Developer
My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles. I’ve been a BI developer for...
2012-07-17
643 reads
My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles. I’ve been a BI developer for...
2012-07-17
643 reads
I’ve decided that the best way to spend a day of 104 degree weather is to sit inside and write...
2012-07-07
1,277 reads
I recently encountered a business scenario involving calculated members in a cube that I thought is worth sharing.
We have a...
2012-07-04
824 reads
One type of error that arises occasionally during SSAS cube processing is the ‘duplicate attribute key’ error. The error message...
2012-05-07
1,341 reads
My co-worker showed me an easy way to process all SQL Server Analysis Services (SSAS)cube dimensions (or measures) from the...
2012-04-02
4,340 reads
The SSIS script component can be configured to use synchronous or asynchronous outputs. If the script component is configured for...
2012-03-20
8,130 reads
In my prior blog post, I provided some details regarding currency conversion via measure expressions in SSAS. I recently attempted...
2012-02-09
1,004 reads
Currency conversions can be implemented several ways as part of a business intelligence solution. In some scenarios it may be...
2012-02-01
5,120 reads
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Hi everyone I asked this earlier but the desired outcome is a bit different...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers