Microsoft BI tools: How they use data sources
A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and...
2013-04-02
1,261 reads
A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and...
2013-04-02
1,261 reads
My first article in SQL Server Pro magazine has been published. It is entitled “SQL Server 2012 Business Intelligence Enhancements”...
2013-03-28
1,560 reads
I had someone ask me the other day if they are using SSIS 2012 Project Versions, is there any benefit...
2013-03-26
4,072 reads
Using SQL Server views throughout a Business Intelligence (BI) solution can provide a tremendous amount of benefits. Here is a...
2013-03-19
730 reads
First lets define what Business Intelligence (BI) is. My favorite definitions:
Forrester Research: “Business Intelligence is a set of methodologies, processes,...
2013-03-14
2,044 reads
Thanks to everyone who attended my session “Top BI Enhancements for SQL Server 2012” at the Houston Area SQL Server User Group Monthly Meeting.
Here...
2013-03-13
989 reads
Version 2 of Parallel Data Warehouse (PDW) is apparently due this month (and can be ordered as of March 1st). The official...
2013-03-12
2,703 reads
Next Tuesday, March 12th at 1:15pm CST, I will be presenting the session “Top BI Enhancements for SQL Server 2012” at...
2013-03-08
827 reads
I have been using Microsoft’s Master Data Services (MDS) on a daily basis for the last 8 months. I also...
2013-03-07
3,069 reads
My most popular blog has been Visual Studio 2012 does not support BI. In short, this means VS 2012 does...
2013-03-06
2,773 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers