BI Developer Network Community blogs

Who is online?  0 guests and 0 members
Home  »  Blogs  »  Blogs

Communifire Blogs

Blogs RSS Feed

Blogs: Most Recent postings

DevinKnight

Power View Reporting on Multidimensional Cubes Released

6/2/2013 by DevinKnight  -  Comments: 0  -  Views: [3932]

I’m a little late to the celebration but on Friday some there was some exciting news regarding Power View was announced. You can read about the details of it at the Analysis Services and PowerPivot team blog for Microsoft here. http://blogs.msdn.com/b/analysisservices/archive/2013/05/31/power-view-connectivity-for-multidimensional-models-released.aspx This is part of a SQL Server Cumulative update pack that you can download here. http://support.microsoft.com/kb/2833645 One thing to probabl...

Read More

cprice1979

Hello My Name is Sqoop

5/30/2013 by cprice1979  -  Comments: 0  -  Views: [2703]

If my previous post we have looked at different means and methods for loading and subsequently working with data in a Hadoop environment. Largely missing from the discussion to date however is how SQL Server and other relational database play in this sandbox. While there are multiple points of integration the focus of this post will be on SQL-to-Hadoop tool better known as Sqoop. Have a Double Sqoop Sqoop is a relatively new command-line tool whose primary purpose is efficiently moving data betw...

Read More

CraigLove

SSIS Quickie - OPTION (FAST 10000)

5/29/2013 by CraigLove  -  Comments: 0  -  Views: [2024]

There are precious few golden rules in Business Intelligence. Too often when asked a question, I am forced to respond with a firm "It depends." There are many issues/tips items out there which are best practices - SQL Server Page Compression, avoiding fully blocking task flow transformations, using the NOLOCK in source queries, etc. It looks like there will be another to add to the list. Rob Farley has posted an interesing blog post involving the use of the query hint OPTION (FAST number_rows). ...

Read More

sqlchicken

Internet Security Advice for the Family

5/28/2013 by sqlchicken  -  Comments: 0  -  Views: [1297]

For today's post I'm channeling my inner Brian Kelley ( Blog | Twitter ) and talking about security, in particular Internet security. The post today is actually an email exchange between myself and my younger sister. She asked me for some general advice and I wrote a long response and figured I'd share it with you readers (which maybe you can in turn use to send to your own family seeking similar advice). Without further ado, here's the email exchange: Hi Jorge, Quick question Michael and I want...

Read More

KathiKellenberger

Speaking Engagements for the Second Half of 2013

5/24/2013 by KathiKellenberger  -  Comments: 0  -  Views: [892]

My speaking engagement schedule for the second half of 2013 is starting to shape up. If you are looking for speakers for your user group, I would love to help you out, especially if I can do so remotely. Send me a private message through Twitter @AuntKathi or through this site. I hope you can join me at some of these events! Date Venue Topic June 11 (Remote) St. Louis SQL Server User Group AlwaysOn Availability Groups and HA/DR Options June 11 I-380 Corridor (East Iowa) PASS TBD June 12 Quad Cit...

Read More

cprice1979

#SQLPASS Abstract Review - My Perspective

5/24/2013 by cprice1979  -  Comments: 0  -  Views: [1106]

I have been fortunate enough to participate as a team lead for the past two years on the abstract review committee for PASS Summit and I wanted to take a moment to provide some feedback based on my own personal experiences. First, this year was by far the toughest. The quality of abstracts was phenomenal which made the job of abstract review and session selection very tough (this is good thing btw). Much of this is not new. I am hoping that it will help you make more sense of the abstract review...

Read More

MMilligan

Data Mining with DMX

5/23/2013 by MMilligan  -  Comments: 1  -  Views: [7778]

To my knowledge, Microsoft has three methods of performing data mining within their BI stack. The Excel Add-In, the GUI and wizards within BIDS, and the DMX query language . Obviously the key draw back to the Excel Add-in is that you can't schedule it to run automatically without human intervention. However, the Excel Add-in provides an excellent method to form your hypothesis and test it. The GUI and the wizards are nice and you can create repeatable processes using those tools alone. The comma...

Read More

KeithHyer

Hierarchy with recursive CTE ( and a little borrowed sorting trickery )

5/23/2013 by KeithHyer  -  Comments: 4  -  Views: [16931]

The Question I misread a question about a table that contains "Parent -> Child" data in the SSRS forums here on BIDN recently and I decided to attempt answering it. I thought it was a question that many of us have no doubt run across before - "how do you show a hierarchy for data when you have a table with "parent" and "child" information listed in the row values? So I thought I'd give it a shot and share my results. Let's get into it Like my math professor always said, "first, make sure you ...

