Archive for December, 2010

Version 1.1 of Microsoft SSIS Connectors for Teradata and Oracle by Attunity Released

December 23rd, 2010 Josh Robinson

I just noticed that Microsoft release version 1.1 of the Attunity connectors for both Teradata and Oracle at the end of Q1 2010.  There are some decent improvements and they can be downloaded at this link.  I have used the Attunity Oracle connector in a limited capacity in the past, but plan to be using [...]

Posted in Development, SQL Server Tags: , , , , Comments Off

Adventures in MDX – Sets

December 22nd, 2010 Audrey Hammonds

As I’ve mentioned before, I’m just not good at MDX. No excuses… I’m just not. Rather than jumping in and memorizing functions and complex structures, I’m trying to train my over-saturated brain to comprehend how the data is structured, and subsequently, how to get said data out of the cube and into a result set. [...]

Posted in Database Development, SSAS Tags: , , No Comments »

Step By Step PowerPivot using Excel Data

December 17th, 2010 Matt Wollner

This post is a step by step beginner’s guide to PowerPivot.  I will show the basics of creating a PowerPivot workbook using Excel data.  PowerPivot has dramatically improved the way in which we can analyze our data in Excel.  Using PowerPivot in an Excel PivotChart provides the added benefit of Slicers.   Slicers are a cool new [...]

Posted in PowerPivot Tags: , , , , , , , No Comments »

Advance Search – SQL Server

December 14th, 2010 Matt Wollner

As a BI Consultant, I am frequently going into new databases and writing queries against unfamiliar data sources. I have created a stored procedure that goes against the system views to help quickly find a key word in a Table, View, Columns or Stored Procedure. Once the procedure has been created you can execute it [...]

Posted in SQLServerPedia Syndication, T-SQL Tags: , , , No Comments »

SQL Custom Keyboard Shortcuts

December 13th, 2010 Matt Wollner

Keyboard shortcuts play an important role to increase the productivity, in any development environment . There are tons of shortcuts that are beneficial in SQL Server Management Studio. SSMS 2005/2008 also allow you to easily add your own keyboard shortcuts. The two shortcuts that I always create are the SELECT TOP 1000 * FROM and [...]

Posted in General, SQL, SQLServerPedia Syndication Tags: , , , 2 Comments »