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

KathiKellenberger

Fragmentation Presentation Follow Up

11/12/2013 by KathiKellenberger  -  Comments: 0  -  Views: [3945]

Thanks to all of you who attended my presentation on fragmentation. If you would like to view the video, you can find it here . You can also download the code and slides if you would like. As always, there were several questions during the session. If there is something else you would like to ask, please leave a comment. Q: What is the command to get the fragmentation statistics? A: It is a dynamic management function sys.dm_db_index_physical_stats Q: If I delete and rebuild all clustered in a d...

Read More

RCharCox

Query Plans and what OPTION(RECOMPILE) does.

11/12/2013 by RCharCox  -  Comments: 0  -  Views: [2143]

The other day I was tasked with creating a pretty intensive query (hey, I’m not an expert on T-SQL yet), and I came across a stored procedure that read something to the effect of: SELECT DISTINCT [Database].[Table].[Column] FROM [Database].[Column] WHERE ( Column = @Parameter1 OR @Parameter1 IS NULL ) AND ( Column2 = @Parameter2 OR @Parameter2 IS NULL ) OPTION(RECOMPILE) ; So, the first part of the query is pretty straight forward, but what the heck is that “OPTION(RECOMIPLE)?”...

Read More

CraigLove

SQL Server Firewall Settings - Part 2

11/12/2013 by CraigLove  -  Comments: 0  -  Views: [2983]

In my previous blog entry on firewall settings, I provided guidance for setting up a firewall opening for the default instance of SQL Server. In this second entry, I will provide the steps for setting and allowing a connection to a non-standard port. I am using SQL Server 2008R2 but the steps shown are the same for SQL Server 2012. By default, SQL Server uses port 1433 for the default instance. If you plan on using SQL Server named instances (i.e. ServerName\Instance), you will need to decide if...

Read More

Anil

Questions on Power Maps for Excel 2013.

11/7/2013 by Anil  -  Comments: 0  -  Views: [3168]

Hello to all, Been quite long time, I really miss the blogging world. This blog is mainly about the question that I asked on the webinar. Just recent, I have attended the Pragmatic Works free webinar by @Devin Knight on ‘’ Touring your Data with Power Maps’ Which is quite interesting and knowledgeable. One can learn about the power map and power query through the Microsoft site or the link below. Here are some question that I have asked. 1. Does it only works for US states geog...

Read More

ronb

SSAS 2012 vs SSAS 2008 R2 Issue

11/5/2013 by ronb  -  Comments: 0  -  Views: [2197]

SSAS 2012 vs SSAS 2008 R2 Issue I am having a problem with the following MDX: WITH MEMBER [Measures].[ParameterValue] AS '[Currency].[Currency].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterCaption] AS 'Space(([Currency].[Currency].CURRENTMEMBER.Level.Ordinal)*1.8)+[Currency].[Currency].CURRENTMEMBER.NAME' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue]} ON COLUMNS, … View More Except({[Currency].[Currency].AllMembers},{[Currency].[Currency].&[-1]}) ON ROWS ...

Read More

DevinKnight

Dealing with Power Pivot to Tabular Upgrade Errors

11/4/2013 by DevinKnight  -  Comments: 0  -  Views: [6769]

Upgrading from Power Pivot workbooks to SSAS Tabular models is usually a pretty seamless process. This is part of the beauty of the relationship between Tabular and Power Pivot. This allows an Analyst to get started on a project using Power Pivot and when new requirements like row level security are needed IT can upgrade the workbook to Tabular and add the security feature. While this generally is a smooth process I often see the same couple error messages pop up for folks that are doing this. S...

Read More

CraigLove

SharePoint 2013 CU August 2013 Problem

11/1/2013 by CraigLove  -  Comments: 0  -  Views: [2554]

Beware the dangers of the cutting/bleeding edge! There is a problem in the SharePoint 2013 Cumulative Update for August 2013. The problem manifests itself as an inability to work with SQL Server Reporting Services parameters within the Performance Point Dashboard Designer. What happens is that SSRS report parameters are not displayed when the report is created in the Dashboard Designer. This means that you will not be able to link the Performance Point filters to the report. One workaround is to...

Read More

CraigLove

SQL Server Firewall Settings - Part 1

10/29/2013 by CraigLove  -  Comments: 0  -  Views: [3068]

Sooner or later you will be faced with the need to open your server or workstation firewall to allow incoming connections. This is always a pain for me since this is not a task I do regularly. Finally after researching the issue several different times for each of the services in SQL Server, I wised up and put it all down in my OneNote reservoir. This is the first of a series of blogs that provides guidance for setting firewall and server settings to allow connections to the various components o...

Read More

DustinRyan

