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
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...
I came across this link on SQL Bits where there are about 164 videos on various aspects of SQL Server and sharepoint which I found useful. Altogether there are 215 articles. Have a look at the compiled sessions and content page . Hope you also find this content useful.
Today I received an email about the free virtual expo from SSWUG Here is an excerpt from the email. Sessions will cover the following topics: SQL Statement Tuning with Indexing Strategies (Presented by Kevin Kline) Performance Tuning SSIS (Presented by Brian Knight) Using DMVs to Diagnose Performance Issues with High OTLP Workloads (Presented by Glenn Berry) Implementing Resource Governor (Presented by Buck Woody) With registration, all attendees will also receive a complimentary month of full m...
Today I was experimenting with the query results in Sql server management studio and saw this shortcut in he View menu of the SSMS. So in order to show full screen I tried the shortcut -- Shift + Alt + Enter. The same shortcut works to come out of the full screen mode as well. What the full screen does is closes all the other windows and like object explorer, registered servers etc that you have open and maximises the query and results windows. Likewise if you want to go to the properties just p...
Yesterday I came across this blog on MSDN by Bruno Aziza. Bruno says that Biz Intelligence TV is a new and innovative way to let industry leaders express and gain access to thought-leadership on Business Intelligence. The goal of the BizIntelligence.TV program is to start an ongoing conversation by providing compelling content from peers and industry stars. Here is the Biz Intelligence TV channel on Youtube
Today I listened to this very good informative video by Steve Swartz which I wanted to share with you all. This is a presentation by Steve Swartz in the Microsoft TechEd Europe 2010. In this presentation Steve says that he desires to teach you how to fish rather than give the fish itself. Thanks to Steve for posting this.
I was looking for some SSAS interview questions and found some very good resources on the web. The links are below. SSAS Interview Questions from Siddharth Mehta's blog Sql Server 2005 Analysis Services Interview Questions Dave Rodabaugh's Analysis Services interview questions SSAS MDX Query interview questions SSAS interview questions for MDX from Learn Microsoft BI MDX Questions from datawarehousing guide Hopefully these resources are useful for you as well.
My first post this year is to wish all the readers here a HAPPY NEW YEAR! As the new year blossoms, may the journey of your life be fragrant with new opportunities, your days be bright with new hopes and your heart be happy with love! My main new year resolution is to start the certification process to achieve Microsoft Certified Technology Specialist (MCTS) Microsoft SQL SERVER 2008, Business Intelligence Development and Maintenance. I have no doubt I will be using all the resources available h...