Read More

MMilligan

SSAS Gotcha: The Operation Has Been Cancelled Due To Memory Pressure

5/23/2013 by MMilligan  -  Comments: 2  -  Views: [8978]

My team and I recently had an issue with our SSAS instance in which users were receiving the following message from Excel: Data Could not be retrieved from the external data source. Error message returned by the external data source: Server: The operation has been cancelled due to memory pressure. Ok Another user reporting a different error from Excel when trying to create a new connection to the Analysis Services database: An error has occurred in the transport layer. Errors in the OLE DB provi...

Read More

sqlchicken

Business Objects on Linux and SQL Server

5/23/2013 by sqlchicken  -  Comments: 15  -  Views: [1848]

This is just a quick post to share a lesson learned while I was on an engagement where the client's reporting environment was using SAP Business Objects (BO)running on Linux for reporting. We were doing a test to move the underlying data warehouse from another database platform to SQL Server 2008 R2. As we changed connections over, however, we quickly ran into a roadblock. It seems when we tried to make a connection to SQL Server via BO we got the error of 'Unable to bind to Configuration Object...

Read More

DevinKnight

Ad-hoc Reporting with SharePoint Recording and Q&A

5/23/2013 by DevinKnight  -  Comments: 0  -  Views: [2349]

I hope you were able to attend my free webinar on Ad-hoc Reporting with SharePoint on May 21, 2013. If you weren’t you can now watch the recording here . As usual there were many great questions that I wasn’t able to answer and I thought I’d follow up on those now. Q: In the organization that I work in, SharePoint 2013 is stood up but is somewhat barren, just some team pages. Where would I be able to locate the ReportBuilder environment in a 2013 implementation? Is it apparent ...

Read More

sqlchicken

Speaking at Summit 2013!

5/22/2013 by sqlchicken  -  Comments: 2  -  Views: [989]

I'm happy to officially announce that I'll be presenting at this year's PASS Summit in Charlotte, NC! I'll be presenting my talk "What is a BI DBA?" as a Spotlight Session (90 minutes). This is the second time I'll have presented at the Summit and I'm honored and beyond excited to have a Spotlight Session so we can cover more material! This year the conference runs from October 15-18. I hope to see you at the Summit this year! http://www.sqlpass.org/summit/2013/

Read More

cprice1979

PASS Summit 2013

5/22/2013 by cprice1979  -  Comments: 0  -  Views: [919]

It's official!! I will be presenting a session on HDInsight and Predictive Analytics at PASS Summit 2013 in Charlotte, North Carolina. This is the first time the event is being held in Charlotte instead of Seattle and while I have attended previous Summits for many years in various capacities, this year is special as it will be my first time presenting. I hope you will consider joining me this year at PASS Summit! For more information and check out the official website at: http://www.sqlpass.org...

Read More

Anil

Think while Rename a Column Name of Table in SQL.

5/21/2013 by Anil  -  Comments: 1  -  Views: [2037]

