O, There’s the Data: Using OData in SSIS
The Open Data Protocol (OData) is an open specification created Microsoft to enable exposing data in a standard way from...
2012-07-23
1,284 reads
DataOnWheels
Excel 2013 Will Impact BI Users
As noted in that great text, The Hitchhiker’s Guide to the Galaxy, “Don’t panic!” Excel 2013 will make even more...
2012-07-17
820 reads
X-XMLA: v. Creating XMLA Script from Visual Studio and Deploy the Database
This will be the easiest entry in this series. This is a reblog of an article I wrote last year....
2012-06-26
1,181 reads
Presenting at PASS Summit 2012
I am pleased to announce that I will be speaking at the PASS Summit again after a four-year “break”. I...
2012-06-22
524 reads
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
908 reads
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,078 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
615 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
921 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
569 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
595 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Alamat BCA KCP Iskandar Muda Telp/Wa:0821-8200-233
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
BCA KCP Panglima Polim Raya Tlp:0821-8200-203
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Alamat BCA KCP Kota Kasablanka Tlp/Wa:0821-8200-174
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers