Yesterday I had a requirement to compare formulas between two sheets. So I wanted to print the formulas and compare. This is a basic feature but I straight away did not know how to do it. So I started investigating the ribbon in Excel 2007. After about 2-3 minutes Voila I found this. Under Formulas Tab -- There was Show Formulas button in the Formulas Auditing Group as shown below. This button works as a toggle for showing and hiding the formulas.
Read More
Join me tomorrow for a little CDC. #47-Introduction to Change Data Capture Speaker: Patrick LeBlanc Add To Outlook: Add To Calendar Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=269DRP&role=attend Date and Time: 2/1/2011 11:30:00 AM CST BIO: Patrick LeBlanc, SQL Server MVP, is currently a Business Intelligence Architect for Pragmatic Works. He has worked as a SQL Server DBA for the past 9 years. His experience includes working in the Educational, Advertising, Mortgage, Medic...
All, ** 2/6/2011 updated link below ** Since SQL Server Reporting Services 2005 came out, I have been working very close within the BIDS environment and every other aspect of Reporting Services to include the architecture. With the many changes that we saw between 2005 and 2008 R2, I have compiled a boot camp style presentation and have delivered it many times to completely filled (and some even hanging out along the sides, backs and the doorways of many) SQL Server community events. I have poli...
SQL Rally Voting for BI Starts Today and ends on the 6 th of February. This year Patrick LeBlanc and I have teamed up and have submitted an abstract for the coming SQL rally in Orlando. Please review all of the submitted abstracts and vote on your favorite for each session. Keep a look out because you will see a lot of submitted sessions by Pragmatic Works. Check out the links to vote and review all of the abstracts. Review the abstracts http://www.zoomerang.com/Survey/WEB22BSZ9DTT5W/ Here’s a s...
Have you guys ever felt like pulling your hair, just because you aren’t able to figure out what’s wrong with your long long and longer code? Where the logic keeps flowing like a river though your project.. Well this is what happened to me.. Seem to be lost to find out what went wrong with the code, when suddenly there was a page not found error occurring after I click on a search button in PW site. For someone who is very new, I would say just keep learning from your seniors and keep googling. I...
Let me start of by saying I could have taken this picture in Florida. But I didn’t. I was in Alabama. Folks – we’re not helping our stereotype here in the south. In the meantime I was working with a cool client who is delivering BI as part of their application. I had found Birmingham to be a cool city with some really neat parts. Mostly the really nice lobby of the Hilton I stay in and the rental car facilities . I know some of you have wondered why I’m behind on posting comments and have only d...
Hey Everyone – SQL Rally Voting opens today for the BI Track. There are lots of good sessions and at the risk of being self promotional I thought I would share that my Summit spotlight Zero to Cube session was top five in it’s track and the 23rd session overall at the summit. IT is a LOT of fun and the way I present it is like NOTHING you’ve ever seen!. We’ll have some real fun. Here are some real comment from folks who attended my session at the Summit: “Best Session at the Summit So Far” (Seco...
Hey folks. I think we can all agree that there is some really quality trai ning available for free on the web for SQL Server. Many of you take advantage of this but I still get to many clients who have no idea what is out there. This includes even such staples as who Paul Randal is or that youtube has over 5000 videos tagged SQL Server. So there are tons of sites to go get information to invest in yourself. I think this guy would agree you’re long over due. There are also SQL Saturday’s nd other...
They say to save the best for last and while I’m not so sure about that I was truly honored to be awarded as a SQL Server MVP from Microsoft for 2011. I know many in the community who are deserving and did not get this honor and all I can do is remind you that you’re not doing it to get a blue square, you’re doing it because you want to do the things you do for the community. I’m very excited about the opportunities this will give me for more access and exciting Non-NDA things to share with what...
In SSIS you might have occasion like I did to do a Lookup that needs to match data of different types. Here is the error you may get when you try to map the lookup column. There are a couple of ways you can fix this. One possibility is to convert the data by using the Data Conversion Transformation. The other way is to use CAST in your SQL query for the Lookup (assuming you are using the Best Practice of a SQL query).
With 2011, I am keeping track of what training I participated in that was provided by the SQL Server Professional Community, whether it’s in person or via the web. This is mainly a personal log but I figure after a few months and even by the end of 2011, this will amount to a lot. Now, by all means, this does not mean I am an instant expert on the topics below. No way, no how. But at the least, I can refer to this list and the forthcoming lists in the month ahead, and see where I can go to for m...
Two weeks later, and this will probably my last post on SQL Saturday #62 from Tampa, Florida , held on Saturday, January 15, 2011 . My past two posts specifically on this weekend are listed below: SQL Saturday #62 Shout Outs!!! SQL Saturday #62 - Day of BI PreCon - The Aftermath!!! Today, I am going to share the notes from the three middle sessions I attended where I actually took notes. No offense to Session 5 and 6’s “SQL Smackdown” and “Iron Chef SQL Server” , but those I made sure to enjoy a...
Hello to all, Well once again I am interested to write a new blog post and thinking on which topic I should write on then I suddenly came up with my mind regarding this Topic. Also , this may be simply for one but for someone it will be helpful for those who don't know how to do it. while working ,I build a SSIS package by using BIDS and we can easily execute it from BIDS project but all I want to do it from the the SQL query from SSMS coz I dont want to open the BIDS and execute the package man...
So you don’t have anything to do this Saturday. Well, if you have an insatiable thirst for SQL knowledge like me, come out to SQL Saturday #57 Houston . I will be presenting two sessions: SSIS: Tuning, Configuring and Deploying SSRS: What’s new in R2 This is going to be a great event with several great sessions. See you there! Talk to you soon Patrick LeBlanc, MVP, MCTS Founder www.sqllunch.com
There are a few tasks that I find myself using all the time when I’m on a project using MS Visual SourceSafe. I discovered that you can add buttons to your BIDS environment to suit your needs. Simply right click in a blank area on the menu and select Source Control. This will add all the buttons for Source Control. Then you can click on the drop down button and remove items you don’t want cluttering up your environment. The four I use all the time are Check In, Undo Check Out, Refresh Status, an...
My fellow SQL Server and IT Professionals!... I have a dream… Do you aspire to be a CIO one day?... Do you aspire to lead your own IT division or company?... If so, I recommend checking out CIO ( LinkedIn | Facebook | Twitter ). I myself am subscribed to their CIO Insider , CIO Leader , CIO News Watch , and CIO Strategy and Innovation emails. Sure, I am not a CIO, and I am probably a bit far from it, but the emails offer links to articles from an executive IT perspective. It’s a free subscriptio...
The SQL Lunch and SQL University have combined forces. Come and watch, laugh, and learn. #48-SSIS Tips&Tricks (Advanced SSIS) Speaker: Josef Richberg Add To Outlook: Add To Calendar Date and Time: 1/28/2011 11:30:00 AM CST BIO: A SQL practitioner for over 17 years specializing in performance & tuning. I currently work for Harpercollins Publishers designing, enhancing, and improving, the sql experience for many of the data warehouse applications. I have been heavily involved in designing ...
Here's how I've created a 'green-bar' style cross-tab/matrix report. I'm basing the new report on this one: 1) Create an inner row grouping, in this case named 'Count' and given a grouping expression of =1 2) for the cell 'Count', set the property Value =iif(RunningValue(Fields!REFERENCE.Value, CountDistinct , Nothing ) Mod 2, "PowderBlue" , "White" ) 3) for the cell 'Count', set the property BackgroundColor =value 4) for the matrix data cell, named 'STATUS', set the property BackgroundColor =Re...
Discretization (one of my favorite tech words to say J ) is a really great feature of Analysis Services that is often forgotten. Basically what discretization does is it can take a dimension attribute and automatically place its members in buckets for you. For example, if you have a product dimension that has an attribute for price you could create buckets for price instead of listing every distinct value. To set this property you select the attribute to configure and open the properties menu. T...
I tweeted this earlier, but figure I share here, too. (corrected the image) Trust me, I saw a lot of red before getting the all green. Rookie mistakes, but stuff to learn from! My two and half cents... Jason E Bacani, MBA Software Applications / SQL Server Developer JasonBacani@Yahoo.com | Jason.E.Bacani@GMail.com LinkedIn.com/in/JasonEBacani | BIDN.com/blogs/JEBacaniSQLDude | Twitter.com/JEBacaniSQLDude
The 24 Hours of Pass sessions for March 2011 have been announced. Here is an extract from the site. Hear from SQL Server and BI experts such as Jen McCown , Karen Lopez , Michelle Ufford , Wendy Patrick and Cindy Gross , just to name a few! Check out the great sessions in store and be sure to save the dates. Online registration will open soon; visit the 24 Hours of PASS website often for information updates. Here is a list of the sessions in the BI Track, DBA Track and Dev Track. Can't wait to r...
Hello Bidn, Below I’m going to show you a few quick examples of how to use the Switch function within SSRS expressions. In the first example we will change the font color based on the quantity of units sold. Green will be a quantity of 20,000 +, Black will be a quantity of 10,000 +, and everything less than 10,000 will be displayed as Red. To do something like this go to the properties of the selected cell in the table and then go to Font/Color. On the drop down list for color, choose expression...
#46-SQL Azure – Cloud Database Coolness Don't miss this lunch. Speaker: Scott Klein Add To Outlook: Add To Calendar Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=3BGZJG&role=attend Date and Time: 1/26/2011 11:30:00 AM CST BIO: Scott Klein is co-founder of Blue Syntax Consulting, a company that specializes in Azure training and consulting. Scott is also a veteran author, having written a number of books including Professional SQL Server XML, Professional LINQ, Pro ADO.NET Ent...
What is the Entity Framework? The entity framework is an object relational mapper. What is that? Well it provides an abstraction with database development. By pretty much automatically handling database calls and object persistence without the developer having to worry about the details. By generating both the objects and handling persistence it takes a tremendous load off the developer. But quickly I wanted to mention one cool feature in 4.0, which is Dynamic Entities. With the new dynamic CLR ...
Hi Everyone, I'm working in Excel 2007, sometimes the plot data section of charts doesn't auto-resize to avoid overlap from the legend. Is there a property in VBA that I can use to force it to auto-resize? Appreciate your help. Thanks, Pradeep