SSAS Lessons Learned: 29% Better Compression and 11% Better Query Performance

10/25/2013 by DustinRyan  -  Comments: 0  -  Views: [7649]

The Importance of Sort Order This past week I taught the SSAS Masters class which is one of the virtual training classes offered by Pragmatic Works . One of the things we discuss in the class is the importance of sorting the fact data in your data warehouse in preparation for Analysis Services. Simply by sorting your fact data, you can see much improved compression which can also improve your query response time, as well. But how much improvement in compression and query response could you see? ...

Read More

DevinKnight

PASS Summit 2013 and SQL Saturday Charlotte in Review

10/21/2013 by DevinKnight  -  Comments: 0  -  Views: [2461]

I love reading the many blogs posts that pour in following a PASS Summit. I think it is fun to read everyone’s experience. There’s not really a wrong way to attend the conference unless you just hide our in your hotel the whole week. Here’s how my week went. Sunday This was a travel day for me. I drove with Brad Schacht and Gareth Swanepoel up to Charlotte from Jacksonville. This was a fun 5.5 hour drive as Gareth live tweeted our trip with the hashtag #sqlwolfpack. We arrived ...

Read More

KathiKellenberger

PASS Summit 2013 Report

10/21/2013 by KathiKellenberger  -  Comments: 0  -  Views: [1895]

I am on a flight to LaGuardia as I write this after spending a week in Charlotte at the SQL PASS Summit . I was only home long enough to attend my brother’s wedding yesterday and sleep about 11 hours before heading to my next customer in New York City. I feel like time has stood still while the Summit captured my entire attention for the past week. I know that things happened in the world like the federal government starting up again and the Cardinals winning the National League Pennant, b...

Read More

ShawnHarrison

Scripting Webinar Follow Up

10/18/2013 by ShawnHarrison  -  Comments: 0  -  Views: [1811]

  I would like to say thank you to all of those that attended my webinar on using C# scripts in SSIS. I had a lot of fun putting together examples for that presentation. There were a few things I could not cover due to time, but I think it went well. I didn?t receive a lot of questions, so below are the questions I did get, along with the answers. I have also uploaded the SSIS project along with the Powerpoint presentation and the all the scripts that I used. You can download them from the ...

Read More

McMike

Source & Destination Best Practices with the Task Factory Dimension Merge SCD

10/14/2013 by McMike  -  Comments: 0  -  Views: [4214]

When I figured out errors or other issues when it comes to IT, I often feel like I’ve just defeated the Matrix. Granted… these situations are often due to my own incorrect settings (okay… pretty much always), but let’s not split hairs. I beat the machine, and that’s what matters. Whoa. Moving on… The Task Factory Dimension Merge SCD component is a lot of fun. It also has a lot of moving parts and can be a challenge when one is going through the initial setu...

Read More

KathiKellenberger

Why should you visit the Pragmatic Works booth while in Charlotte?

10/14/2013 by KathiKellenberger  -  Comments: 0  -  Views: [1800]

I am in Charlotte, NC, this week along with a few thousand of my friends for PASS Summit 2013. Many descriptions come to mind like SQLFamily reunion or maybe Nerdvana. If you are lucky enough to be here as well, I encourage you to stop by the Pragmatic Works booth. Even though our booth number is 404, you will still be able to find us! Here are 5 reasons to stop by the Pragmatic Works booth: #5 SWAG: Stop by and pick up some swag: You might get a t-shirt, a book written by Pragmatic Works consul...

Read More

KathiKellenberger

T-SQL Tuesday #47: SWAG

10/8/2013 by KathiKellenberger  -  Comments: 1  -  Views: [1867]

This month’s T-SQL Tuesday topic is SWAG. What is the best T-SQL SWAG you have received? Usually, when I go to SQL Server events, I pick up the things that are useful like luggage tags or something fun for my grandson to play with. Of course, I have several Idera rubber ducks and picked up several foam rockets from Bridgewater that are fun. I even won a $200 gift card at a SQL Saturday a couple of years ago. The best swag I ever received was .Net related. The story behind it means more to ...

Read More

TerryChoo

SQL Logical Query Processing Order

10/7/2013 by TerryChoo  -  Comments: 0  -  Views: [3632]

As my first blog on BIDN, I thought I'd re-visit a basic SQL Concept - The Logical Processing Order of an SQL Query. This probably applies more to beginners or people who have been using SQL for a while but have been wondering why sometimes the query works in a certain way and sometimes it didn’t. Before I read the book for the exam 70-461, I found it relatively easy to just plonk in some code in SQL Server Management Studio and Voila! it works. Well, not all the time. For example, this wo...

Read More

KathiKellenberger

MVP News

10/2/2013 by KathiKellenberger  -  Comments: 1  -  Views: [3483]

