X-XMLA: iv. Deploying Databases with XMLA
The fourth segment in this series focuses on using XMLA to deploy databases. When you create SQL Server Analysis Services...
2012-06-19
901 reads
DataOnWheels
Simple batch script to generate XMLA and deploy SSAS DB
Reblogged from Data on Wheels - Steve Hughes: As I was working through some issues with my cube design, I realized...
2012-06-17
1,049 reads
A Visit to the Eugene Area SQL Server User Group
When in Portland… This week I am in Portland, Oregon working with a customer. While I was here, I thought...
2012-06-07
604 reads
Oracle Tips for MSBI Devs #3: Choosing Drivers
When working with Oracle, drivers are truly a pain to get working correctly. I will discuss my preferred choice and...
2012-04-24
905 reads
Great User Group Meeting Tuesday, Now on to Madison and SQL Saturday #118
Minnesota SQL Server User Group Meeting Review (4/17/12) First of all, I have to thank the awesome speakers who presented...
2012-04-19
552 reads
Oracle Tips for MSBI Devs #2: Keyword compare between Oracle and SQL Server
While attending a recent Windows Azure Quick Start, the presenter, Mike Benkovich (@mbenko) happened to show a table on his...
2012-04-17
583 reads
X on XMLA: iii. Basic DDL Functions in XMLA (Create, Alter, Delete)
XMLA can be used to manage the structure of your multidimensional databases. While many developers use Visual Studio (BIDS), to...
2012-04-10
701 reads
I’m Speaking at SQL Saturday #118 in Madison Wisconsin
If you happen to be in the area on April 21, 2012, join us at Madison Area Technical College – Truax...
2012-04-04
581 reads
Oracle Tips for MSBI Devs #4: Executing an Oracle Stored Proc with IN Parameters in SSIS Execute SQL Task
The first tip I published discussed how to execute an Oracle procedure with no parameters. In this tip, I will...
2012-04-03
726 reads
Why I am excited about SQL Server 2012 (Part 2)
Earlier this month I published a blog entry on this same subject. In honor of the local Minneapolis launch event,...
2012-03-28
691 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...