If someone tries to rename the column of table then we write a query as SP_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN' --we use as SP_RENAME 'DimCustomer.[FirstName]' , 'CustomerName' , 'COLUMN' --Mistakenly, SP_RENAME 'DimCustomer.[FirstName]' , '[CustomerName]' , 'COLUMN' -- which gives the column the name [CustomerName], not CustomerName. For rename the column http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/ You don't use the [...

Read More

guavaq

Date Filtering in Excel from your Analysis Services Dimension

5/21/2013 by guavaq  -  Comments: 5  -  Views: [7092]

I recently had to set up another Date Dimension and went through the process of setting up all the properties in the date dimension so that when it is used in Excel, the end users would then be able to use the Date Filters built into Excel. The Excel Date Filters are very handy when creating Excel documents. As an example if you create your Date Filter to be for the last month. Every time you open your Excel document it will automatically filter to the current month. So below are the details on ...

Read More

Anil

How can we know and free remote login session in Windows Server 2008 ?

5/20/2013 by Anil  -  Comments: 0  -  Views: [4470]

Through this post , I want to share about the problem we faced while working in Windows Server 2003/2008. In our day to day work , we might frequently need to connect to remote Windows Server machine and while we try to connect to the Windows Server which allows multiple login session, sometimes we get an error message as : if there is no any free sessions “ If you need to connect the server urgently for your high priority task to complete then you simple need to find the sessions in that ...

Read More

cprice1979

MapReduce Ninja Moves: Combiners, Shuffle & Doing A Sort

5/20/2013 by cprice1979  -  Comments: 1  -  Views: [6681]

Who's driving this car? At first glance it appears that as a developer, you have very little if no control over how MapReduce behaves. In some regards this is an accurate assessment. You have no control over when or where a MapReduce job runs, what data a specific map job will process or which reducer will handle the map's intermediate output. Feeling helpless yet? Don't worry the truth is that despite all that, there are a number of ninja techniques you can use to take control of how data moves...

Read More

KathiKellenberger

Database Snapshots

5/18/2013 by KathiKellenberger  -  Comments: 2  -  Views: [2215]

I have been writing a lot of T-SQL scripts lately for regression testing. I identify test cases and write scripts to modify the data. Then the data can be verified as the rows go through ETL. As I tweak the scripts, I need to continually restore the source databases to get the data back to the starting point. Instead of doing restores, I am using the Database Snapshot feature. Database Snapshots were introduced in 2005 in Enterprise and Developer editions. They allow you to quickly revert a data...

Read More

KathiKellenberger

How I got here

5/18/2013 by KathiKellenberger  -  Comments: 0  -  Views: [848]

I am late for posting this in time for T-SQL Tuesday, but I thought I would contribute anyway. This month the topic is about your career path. My career has focused on SQL Server since 2002, but it was a long, winding road to get here. I didn’t start out in technology at all; I began my adult working life in pharmacy. After getting to play with a TRS 80 computer in a class during my last year of pharmacy school, I became obsessed with computers. Programming became my hobby, and I learned s...

Read More

nitya

New Azure SQL Database Performance Features

5/16/2013 by nitya  -  Comments: 0  -  Views: [1680]

It appears that Microsft has silently refreshed some Services/Management portal as no blog or In specific im referring to the vizualization added to Windows Azure SQL Database We can now view Deadlock Failed Conections Throttled Connections etc You may view those by Logging into the HTML5 Management Portal Once in, you can navigate the new information as below Hit SQL Databases (on the Left Menu) --> Select a server --> Select a Database --> Select Monitoring Attached are a few Screensh...

Read More

sqlchicken

Magnify SQL Text with SSMS 2012

5/16/2013 by sqlchicken  -  Comments: 0  -  Views: [1027]

This is just a quick tip to help with folks who present SQL code at events such as SQL Saturday. While most presenters use tools like ZoomIt (which if you present, please please learn to use this wonderful, free tool) sometimes it can get nauseating for attendees to watch you constantly zooming in and out, especially on code. A quick way around this is by using the magnification feature in SQL Server Management Studio 2012. To do this simply hold down the Ctrl button on your keyboard and with yo...

Read More

pkumar3

Find the Size of the SQL SERVER Table

5/14/2013 by pkumar3  -  Comments: 0  -  Views: [936]

SP_SPACEUSED 'TableName' name rows reserved data index_size unused TableName 4 16 KB 8 KB 8 KB 0 KB

Read More

SQLKohai

Datamodelling begins

5/13/2013 by SQLKohai  -  Comments: 2  -  Views: [667]

So I've decided to take a step in the right direction and begin the data modelling phase of my project. For those who didn't read my last blog post, I'm trying to find ways to study and get ready to take the BI Cert exam in September. I thought working on something for work might be a good way to start. So I'd like to begin by creating a small datawarehouse that tracks positions for investments. A position is the value of a portfolio of stock at a specific moment in time. So for example, the pos...

Read More

vksingh24

SSIS: How to load data into SQL table from Google Spreadsheets?

5/13/2013 by vksingh24  -  Comments: 0  -  Views: [1797]

SSIS (SQL Server Integration Services) is well known for extracting data from a variety of sources. It can extract data from online sources as well. Google Spreadsheet is one of the online source which stores data online. In this post, we will learn to extract data from Google Spreadsheet using our favourite tool – SSIS. Pre-requiste: Before we talk about SSIS package, there are few concepts that we need understand. #01. To use Google Spreadsheet data you must have a Google account. With a...

Read More

cprice1979

Tuning Multi-Dimensional Cube Processing

5/11/2013 by cprice1979  -  Comments: 1  -  Views: [7769]

In my last post ( HERE ) we talked about troubleshooting and resolving issues with problematic MDX queries. In this post we will look at techniques to tune and troubleshoot the processing side of your Analysis Services cube. Understanding Cube Processing Some of the common questions I hear as a consultant are "Why does my cube take 4 hours to process?" or "How can I reduce the time it takes to process my cube?". The answer to both of these questions starts with identifying the processing bottlen...

Read More