I am thrilled to announce that I was selected today to be a SQL Server MVP. The MVP award is given by Microsoft to those who share knowledge and passion with the technical community. For me, that means I write and present constantly. I am joining over 300 people who share my love for SQL Server and about 4000 people worldwide in all of the technologies. You may be wondering how I got to this point and what it takes to be an MVP. Well, as I said, I write a lot. Over the past eight years, I have b...

Read More

ChrisSchmidt

BI Administration: The Business Intelligence Management Data Mart

10/1/2013 by ChrisSchmidt  -  Comments: 0  -  Views: [4269]

Firstly, I’d like to thank everyone who attended my session this morning for Pragmatic Works Training on the T’s. I always enjoy presenting, Today’s topic was about management and administration of business intelligence solutions. The theme of the overall presentation was that although there are many ways to collect the meta data around our business intelligence solution, the data itself still lends itself to a dimensional structure, that we can use to model into various facts ...

Read More

McMike

Multiple Dynamic Attachments with the Task Factory Advanced Email & SMS Task

10/1/2013 by McMike  -  Comments: 0  -  Views: [2569]

Recently I had a client inquire on the ability to have multiple dynamic attachments in an expression when using the Task Factory Advanced Email & SMS Task used in SSDT. The normal way to add attachments is through the file system, using the “Attachments”, then “Browse” buttons: …but that would be directly attaching the specific file(s). I want it dynamic. And I want more than one. And I want my student loans paid off. I want a lot of things, so let’s move...

Read More

seasofttraining

SEASOFT IT SOLUTIONS -Seasoft IT Solutions is the leading and the premier Online Training provider.

10/1/2013 by seasofttraining  -  Comments: 0  -  Views: [2793]

Seasoft IT Solutions is the leading and the premier Online Training provider, which offers you training in all IT Courses like Oracle , PeopleSoft , Data Warehousing , SAP, Networking and Administration etc for the students who are located in USA, Canada and all over the world. Seasoft IT Solutions is a Training Institute dedicated to providing high quality and cost effective training to the Local Community, Global and the Business Enterprise.We got 1000+ instructors round the globe and our wide...

Read More

DevinKnight

Awarded Microsoft MVP

10/1/2013 by DevinKnight  -  Comments: 3  -  Views: [1527]

Today I’m extremely excited, honored and humbled to announce that I have been recognized as a Microsoft MVP for first time. Becoming an MVP has been an informal goal for me for quite sometime now. I’ve always kept this as more of an informal goal because I’ve always thought of myself as someone that does the right thing when no one is looking. In fact, this is something I work on constantly with my oldest son because it is that important to me. My end goal with being involved i...

Read More

CraigLove

SSRS Connection Manager Strings

9/29/2013 by CraigLove  -  Comments: 0  -  Views: [1215]

Here’s a quick one that a client sent to me. When working in SQL Server Reporting Services it is easy to create the Data Source connection using the wizards in Report Designer (Visual Studio) or Report Builder. However, if you need to create a new data source within Report Manager, no wizard is provided. If you can, it is simple enough to open a different connection manager that uses the same a similar data source. However, this may not be available if this is a new server, you lack permis...

Read More

cprice1979

Streaming #Pig

9/27/2013 by cprice1979  -  Comments: 0  -  Views: [7723]

As a C# developer there are a number of opportunities available for writing code that is either used by or interacts with a Hadoop/HDInsight cluster. A number of these have been well publicized and documented. In fact there is an entire .Net SDK for Hadoop ( HERE ) that will allow you to easily write streaming MapReduce jobs, manage your cluster and even write LINQ-based queries against Hive (among other things). One option that you may not have been aware of is the streaming feature built into ...

Read More

DevinKnight

Understanding Microsoft Self-Service BI Recording and Q&A

9/26/2013 by DevinKnight  -  Comments: 0  -  Views: [3446]

I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 2013. If you weren’t you can now download the recording here . Because I covered new material all the way to the end of the webinar i thought I’d also answer some of the top questions I didn’t have time to answer here. Q: Can an Excel Power Pivot 2013 model be read by Excel 2010 or Excel 2007? What about Excel versions and their compatibility with SharePoint Versions? I as...

Read More

TMMichau

Custom Install of Workbench.

9/26/2013 by TMMichau  -  Comments: 0  -  Views: [1315]

There are various reason why people want to do a custom install of BIxPress, no internet to download the prerequisites, or you don't want to install certain parts of the Workbench like DOCxPress or DBAxPress, and etc.... The latest version is the Beta build, 4.9.11.916. I recommend you save the file from our website versus running it before saving. Once you get the workbench downloaded, locate it and double click on it. A message box will appear asking if you would like to run this file, click r...

Read More