• To the summit

    September 21, 2005 / No Comments » / 1037 Views

    If you are attending SQL Pass event next week in Grapevine, TX and you would like to know more about Reporting Services, stop by to my presentation. I am teaming with Bruce Loehle-Conger (MVP – SQL Server) to present the Reporting Services Tips, Tricks and "Gotchas" session.   I have some cool demos that demonstrate retrieving images from a web service, dynamic connection string from configuration file, Analysis Services integration, using CLR stored procedures, and more… If you are not coming, I will upload the code demos on this site after the event.   See you in Texas!

  • SQL Server September CTP reloaded

    September 21, 2005 / No Comments » / 1064 Views

    In addition to my previous post about installing CTP, here are some additional notes:  After you uninstall the previous version of SQL Server, make sure to delete all database files in C:\Program Files\Microsoft SQL Server\MSSQL\Data. The setup program will comlain about them. If you are upgrading a previous CTP and you are running into performance issues, try the Registry Mechanic. It found 500 registry issues on my machines and it fixed an issue with the ASPNET account not having enough permissions (I don’t have the exact event log entry).

  • SQL Server September CTP and VS.NET RC are here!

    September 14, 2005 / No Comments » / 976 Views

     If you are subscribed to Microsoft Beta, you can downoad the SQL Server September CTP and Visual Studio Release Candidate (plan for a day or two given the 30K connection speed) from the Microsoft betaplace website. Here are the steps I was taking to install both SQL Server CTP and Visual Studio.NET RC that you may find helpful. I had SQL Server 2005 June CTP and Visual Studio 2005 Beta 2 installed prior to installing the new bits and the upgrade went fine for me. You may not need to be so reboot-oriented but I like to start from a clean state just in case J.  Uninstall SQL Server 2005 by running the Cleanup Wizard (Setup Tools\Build Uninstall Wizard\sqlbuw.exe on the SQL Server 2005 CTP CD). Make sure to select .NET 2.0 and Native Client (Microsoft SNAC) options. Reboot Remove all files from the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data folder. Uninstall...

  • SP2 Hotfix available

    June 29, 2005 / No Comments » / 830 Views

    Microsoft has released a hotfix for SP2 that fixes a few items in SP 2. Specifically: HTML Viewer Style Sheet Configuration Property Missing from Service Pack 2. Incorrect line breaking or random formatting issues with MHTML. Leaving and returning to the Schedule Page from the Subscription Properties page causes dependent report parameters to be disabled, then reset to the first or default value. Tables exported to CSV may lose the first row of data. Download the hotfix here.

  • Do more with less!

    June 19, 2005 / No Comments » / 986 Views

    As you probably know, Microsoft has made a great effort to scale down the SQL Server 2005 components and provide more features at a lesser cost. Here are some links worth checking.   SQL Server 2005 Feature Comparison http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx   SQL Server 2005 Reporting Services Enhancements http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx   SQL Server 2005 Reporting Services Features Matrix http://www.microsoft.com/sql/2005/productinfo/rsfeatures.mspx   As far as Reporting Services is concerned, here are a couple of important points.   1.      Reporting Services 2005 will run on the Express Edition of SQL Server 2005 (previously known as MSDE in SQL Server 2000). What it means to you is that you can build and distribute reasonably feature-rich reporting solutions for free. This could be nirvana for many software vendors and integrators. Now you can build a report enabled-application and distribute the SQL Server components at zero cost to the client. 2.      Different editions support different feature sets. The last...

  • Tech Ed US (Day 5)

    June 11, 2005 / No Comments » / 978 Views

    D-day! I wondered how many people would show up for my presentation about RS Custom Security. I turned out that about 60 people thought that custom security is just what they needed to boot up after the last night party. I think the presentation was well received. While you are waiting for the Tech Ed DVD, I posted the code on my website.   I got hammered a bit about my presentation skills. Obviously, the tips I’ve learned from the train-the-trainer session weren’t enough. Next time, I will try some of the Steve Ballmer’s stunts. May be they will do the trick. If someone who’s attended my session reads this, please let me know what I can possibly improve to deliver the message more effectively, since I don’t think I can solve this dilemma by myself. BTW, custom security will be available with RS Standard Edition, as Brian Welcker pointed...

  • Tech Ed US (Day 4)

    June 11, 2005 / No Comments » / 994 Views

    I couldn’t sleep well last night. My neighbor on the left was talking on her cell phone until midnight and I can hear every damn word through the thin wall. My other neighbor was watching a horror movie. A double impact. Not to mention that the cell phone of my left neighbor  rang and woke me up at 6. Luckily, today is not presentation day.   In the morning, I went to see the Managing Analysis Services 2005 Using Analysis Management Objects (AMO) presentation by Alex Lim. Alex is also a Microsoft Most Valuable Professional. We introduced to each other and talked briefly about South-east Asia. I spent three years in Singapore, so we had a lot in common. I liked the demo code that Alex used for his presentation. For those who are new to Analysis Services 2005, AMO is a .NET-based object library which allows you to manage SSAS...

  • Tech Ed US (Day 3)

    June 11, 2005 / No Comments » / 962 Views

    Wednesday. The pressure and fatigue starts building up. So, I am going to take it easy today. Now that I am writing a book about Analysis Services 2005, I felt like I need a pinch of MDX to boost my spirit. So, I went to see theSolving Business Problems with MDX in Analysis Services presentation by Amir Netz and Richard Tkachuk. I didn’t regret at all! It was an excellent presentations which gave me some tips about how to structure the MDX part of my book. Next, I attended the SQL Server 2005: End-to-End Part 3 presentation by Donald Farmer (Product Manager of Integration Services, aka DTS). It was a good presentation as well. In the afternoon, I had a train-the-trainer session which goal was improve the speaker’s presentation skills. I found out that I have to show more energy and articulate every word to captivate my audience. Now I know the secret...

  • Tech Ed US (Day 2)

    June 11, 2005 / No Comments » / 825 Views

    First, I went to see the Paul Flessner’s keynote. I learned that Reporting Services will be available in all editions of Yukon, including Express! And, custom security will be available in RS Standard Edition as well! Now, we are talking! For more information about how different versions of Yukon will stack against each other, read this comparison document. Next, I went to see Brian Welcker’s presentation about the new report viewer controls in RS 2005. The presentation was in one of the biggest conference halls and it was almost full (with perhaps some 600 people). This speaks by itself about the traction RS is getting. Brian actually wrote a whitepaper about the new features in RS 2005. It is nice to see Reporting Services evolving! Next, I went to see the real-time OLAP presentation from the Analysis Services Team and shake hands with Amir Netz and Richard Tkatchuk. The presentation...

  • Tech Ed US (Day 1)

    June 11, 2005 / No Comments » / 1036 Views

    Everyone was rushing in the morning to see Steve Ballmer’s keynote. He said there are some 11,000 folks at the conference. No wonder, all ice creams would disappear even before arrival! Here is some statistics that got posted on the TechEd site:   Feeding the Masses What does it take to feed 13,000 people at Tech·Ed? 117,000 bottles of water 14,300 lattes 15,600 ice cream bars (it’s HOT out there) 4,000 pounds of chips and snack mix 2,300 dozen eggs 8,000 pounds of chicken 52,000 servings of juice You get dizzy if you stay more than 10 minutes in the exhibitor hall area, so I decided to avoid at all cost, or cross it as fast as I can. Otherwise, people will run over me in an endless pursuit to get every possible t-shirt that has been handed out. I got only two but I didn’t have to fight. They...


We offer onsite and online Business Intelligence classes! Contact us about in-person training for groups of five or more students.
For more information or to register click here!


Learn Power BI at your own pace with our latest book Applied Microsoft Power BI. Targeting information workers, data analysts, pros, and developers, It is designed as an easy-to-follow guide for learning how to implement BI solutions spanning the entire personal-team-organizational BI spectrum.