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

robotrich

Documentation

5/9/2013 by robotrich  -  Comments: 0  -  Views: [715]

The D word...Documentation! I guess I am nutty but I think the product (whatever you making) is NOT complete until the documentaion is filed. There are two schools of thought here: documentation is not really important, who reads that stuff or sure do it but do not let that stop the deployment. The later is a half hearted attempt to appear that the higher ups are for it but they really do not care. HA! It should stop the deployment! I have worked only ONE and I mean one postion that had dcoument...

Read More

SQLKohai

Lets get it started!

5/9/2013 by SQLKohai  -  Comments: 0  -  Views: [758]

It's 2013, and I have several goals. Study for and pass the SQL BI certification exam - Implementing a DW with SQL 2012 Build a simple datawarehouse solution to practice with while I study Convince the powers that be, that it's a better idea to build something that buy something For #1, I need some advice on study guides, places to start, or essential books. For #2, I'd like to post my findings, mistakes, versions, and at times - frustrated rantings. Hopefully someone besides me will read this a...

Read More

ChrisSchmidt

Tabular Hierarchies Across Multiple Tables

5/9/2013 by ChrisSchmidt  -  Comments: 2  -  Views: [6919]

Recently I was looking at the Adventure Works database and I noticed how Product, ProductCategory, and ProductSubCategory are their own separate tables. It got me to thinking about how someone might want to take attributes from each of those tables and create one hierarchy for reporting when you are looking at it. In DAX, this can be accomplished by using the RELATED() function. By using the related function in our table with our lowest level attributes, we can bring in the higher levels and cre...

Read More

sqlchicken

SQLSaturday #209 - Rochester

5/8/2013 by sqlchicken  -  Comments: 0  -  Views: [921]

Just a quick note that I'll be presenting this weekend, Saturday May 11th, at SQLSaturday in Rochester, NY . Exciting to return to Central New York as I graduated right down the road at Syracuse University . Go Orange!​If you're in the area come on down, should be a great day of training. Check out the day's schedule ( link ), I'll be presenting two sessions this weekend: Do More With Less: Consolidate and Virtualize Policy-Based Management in a Nutshell You can follow the event along on Twitter...

Read More

ChrisSchmidt

Discretization Buckets in Tabular

5/7/2013 by ChrisSchmidt  -  Comments: 0  -  Views: [1941]

A little while ago I blogged about how to created discretization buckets in a multi-dimensional cube. The nice thing about it is that it was just a few properties that you needed to modify, and was pretty straightforward. To the flip side of that I see a lot of companies wanting to take advantage of the new tabular Analysis Services model and the performance you get from it. The good news is that you can do the same thing in tabular, but they’re not properties you set. To set it up, first ...

Read More

cprice1979

MapReduce - First Glance

5/4/2013 by cprice1979  -  Comments: 0  -  Views: [1584]

In my last post, we took a helicopter tour of the MapReduce framework and its many facets. I believe its important to have a functional understanding of MapReduce even if you never intend to never work directly with it since the more user-friendly abstractions of both Pig and Hive depend on it.  In this post we will again turn to Java as we let our fingers do the walking to build our first MapReduce program. For this demo we will start slowly, implementing first the map and reduce functions...

Read More

ChrisSchmidt

Tabular Databases: The workspace server was not found

5/1/2013 by ChrisSchmidt  -  Comments: 0  -  Views: [1690]

Sometimes, due to environment changes or some other reason, you want to change the workspace database that you are developing your tabular model against. I recently had a need to do this as my old tabular database instance was no longer active. When I went to open up the bim file, I received the following error message: To fix it, click on the bim file once to select it and then go to properties (F4). The last property on the page is called “Workspace Server” and specifies where the ...

Read More

MikeDavis

Monitoring SQL Server with SSIS

4/29/2013 by MikeDavis  -  Comments: 6  -  Views: [5739]

I did a webinar on Monitoring SQL Server with SSIS on pragmaticworks.com. Check it out on the webinars page there. Here are the code files for that webinar. The code is done in 2008 R2.

Read More

Daniel

I am speaking at SQL Saturday 209 in Rochester NY

4/29/2013 by Daniel  -  Comments: 0  -  Views: [1046]

I am going to be making two of my presentations: Managing your reporting Services Environment and SSIS Templates, Configurations, and Variables I hope to see you there. You can find the details of the event here: http://www.sqlsaturday.com/209/eventhome.aspx

Read More

CraigLove

Parallel Load Queuing Tables - Lock the Queue!

4/29/2013 by CraigLove  -  Comments: 0  -  Views: [1049]

SQL Server Integration Services provides the ability to execute ETL packages in parallel. This permits developers to take advantage of modern multi-core servers that typically have large amounts of memory. A simple method for achieving a form of parallelism is to simply use an Integration Services Sequence Container. Below is an example of this technique. Different packages will be executed simultaneously and, if the server resources are adequate, the resulting execution times will be greatly re...

Read More

KathiKellenberger

These are a few of my favorite books

4/25/2013 by KathiKellenberger  -  Comments: 0  -  Views: [1327]

IT is an interesting field; you are never done learning. In fact, things move pretty fast and it is hard to keep up. Even if you think you your job is stable, there are no guarantees and it pays to keep your skill sharp. I recently compiled a list of books that have helped me or are on my list to read (well, a couple of them I wrote) and I thought that list would be helpful to those who want to learn more about SQL Server. Learn T-SQL Beginning T-SQL 2008 Beginning T-SQL 2012 Microsoft SQL Serve...

Read More

cprice1979

Map/Reduce - A Brief Introduction

4/24/2013 by cprice1979  -  Comments: 0  -  Views: [2466]

Somewhere between teaching a BI Bootcamp class and wrestling my troop of kids, I promised myself I would get a blog post in this week. Luckily, I've had a few code heavy posts, so we will dial it back slightly as I briefly introduce MapReduce for Hadoop/HDInsight. Most of the MapReduce posts I've seen to date, talk very specifically about how to implement a C# MapReduce job on HDInsight. Before we go there, I think it's a topic that deserves a somewhat more abstract/academic discussion so that w...

Read More

KathiKellenberger

Why You Need to Attend SQL Saturday!

4/21/2013 by KathiKellenberger  -  Comments: 0  -  Views: [11069]

Earlier this month I had the pleasure of attending SQL Saturday in Chicago . I have attended several SQL Saturdays over the past three years, only one of which I did not have to travel a long way to get to. Why would anyone give up a Saturday to attend one of these events? Here are the top 10 reasons that SQL Saturday is a WIN for everyone and why you need to attend: 10. SWAG bags. Sponsors have stuff to give away. Use your SWAG bag to collect this stuff. 9. T-Shirts. If you are new to tech even...

Read More

cprice1979

MMM More Bacon - Pig User-Defined Functions (UDFs)

4/20/2013 by cprice1979  -  Comments: 0  -  Views: [3012]

Okay...okay...I know...the pig jokes are lame and getting old by now...maybe a picture of a kitten dressed like a Pig will cheer you up. Luckily this is the last of my introductory Pig posts before moving on to MapReduce. In this post we are going to spend some time creating and playing around with Pig User-Defined Functions (UDFs). We will look at what they are, how they are developed and ultimately leveraged as operators within you Pig Latin scripts. So without further ado..... What is a Pig U...

Read More

cprice1979

Moving Day!

4/17/2013 by cprice1979  -  Comments: 0  -  Views: [1326]

Wheww! What a year its been....It's been a crazy year from writing books, volunteering and speaking at events through the country (all while still managing to do my regular day job). Now that I've got a handle on things it's time to do a little housekeeping..... That being said....I am in the process of moving my blog over to WordPress. I will continue to "simul-post" my work here but will no longer spend the usual 30+ minutes per post that it takes to tweak the layout. Feel free to check out my...

Read More

cprice1979

Shakin' Bacon: Using Pig To Process Data

4/17/2013 by cprice1979  -  Comments: 0  -  Views: [17827]

In my last post (see HERE ), I introduce the Apache Pig project and showed you the equivalent of the "Hello World" demo in Pig. In this post, we are going to use the GSOD (Global Summary of the Day) station weather reports to calculate the average maximum daily temperature for each station. If you have not loaded the data, please see my previous post on Preparing and Loading data. Notes & Considerations You will need to set-up and use the PiggyBank UDFs (User Defined Functions) library. For ...

Read More

sqlchicken

Necromancing the Chicken

4/16/2013 by sqlchicken  -  Comments: 0  -  Views: [927]

First off, I’m sorry this space has been dead for so long. I’m sure I’ve dropped off many an RSS reader (as well as SQLRockstar’s Rankings ) due to inactivity. Well, it’s high time I get back on the blogging wagon! So what’s happened since the last post (YIKES!) in September? Read on after the break to find out... I Wrote A Book! Well not by myself, but I was a primary author on very major title in Microsoft SQL Server Bible 2012 . This was crazy since it was ...

Read More

pkumar3

Parsename to Extract Precision and Scale values‏ From Decimal Numbers

4/16/2013 by pkumar3  -  Comments: 0  -  Views: [1613]

