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
633 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
633 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,180 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
816 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,328 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,063 reads
The SSIS script component can be configured to use synchronous or asynchronous outputs. If the script component is configured for...
2012-03-20
7,898 reads
In my prior blog post, I provided some details regarding currency conversion via measure expressions in SSAS. I recently attempted...
2012-02-09
976 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,053 reads
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
Hello Everybody, I have a database on which I try to empty a file...
My knowledge of Extended Events is limited, but I am trying to capture some...
I've got something I'm not aware of performing backups of my dbs at random...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers