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
737 reads
DataOnWheels
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
697 reads
X on XMLA: ii. Basic Structure of XMLA
The second post in the XMLA series focuses on the basic structure of XMLA. At its heart, XMLA is XML. ...
2012-03-27
699 reads
PASS for Today (and Tomorrow)
I just wanted to plug two events that are free SQL Server training. First, Thomas LaRock (@sqlrockstar) and Jason Strate...
2012-03-20
583 reads
Why I am excited about SQL Server 2012
By now many of you have had the opportunity to hear or see something about the next release of SQL...
2012-03-08
673 reads
Oracle Tips for MSBI Devs #1: Executing an Oracle Stored Proc with No Parameters in SSIS Execute SQL Task
Originally posted: 3-4-2012 Welcome to a new blog series of tips related to Oracle with a focus on helping those...
2012-03-04
577 reads
PASSMN Rocks 2012!
As many of you may know, I am the Chair for the Minnesota SQL Server User Group aka PASSMN. I...
2012-02-22
593 reads
PowerPivot and Market Research
This past Tuesday, February 14, I was invited to discuss how technology can be used to help analyze data for...
2012-02-16
603 reads
PowerPivot for Excel Install Issues
At one of my customers, we had a very frustrating experience while trying to get PowerPivot for Excel (SQL Server...
2012-02-02
988 reads
Microsoft Data Appliances Help Simplify MSBI Projects
As some of you know, I am really excited about the data appliances Microsoft and HP have released this year. ...
2012-01-27
632 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers