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

Avoid Row-by-row Updates with Task Factory Update Batch Transform

1/27/2014 by KathiKellenberger  -  Comments: 0  -  Views: [4532]

SSIS is a fantastic component of SQL Server used for ETL. There are often performance challenges with SSIS packages, and many of the challenges can be solved by moving logic to the database system if possible and avoiding row by row processing. Inside the data flow, you can easily and efficiently insert data into database tables. What is more challenging, however, is doing updates or deletions. The native transform to perform these operations is called the OLE DB Command. This transform performs...

Read More

KathiKellenberger

More Thoughts about ROWS and RANGE

1/24/2014 by KathiKellenberger  -  Comments: 1  -  Views: [1189]

I have been speaking and writing a bunch lately on T-SQL window functions. There is always more to learn, it seems. Framing for many of the window functions was introduced with 2012. It is very important to understand how framing works from both a performance and logical perspective. The default frame is RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW. If you don’t specify a frame where it is supported this is what you will get. Using this default will give you worse performance than if ...

Read More

DevinKnight

Power BI Contest Entry Voting

1/20/2014 by DevinKnight  -  Comments: 0  -  Views: [1382]

You’ve watched my video (hopefully) now vote for it! In a previous post I wrote about my Power BI contest entry (Read more about it here ). I really enjoyed making this video and hopefully you enjoyed watching it. Please take a few moments and vote for my entry here. http://j.mp/1cFcLGj

Read More

CraigLove

Windows 8.1 Upgrade And SQL Server Configuration Manager

1/19/2014 by CraigLove  -  Comments: 0  -  Views: [4032]

After some hesitation I installed Windows 8.1 on my main laptop. I am familiar with the new interface and so there were no surprises in that regard. However, I was quite fond of Windows 7 and it had never failed me. Why then? Well, there were a few reasons but the main reason is that I wanted to move from Virtual Box to Hyper-V. So far, my upgrade experience has been very, very good. I was amazed at how well the laptop configurations migrated! Naturally, there are a few potential of which you sh...

Read More

pkumar3

Tabbed SSRS Report

1/18/2014 by pkumar3  -  Comments: 3  -  Views: [4146]

Creating a tabbed report in SSRS will be same as creating good UI report using HTML, JQuery etc. Even with countless properties of SSRS there is no direct way to create a tabbed report architecture containing 3-4 reports based on different tabs. I just found an example while browsing images. Requirement for such type of report are: 6 Tabs Each tab with a different report Highlight the Active Tab I tried to build a report combining different reports as desired using SSRS. If you look for this pro...

Read More

CraigLove

Deep Dive Into SSRS and Data Connection Permissions

1/16/2014 by CraigLove  -  Comments: 0  -  Views: [3631]

A couple weeks ago I ran across a problem when setting up a shared data connection for a SQL Server Reporting Services in a test environment. After beating my head against the desk for a few hours I finally solved the problem. I wanted to pass this information along because I know that someone out there is also screaming in frustration! I am concerned that once I provide some of the background details of this situation, many of you may move along. However, I want to encourage you to hang with me...

Read More

user599938

SSRS Multiselect Parameter - Dynamic Default Values

1/15/2014 by user599938  -  Comments: 0  -  Views: [2386]

Basic idea behind this post is to use the same dataset for default an available values. The Main problem is that SSRS rejects all default values in an multiselect parameter if only one value isn't in the list of default values. Because of that simply using a statement like this is not possible because "null" doesn't exist within the available values: select Projekt, case when Projekt like 'LT%' then Projekt else null end as ProjektDefault from ... Fortunately the default values don't have to be ...

Read More

SMcDonald

Execute a SSRS subscription based on new records in a table

1/15/2014 by SMcDonald  -  Comments: 0  -  Views: [1746]

As many developers state in their blogs, "this is one way of several ways to handle a task/request". In the below example I am going to demonstrate how you can have a report execute based on new records being found in a table. The instructions provided below assume you have some experience navigating around BIDS. I am using SQL Server 2012 and the data source is AdventureWorksDW2008R2 database. In the first execute sql task, I am going to create a table and load sample data in it by using an exe...

Read More

KathiKellenberger

T-SQL Tuesday #50: Automation

1/14/2014 by KathiKellenberger  -  Comments: 0  -  Views: [1118]