Ref: From SQLSERVERCURRY The numeric datatype stores numbers with precision and scale. Suppose you want to extract only a precision or a scale, you can do it via many ways. One of the ways is to make use of the PARSENAME function. Consider the following example declare @amount decimal(12,2) set @amount=87234.50 select parsename(@amount,2) as precision, parsename(@amount,1) as scale The result is precision scale --------- -------- 87234 50 Parsename is used to extract specified part of a name. In...

Read More

pkumar3

Finding Empty Tables in SQL Server DataBase

4/16/2013 by pkumar3  -  Comments: 0  -  Views: [2666]

Here’s a simple query to find all empty tables in your SQL Server database that uses a VIEW called dm_db_partition_stats which returns page and row-count information for every partition in the current database. ;WITH EmptyRows AS ( SELECT SUM(row_count) AS [TotalRows], OBJECT_NAME(OBJECT_ID) AS TableName FROM sys.dm_db_partition_stats WHERE index_id = 0 OR index_id = 1 GROUP BY OBJECT_ID ) SELECT * FROM EmptyRows WHERE [TotalRows] = 0 OUTPUT

Read More

KathiKellenberger

Do Nonclustered Indexes Contain the Primary Key?

4/15/2013 by KathiKellenberger  -  Comments: 0  -  Views: [1431]

A very interesting question came up during my recent Training on the T’s presentation on indexes concerning the leaf level of nonclustered indexes. If the cluster key is made up of the primary key does the leaf level contain the primary key? The answer is no, it contains the cluster key. To test this, do the following: Connect to a copy of AdventureWorks2008R2 or AdventureWorks2012 and run the following code to create a table with a primary key of SalesOrderID, but a cluster key of OrderDa...

Read More

cprice1979

When Pigs Fly: An apache pig introduction

4/15/2013 by cprice1979  -  Comments: 0  -  Views: [3678]

In previous posts, we have looked at what it takes to get started with with Hadoop on Windows using HDInsight. We also looked at Hive, which is the data warehousing framework built on top of Hadoop. In this post, we will dig a little deeper into the Hadoop Ecosystem focusing in on the parallel language and runtime known as Pig. Pig, More than just bacon Pig got its start at Yahoo in 2006, originally created as a research tool intended to allow for ad-hoc queries and exploration of large semi-str...

Read More

cprice1979

Preparing Data for Hadoop

4/12/2013 by cprice1979  -  Comments: 0  -  Views: [2379]

In my next couple of blog entries, I will be focusing on PIG and then MapReduce. Before that however, I need to prepare a dataset and get it loaded in HDFS. The data that I will be working with is weather data, specifically the NOAA Global Summary of the Day (GSOD) data available for over 9,000 weather stations. GSOD data can be downloaded from the NOAA ftp site using the following address: ftp://ftp.ncdc.noaa.gov/pub/data/gsod . For this demo, I am only going to focus on a single full year's wo...

Read More

Anil

Date Range for SQL and Oracle.

4/12/2013 by Anil  -  Comments: 0  -  Views: [2480]

Hello all, This will be my memorable blog post for this year. Since, this is my last blog post for this year acc to Nepali year.We are celebrating happy new year(01/01/2070 B.S) day after tomorrow :). so, want to wish you all happy Nepali new year. This blog is related to the Date Range. While working I need to generate the date range for Oracle side date range from start date to enddate(i.e. 2010-01-01 to 2012-01-01) . Though it’s easy for me in SQL side but in oracle side I have to do so...

Read More

KathiKellenberger

Index presentation follow up

4/10/2013 by KathiKellenberger  -  Comments: 0  -  Views: [1020]

I presented on Indexes today for Pragmatic Works Training on the Ts . This is Back to Basics month, so my presentation was geared towards beginners. The video should be posted by the end of the week. Here are the slides and code . NOTE: You will need to also create a numbers table. My session went about 59 minutes, so there was not enough time to answer questions, and there were a ton of questions! Here are the questions and answers: Q: When or why should I use clustered vs. non-clustered? A: A ...

Read More

cprice1979

Being Productive with HDInsight

4/9/2013 by cprice1979  -  Comments: 0  -  Views: [1563]

This post will be the holding place where I put misc. tools and tips for HDInsight Build Tools 1. Apache ANT ( http://ant.apache.org/manual/install.html ) Extract archive to c:\ant\ then modify the classpath to include Ant: set ANT_HOME=c:\ant set PATH=%PATH%;%ANT_HOME%\bin 2. Apache IVY ( http://ant.apache.org/ivy/history/latest-milestone/install.html ) Copy Ivy.JAR to Ant lib folder 3. Git Client ( http://git-scm.com/downloads ) Data Preparation/Research Tools 1. CURL ( http://curl.haxx.se/dow...

Read More