StringFormat {"0"} ? One of the formating option which is very common with grid views while populating data into columns 0 indicating getting data from the first coloumn of the datasource 1 indicating getting data from the second column of the datasource 2 indicating getting data fromthe thrid column of the datasource and so on we can also add symbols next to it such a c for getting the currency p for getting the pecentage d for getting decimal e for exponential and so o
Read More
Hate to post this late but just wanted to let everyone know I'll be presenting for Brazil's Worldwide Online Tech Day tomorrow, Saturday October 30th. I'll be presenting on Policy-Based Management and my session runs at 6pm EDT. Listed below is the link schedule of events. This event will have all sorts of cool stuff such as Silverlight, PowerShell, SQL Server, Professional Development, SSIS, SharePoint, Business Intelligence and more! Hope you can join us! Schedule of events , with timezone con...
We all know about the Control Flow tasks for the three containers (For Loop Container, Foreach Loop Container and Sequence Container): Are you aware that there is a 4th container that you can't see in the list of tasks? It is called the Grouping Container. What you see below is some script tasks that I have pulled out to my control flow. If you would like to put them into a Grouping Container, all you would have to do is highlight those tasks: Then Right Click and select Group. This is great for...
Brian K. McDonald SQLBIGeek Twitter: @briankmcdonald Welcome to the second post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am hoping that I can provide some of the details about functions that I have either found on the internet or something that I had to create to meet a need. If it is something that I come across, I will attempt to make it shorter and/or perform better. If it is something I wrote, it is just something to share with you! J Either way, I hope that you enj...
This week's MDX puzzle had two keys for getting the correct answer: the Ancestor function and the .Name property. To refresh, here was the puzzle: Rows: Adventure Works Products Columns: The Category each Product belongs to The Subcategory each Product belongs to Filters: None So here is how I used the Ancestor function to get the Category and Sub-Category for each Product: I created two query scoped calculated members. You can tell they are query scope because of the WITH MEMBER . A query scope...
As your database grows in size, Analysis Services cubes that use that database grow along with it. As such, one thing that can improve performance of your cube is partitioning (splitting up) your measures. In this post, I am going to quickly show you how to switch from a table binding partition (default) to a query binding partition using a cube that I have built off of the AdventureWorksDW2008R2 database. In the end, you’ll know how to split your large measure groups into smaller chunks of data...
Today while working on a Page , I ran into this thought of how many people misunderstand with the word between Desining and Developing People often take Designing to be same as Development .. but this is really odd .. Let me just point out some major differences we find when working on in WEB DESIGNING: This part is what you see , its all about a)Look and Feel: This area takes into picture all the visual aspects of the website. It when you say www.bidn.com, you see how it looks like , the colors...
Recently I got this error while installing SQL Server 2005 64 bit on a machine where previously SQL Server 2005 32 bit was installed: 1. Open Administrative Tools \ Component Services 2. Go to Component Services\Computers\My Computer\COM+ Applications 3. Delete Microsoft.SqlServer.MSMQTask Full credit to Vivek Thakur at codeasp.net for his orginal blog post : http://codeasp.net/blogs/vivek_iit/microsoft-net/440/sql-server-install-error-one-or-more-of-the-components-being-installed-are-already-re...
Today I ran into a small problem when trying to deploy my SSIS packages to a QA server. I chose to use the deployment utility in BIDS to move my packages, but when I hit "Build" to create the deployment manifest, I was getting a "Build failed" message at the bottom left hand corner of my screen, but no helpful error messages to help find out why the build failed. It turns out the solution was pretty simple. The .dtsx file for one of the packages was removed from the file system, but the package ...
I have been meaning to write this for a while, but i wanted to wait for a break in SQLDrama. (i.e. NomCom elections, PASS Summit Selections, Patrick’s Ego being but away for good and other important events). I have notices a swell in the SQL Community in the last few years and it’s fills me with tremendous pride to be a part of such a brother and sisterhood of folks who are so focused on growing each other, themselves, and the products the use every day. I love the fact that we can constructivel...
Ok so I know this is late, but I wanted to thank Jack, Andy and the team at the Orlando SQL Server User Group for their efforts in pulling this together. As usual it was a great event. I got the chance to try out a new presentation on Dashboarding which I think was well received. (Everyone I paid to clap did so dutifully and keeps their 5 dollars). I’m running SharePoint locally on my workstation and while there are some limitations, it’s a method you want to explore so i am posting the link to ...
I don’t mean a LaRock aka SQLRockstar, but an actual rock. I was at dinner last week after our all day session at SSWUG’s Fall Vconference. Some of the great folks in Tucson were nice enough to come out and let Patrick (@PatrickDBA) and I feel like we had groupies.. Riiiight . They informed us that this was the first time they had heard of SQL Saturday. I know if you’re reading this you’ve heard of this event. It so great and an incredible service from your local chapters, PASS and local volunte...
For those of you who have seen our team present, we always do our best to make it really informative, drive value and give you something you can leave with and immediately use without a lot of fuss and muss. Well there is some exciting news. We are up for a possible PreCon at the SQLRally event that is being held in Orlando next year. There is some stiff competition, but with all due respect to those who are also up for selection in the BI Session category, our session will cover more, be more e...
Hey Gang, Sorry for the absence. I have been offline for a bit dealing with some family stuff. All if good now and I’m back in the saddle. So What better way to get going than with another on of our motivational Monday series’. Today’s lesson comes from our friends the Anti Tank Dogs. For those of you familiar with my puppy/child you will know that I would rip that tank apart before letting it near my pup, but this dog is determined to get this tank and bring it down. Tenacity is admirable, but ...
Pre Conference seminar voting is up now here: Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 http://www.zoomerang.com/Survey/WEB22BD59JCQBT Go make it happen! There's a lot of good seminars that you can ready here: Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 BI Sessions: http://www.sqlpass.org/sqlrally/2011/PreConsforVotingBI.aspx DBA Sessions: http://www.sqlpass.org/sqlrally/2011/PreConsforVotingDba.aspx Developer Sessions: http://www.sql...
I discovered this issue the other day while creating a report from a cube. I used the query designer to build a report with a few parameters. The query designer did a great job of building the MDX for me but the client wanted something a little bit more custom with one of their parameters than what the designer could handle. After I made the changes to the MDX the report was working fine as requested. I went back a made a small change to the original dataset and all of a sudden my report had sto...
Microsoft and Pragmatic Works would like to invite you to a special, two-day workshop on SQL Server Analysis Services taught by SQL Server MVP Brian Knight . Houston, TX November 16 & 17 8:00 a.m. to 5:00 p.m. (Lunch included) Microsoft Office One Briar Lake Plaza 2000 W. Sam Houston Pkwy, Suite 350 Houston, TX 73609 Register Here! Dallas, TX November 18 & 19 8:00 a.m. to 5:00 p.m. (Lunch included) Microsoft Office 7000 Highway 161 Irving, TX 75039 Register Here! SSAS Topics Covered: Dim...
How to Annoy a Developer One of the key things which will quickly create havoc for developers is when a basic feature is taken (usually with the intent of making it unique with a “new” feature) and mangled beyond all logical use. It now no longer serves the purpose of its original need. I have found this to be very common in many API’s today. An over complication, or a misdirection of a simple task when it should be simple. What has happen to the understanding that the simplest possible solution...
This is just a quick note to remind everyone I'll be presenting tomorrow, Tuesday October 26th 2010 for the PragmaticWorks Free Monthly Webinar Series . The topic (big surprise here) is Policy-Based Management! The webinar runs from 11:00 AM - 12:00 PM EDT and you can register for free here . Hope to see you all there!
So today I start posting the weekly MDX puzzles I mentioned last week . And like I had also mentioned, each correct answer to an MDX puzzle will get you an entry into the end of the month drawing for a prize. What will that prize be? Well at this point, I still haven't decided since the only suggestions I got were things like a camaro (really, Adam?). But I'll come up with something at some point. Also, since we're starting the MDX puzzles with just a few days left at the end of the month, we'll...
Why the if( isValid == true )? The sample code snippet below is very common, but why? bool isValid = false; if( isValid == true ) { // Do some processing... } else { // Do some other processing... } Understand that because of the type of the variable, there is no need for the "== true" or "== false" comparison. As the evaluation of the "if" must resolve to a boolean result and in conjunction with the value of boolean variable the runtime will route the execution to the appropriate conditional bl...
Okay SQL Community, I need your help! Patrick Leblanc , Adam Jorgensen , Devin Knight and myself have submitted a precon for the exciting new event SQL Rally , which will be from May 11 - 13 in Orlando, FL. This event new event is designed to bridge the gap between the yearly PASS summit and SQL Saturday's. The Precon we've submitted is a Full Day Business Intelligence Workshop designed to get you from beginning to end in the Microsoft Business Intelligence while building a complete Data Warehou...
Brian K. McDonald SQLBIGeek Twitter: @briankmcdonald Welcome to the first of my “SQLBIGeek’s Function Friday” blog series. I understand that I am posting it on Sunday for this first post, rather than Friday. However, going forward I am going to post a new function each Friday. Whether it be cleaning up an old function that I have come across (written by others or myself J ) or it is just something that I have written lately. Either way, I hope that you enjoy the series and that you can get some ...
Okay SQL Community, I need your help! Patrick Leblanc , Adam Jorgensen , Mike Davis and myself have submitted a precon for the exciting new event SQL Rally , which will be from May 11 - 13 in Orlando, FL. This event new event is designed to bridge the gap between the yearly PASS summit and SQL Saturday's. The Precon we've submitted is a Full Day Business Intelligence Workshop designed to get you from beginning to end in the Microsoft Business Intelligence while building a complete Data Warehouse...
So you've got some data that needs to be a bit more normalized. Your data may look like this (This is from DimCustomer in the AdventureWorksDW database): Select CustomerKey, EnglishEducation, SpanishEducation, FrenchEducation From DimCustomer But what you'd really like is to have a single column that lists the Education for each CustomerKey. To do this you can use the T-SQL Unpivot command, which will allow you flip multiple columns into multiple rows with a single column. In this case, I have a...