This month’s T-SQL Tuesday is about automation and have methods stayed the same or changed. I haven’t had a chance to automate much recently, but back in the day when I was a database administrator at one company, automation was my favorite part of the job. When would I decide to automate something? Usually, about the third time I performed a task, I would decide to automate it if I had the time. Writing a script to automate a task takes time. Generally more time is taken to write an...

Read More

DevinKnight

Power BI Contest Entry

1/8/2014 by DevinKnight  -  Comments: 1  -  Views: [1474]

Today I submitted my Power BI contest entry and I’d love for you to take a look! Here’s a short description of entry and the video itself: In this submission I have used Power BI to help me plan a vacation with my wife. We both love thrill rides so I wanted to make the best decision on planning our next trip. Using Power Query I imported data from the web to find all possible roller coasters and amusement parks. I then took that raw data and made relationships and calculations using ...

Read More

nzaharony

What Real Users Are Saying About BI

1/2/2014 by nzaharony  -  Comments: 0  -  Views: [2247]

Choosing the best business intelligence vendor for your company can be a confusing process. The marketing messages of BI and big data vendors often sound alike and claim to offer everything to everyone. We created IT Central Station to offer the end user community a vendor-neutral site where real users write reviews of the BI tools and other enterprise software they use. It's like Yelp or TripAdvisor for the enterprise, but all reviewers are strictly validated to ensure that each review is authe...

Read More

KathiKellenberger

What's in a Name?

12/31/2013 by KathiKellenberger  -  Comments: 1  -  Views: [737]

As you probably know, the next release of SQL Server will be out sometime in 2014 and will be named SQL Server 2014. This is only two years after the last release, SQL Server 2012. I have been presenting on 2012 topics since before it was released. I generally ask the audience if they are using SQL Server 2012, and very few are actually using it in production. When they learn about the new T-SQL features and AlwaysOn Availability Groups from the presentations, hopefully, that knowledge helps the...

Read More

KathiKellenberger

Setting goals for 2014

12/21/2013 by KathiKellenberger  -  Comments: 1  -  Views: [1267]

It’s that time of the year when you start to take stock of the year and maybe even your life. The New Year is a chance for a new beginning, a time to set or rethink your professional and personal goals. What are the things that you would like to accomplish over the next one to five years? Are you interested in gaining skills in a new area for you, such as virtualization, cloud computing or big data? Will certifications help you get a new job or advance in your current one? Do you want to g...

Read More

DevinKnight

Power BI Q&A Preview Now Live On Your Data

12/18/2013 by DevinKnight  -  Comments: 0  -  Views: [2899]

With the recent updates to the Power BI preview and Q&A features added I thought I would do a quick tutorial of how it all works. This post will walk you through uploading a workbook to Power BI, Using Q&A against that workbook, enhancing the workbook with synonyms and the creating features questions. First, sign up for a trial at www.PowerBI.com . Once your trial Power BI site has been issued to you login and add your own Power Pivot workbook by selecting Add as shown below. After you a...

Read More

KathiKellenberger

Why Working for Pragmatic Works is Perfect for Me

12/14/2013 by KathiKellenberger  -  Comments: 2  -  Views: [1581]

This week was a different kind of week for me. Instead of working for my customer, I taught an SSRS class virtually. The class lasted four days, and I ended up taking a vacation day yesterday. It was nice to get a break from working for a day since I feel like I have been going nonstop since PASS Summit. The only thing I had planned was to visit the law firm where I had been a DBA for eight years and have lunch with some of my former co-workers. In many ways, things are the same there, but some ...

Read More

DevinKnight

Using Power Query to Parse your Inbox

12/13/2013 by DevinKnight  -  Comments: 0  -  Views: [6679]

One of the nice new features that was added to Power Query with the latest update in December is the ability to connect to Microsoft Exchange as a data source. You can download this update now here: http://www.microsoft.com/en-ca/download/details.aspx?id=39933 Here’s a quick demonstration of how you may use the Microsoft Exchange data source in a Power BI solution: After downloading and installing Power Query launch Excel and navigate to the Power Query tab. If you don’t see the Powe...

Read More

DevinKnight

Thoughts on December 2013 Power Query Updates

12/11/2013 by DevinKnight  -  Comments: 0  -  Views: [1772]

