Ha ha ha ha ha ha ah ha ha ha ha ha ha ha ? Deafening burst of wild laughter, authentic jerseys wholesale suddenly the air temperature dips, the laughter came from all directions, Ruonan if female, very harsh. "Well you bone demon, so many ghosts have been revised to swallow you, you are so evil, spirits outrage ah." "Well, yin and yang devil, less loaded, and to come on quickly, do not you done a good thing?" The old man said calmly, do not know is looking slightly to the yin and yang ghost deg...
Read More
Over the last three blog post we have walked through setting up, building and then using the knowledge discovery process to train our demo knowledge base. In this blog post we will actually put our knowledge base to use by using it to do data cleansing. We will look at two ways DQS can perform the cleansing task. The first is through a Data Quality Project within the Data Quality Client and the second is through the DQS Cleansing transform available in SSIS on SQL Server 2012. If you need a reca...
Process Default This processes the object based on what has not yet been processed. This is efficient especially in large environments. Process Full Process full drops what is existing and then process the cube and loads the data. Process Incremental Processes new fact data only. Process Index Creates or rebuilds indexes and aggregations. Unprocess Drops the data and does not reload it. Process Structure Processes the cubes dimensions and then only cube definitions. On a mining str...
I have been quiet over the past year trying to get acclimated to my new job and my new found work life balance. Now that I have figured it all out I am slowly beginning to present on a regular basis. Next Wednesday (2/8/2012) I have the opportunity to give a short talk on SQL Server 2012 AlwaysOn to the Baton Rouge SQL Server and .Net Users group. If you are in and around the area please join me. While I only have 15 minutes to talk, I promise a great presentation. I may run over just a little t...
Dynamic Management Views are a very powerful tool that are part of Analysis Services in 2008 and 2008 R2. They give you the ability to monitor Analysis Services usage and metadata. MSDN articles on SSAS DMVs – http://msdn.microsoft.com/en-us/library/ms126079.aspx Good post on using SSAS DMVs – http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/ A report developer could leverage the capability to read Analysis Services metadata to build a report that can dynamicall...
Did you know that BIxPress has 2 features that ease package deployment? I covered the first option a couple of weeks ago and that was the BIxPress Quick Deploy feature. Visit my other blog if you want to learn more about that feature. Today’s blog is going to focus on the other BIxPress option which uses the SSIS Deployment Wizard. Now this feature has a few more steps than the Quick Deploy option however you have a few more features you can take advantage of as well. Let’s take a lo...
Don’t you hate it when you’re troubleshooting a package and you have to hunt around for a configuration or an expression? Well BIxPress has solved this issue and this is by far one of my favorite features of BIxPress. Let me tell you how much of a timesaver this is and how easy it is to just glance at your package and be able to identify which items are dynamic. Once you have BIxPress installed it automatically highlights all expressions/configurations with either a red or blue icon ...
Hello all, After such a long time , I would like to post some another blog which might be helpful to the one who works in SQL. Sometimes we might need to delete the particular row from a table in SQL Database. While working someone might mistakenly insert the duplicate same data multiple times within a table that might contains a huge amount of data and after populating that table .He/she wants to delete that duplicate data inserted from a table. So, for this we might drop and recreate the table...
Do you need to develop your SSIS packages faster? If the answer to that question is yes then here’s another reason to use BIxPress. BIxPress has a lot of features that can help speed up development that we have covered over the last couple of weeks. Today we will take a look at one of the most useful in my opinion and that’s the Package Builder and its available templates. The templates are time savers because you will not have to re-create the wheel each time you have packages that ...
Recently I was conducting an unscheduled demonstration of PowerPivot and had one of those uh-oh moments. After I extolling the virtues of this cool tool, I launched Excel and clicked the PowerPivot Window button. I could almost hear the sad trombones playing "Wah Wah Waaaahhh...." as a command window popped up with a message similar to "Unable to open file ... Files\Microsoft Analysis Services\AS OLEDB\10\FlightRecorderCurrent.trc". Ah, the joys of unscheduled/unrehearsed demonstrations! "Not a ...
Whats New BI-wise This is going to be the page I update when I have quick links and blurbs related to business intelligence that I'd like to share. Put your email in the widget at the very bottom if you'd like to be notified when the content changes. BI from g8rpal on 8tracks . ------------------------------------------------------------------------------- 1/27/2012 Links Career of the Future: Data Scientist Learn to Code, Get a Job! The Rise of Developeronomics Using the MERGE statement in SSIS...
In my last post " Building Out a DQS Knowledge Base " we set-up and configured a DQS knowledge base. In this post we are going to explore the DQS knowledge discovery process. Before we get started let's recap our demo scenario. We are working with set of data that contains all MLB and NFL teams, the league they play in, their stadium names and capacities. Our knowledge base was built using a domain for each data element (Team, League, Stadium, Capacity). We also constructed a composite domain to...
Do you know what Notification Framework is? The primary objective for notification framework is to alert you about certain events in your SSIS package. This notification framework will alert you through email and/or SMS if your package fails along with details to help you troubleshoot the issue. As with all the other features included with BIxPress this is a very simple process and something most developers shouldn’t live without. Let’s explore this feature and I will show you how to...
In a previous post I wrote about how you can use embedded custom code to extend the capabilities of Reporting Services. This week I will show you another method of using custom code but this time with external assemblies. Ideally when using custom code you would choose to do so using external assemblies. External assemblies help developers manage code from outside Reporting Services and share the exact same code across multiple report. Here’s a few of the pros and cons of using external as...
Recently I had the pleasure of pulling in a flat file encoded in UTF-8 format into a SQL Server 2008 table using SSIS. I'd like to share my experience in the hopes that it will help someone else with a similar issue. It might also help me in the event I come across the situation again and forget how to get past it. The first indication of a problem was the following error message: The data conversion for column "Column 37" returned status value 4 and status text "Text was truncated or one or mor...
Whether you consider these to be the same or list that they are technically different there is still a valid discussion of why you should use one verses the other. It?s a trick question! The precision and scale will produce the same results no matter what the data entered. I entered data with the same precision and scale but changed the data on each row. Take a look at the insert statement. I swamped the insert statement and played with all sorts of numbers. Even if I ...
In my last post " Getting Started with Data Quality Services ", we walked through installing the DQS client and server and briefly discussed important DQS concepts. In this blog post, we will take the next steps by building out a knowledge base. More specifically this post will focus on creating domains, establishing business rules to validate those domains and then creating composite domains to allow for cross-domain validation. We will follow-up in subsequent posts by training our knowledge ba...
If I had a nickel for every time I've heard from a business user that the OLAP solution must support current real time data from the source system, I'd have at least half a dollar. The fact is that in reality there is usually some acceptable degree of latency. Even though Microsoft SQL Server Analysis Services has a ROLAP storage mode option, I've typically tried to steer people towards the MOLAP option due to it's query performance superiority. This past week I've had the opportunity to explore...
Today, one of my team members faced an issue that I was not able to give the answer right away. The problem was, in SSMS while he was connected to DEV JOBs, he couldnt edit steps, as image below: First we started for privileges/permissions issue. But that was not the problem. After checking his SS version we got the problem: select @@version Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6...
Today we’re going to take a look at the real time package monitoring feature of BIxPress. The real time monitoring feature of BIxPress will allow you to monitor current or past packages that have been executed on your company’s server. As you can see from the below images it looks just like it does in bids when your developing your SSIS packages. From this monitoring console you can watch a single or multiple packages as they run on the server. This feature can be very useful when tr...
Don’t you hate it when you create that variable in your SSIS package under the wrong scope? Well fret no more because as you have already guessed it BIxPress can handle this. This is just 1 more feature where BixPress can save you time when developing your packages. Below I will show you how you can easily change the scope of your variable without having to delete it. The first thing you need to do is select the first of the 4 different BIxPress variable options from the tool bar. This wil...
Inspired by common emails and questions I see, I figured I’d do a series of blog posts on common mistakes folks make with SQL Server called Monday Morning Mistakes (or #sqlM3 for short, since we all love quick hashtags these days). These are meant as quick fixes, nothing too comprehensive. Also since I just made up a hashtag, feel free to share your own #sqlM3 tips on Twitter anytime! Without further ado… Today’s quick issue: Can connect to SQL Server locally but can’t c...
« 1 | 2 |3 » This is the 3rd and final post about BULK INSERT. In this one I want to show you how to bulk insert a file into a table with an identity column. Here is the script to create table: CREATE TABLE [dbo].[Users] ( [UserID] int IDENTITY(1,1), [FirstName] [varchar](10) NULL, [LastName] [varchar](10) NULL, [Country] [varchar](20) NULL ) ON [PRIMARY] I want to insert a csv file without mapping UserID, since it is an identity column. File format is shown below: When trying to run...
« 1 |2| 3 » In my previous post I've shown how to bulk insert a csv file through T-SQL. In that example I've used the same structure to both csv file and destination table. In this post I'll show you how to bulk insert a file wich struture differs from destination table. For this example, I'll take the same destination table: CREATE TABLE [dbo].[Users] ( [UserID] int NULL, [FirstName] [varchar](10) NULL, [LastName] [varchar](10) NULL, [Country] [varchar](20) NULL ) ON [PRIMARY] From ...
« 1| 2 | 3 » Recently, there was a post where the user found himself in a problem when loading data utilizing BULK INSERT This post is the first from a series, wich I want to explain how to use BULK INSERT in multiple possible ways. BULK INSERT - as mentioned in BOL , BULK INSERT "Imports a data file into a database table or view in a user-specified format in SQL Server 2008 R2. Use this statement to efficiently transfer data between SQL Server and heterogeneous data sources." Notice...