Just in time for Christmas the Microsoft product teams responsible for Power BI have a slew of amazing updates. The list of updates can be found here but for my notes specifically on Power Query updates continue reading! Power Query Power Query now has 3 new data sources that you can connect to. Connectors have now been added for Sybase IQ, Exchange and Dynamics CRM Online. Sybase IQ is the column-store database technology produced by SAP and is used for many organizations for BI solutions. This...

Read More

KathiKellenberger

Framing: ROWS vs. RANGE

12/6/2013 by KathiKellenberger  -  Comments: 0  -  Views: [1431]

I have spent a lot of time with Window function this year. I have found that many people haven’t heard about all the features introduced with 2005, or if they have, don’t know the details to get the most out of using them. That led me to creating a session on Window functions and presenting it at many SQL Saturday events, user groups, and PASS Summit 2013 as well as writing many blog posts. I have found that this topic is like an onion, and I keep peeling off layers and learning more...

Read More

McMike

Pragmatic Works Task Factory Licensing Practices

12/3/2013 by McMike  -  Comments: 0  -  Views: [3161]

I often speak with individuals trying to figure out how many licenses of Task Factory (from Pragmatic Works) they will need between their development, testing, and production environments. It’s not a Rubik’s cube, but it can get confusing the bigger your structure is. The simple answer is: “You do not need a license for development, but you do for your servers”, however , the term “development” can be very different from one structure or company to the next. D...

Read More

KathiKellenberger

Running Total with T-SQL 2012

11/27/2013 by KathiKellenberger  -  Comments: 1  -  Views: [3981]

Writing a T-SQL statement that calculates a running total is really easy with SQL Server 2012. But, if you are not careful, you will see less than stellar performance. Back in 2005, Microsoft began adding window functions to T-SQL. I’ve also seen this called windowed or windowing functions. Either way, this has nothing to do with the Windows operating system. If you have used ROW_NUMBER(), you are using a window function. The window is the set of rows that the function operates on. The win...

Read More

KathiKellenberger

T-SQL 2012 Features

11/27/2013 by KathiKellenberger  -  Comments: 1  -  Views: [1571]

I've written a number of posts recently about the new T-SQL features. I thought it would be helpful for you to have a list with links to each one. You may also be interested in a Training on the T's webinar I did a couple of months ago where I demonstrated several of the features. Using First_Value and Last_value Percentile_Cont and Percentile_Disc Paging Percent_Rank and Cume_Dist Lag and Last Using the Sequence Object Enjoy!

Read More

BesimI

Another approach to Time Intelligence

11/25/2013 by BesimI  -  Comments: 0  -  Views: [2125]

Best Parctices for Time Scale solution This is an original method that I use when I build SSAS Cubes and it is time to share it with you Time Intelligence is a common issue for every OLAP structure because Time as dimension apperars in every OLAP project, in every Cube you build, despite business model or use. To handle Time Intelligence good in calculations, aggregations and optimization, you need to use Timescale as well. With Timescale I mean: MonthToDate (MTD), YearToDate (YTD), LastYear(LY)...

Read More

anykolaiszyn

How to Give your Boss a Headache - an Introduction to Dashboard & Report Design

11/22/2013 by anykolaiszyn  -  Comments: 1  -  Views: [6713]

Hello. Please enjoy my presentation from SQL Saturday #248 Tampa BI If you have any questions please feel free to reach out ot me. Thanks!

Read More

TMMichau

Rapid Problem Solving with Post-It Notes

11/19/2013 by TMMichau  -  Comments: 0  -  Views: [3778]

I am always looking for better ways to be organized. Despite what some people might think I am very organized….in my own way, as most people are. I was reading this book called “Rapid Problem Solving with Post-It Notes” by David Straker. Now I am a huge fan of Post it notes, large ones, lined ones, cute ones, bright ones, and I try to be organized about them all. For instance the cute one’s I usually use for personal notes to self. Bright ones are priority notes and let ...

Read More

KathiKellenberger

Presentation Tips from Aunt Kathi

11/19/2013 by KathiKellenberger  -  Comments: 0  -  Views: [1908]

I recently presented on T-SQL window functions at the PASS Summit in Charlotte . Just getting accepted to speak at Summit is a big deal. There are a limited number of slots for community sessions, and potential speakers submit many more abstracts than are possible to accommodate. Selecting the speakers and sessions is a tough job. How do I know that? I was on the Program Committee for five years, two of those as manager. Once I was selected back in May, I made sure I had as many opportunities to...

Read More