Categories
Babbling Me

And finally it is here !!

Yes, after month of speculations and rumors (and news of fake torrents) finally long awaited Windows 8 is here. Though MSFT has already mentioned somewhere that “Windows 8” is not the final name of OS for now it is known as Windows 8 to all of us. It has been said that it will be finest of windows ever (but I don’t want to hold my breath on it after my experience with Vista Shifty ) but by looking at all snapshots on net and presentation videos I am sure that it will be a bit different.

Since introduction of that tiny square computing machine (ahem …. iPad) the computing trend has sort of shifted towards portable computing devices called Tablets. And this new OS of Windows is said to be designed to specifically for those devices (or devices that supports “Touch”).

I am kind of more interested in laying my hand on Metro UI (famous UI that is being used in newer Windows Phones). I’ve played with it on Windows Phones (I personally like to live free, so I am using Android Winking smile) and I really liked it. The look is really refreshing. And I would like to see how they have implemented navigation of this UI to devices which don’t have touch support (laptops and desktops). And of course built in AV and Hyper-V are also feature that I would like to test.

Categories
Apache How To Tips Windows

Change default port in Apache

This quick post is about changing default port in Apache. Say if you wanted to work with IIS and Apache both. Now, both web server uses port 80 and so you can’t have both of them at the same time. So one has to sacrifice it’s favorite port Open-mouthed smile. In my case it was Apache not because I am MSFT technology user but just because I am working with Apache just as sort of self improvement project and most of the time I will want have to work with IIS. So I need to change default port of Apache listen to some other number then 80, which is very simple process.

All you need to do is to locate “httpd.conf” file and look for section where it mentions about listening port. Something similar below,

Categories
How To SSRS

SSRS 101: Deploying Reort in BIDS–Part II

Ok, in first part we walked though creating basic report for SSRS using Business Intelligence Development Studio (BIDS),which was kind of an easy process I guess Smile. Next step is every easier, which is deploying that report to report server so others (those who have permission) can access it. For deployment of report you will need to know URL for report server. In my case it is “http://localhost/reportserver”.

Settings can be setup for deployment in project property.

property 1

property 2

 

1) Property of SSRS Report Project

2) Setup Target Server URL with your report server URL

Categories
How To SSRS

SSRS 101: Creating Basic Report in BIDS–Part I

Ok, so after some initial struggling of setting up whole environment for SSRS to work smoothly and after getting some sample data I am finally ready to begin my epic journey to SSRS (it is epic for me because most of the stuff that I am going to learn will be myself and I will not have any on-site help, but of course Google – his brethren .. i.e. Bing, Yahoo etc will be always helping me in my quest).

Anyways, this first post will show how to create a basic report for SSRS using Business Intelligence Development Studio (a.k.a BIDS). Since BIDS is component of VS 2008 and it is not available for VS 2010, we are left with only one choice of IDE that is VS 2008 (if you have Pro or higher version or you are stuck with BIDS which gets installed with SQL Server 2008r2).

But before doing anything I will create a sample table for us to use in report. Of course most of the “tutorials” out there are using standard Adventureworks database but for this report I am using my usual table that I practice with. Following is SQL Query to create that table, and of course you will need to have AdventureWorks 2008 r2 sample database installed (or you can modify this query to match your setup).

SELECT p.BusinessEntityID,p.FirstName,p.LastName,a.AddressLine1,a.City,sp.Name [State/Province],cr.Name [Country],a.PostalCode into TableFoo FROM AdventureWorks2008R2.Person.Person p
JOIN
AdventureWorks2008R2.Person.Address a ON p.BusinessEntityID=a.AddressID
JOIN
AdventureWorks2008R2.Person.StateProvince sp ON a.StateProvinceID=sp.StateProvinceID
JOIN
AdventureWorks2008R2.Person.CountryRegion cr ON sp.CountryRegionCode=cr.CountryRegionCode

Now, after having something to select from database fire up VS 2008 instance and create New Project and select Business Intelligence Project –> Report Server Project. At first you should see empty environment and on your right hand side, you should see 3 options,

1) Shared Data Sources: which can be used to share same database connection across all report in that project, we will see later on how we can use this.

Categories
Tips Windows

Disable Shutdown Event Tracker

I’ve been using Windows Servers provided by MSFT for free from past few years (not by downloading from Torrent sites by via DreamSpark program) ranging from 2003r2 to the latest one 2008r2. And almost all of them have one feature that really annoys me and that is “Shutdown Event Tracker”. I simply don’t understand that who would like to fill up why they want to restart. At first (when I was in school) I thought that may be sys admins do really enter details but when I begun working I found that it is rather annoying to them as well !! It is just beyond me that why would someone really want to use this feature !!

So this quick post is about how to disable this feature in Windows Server 2008 r2. But I think it applies same to other older versions (2008, 2003 r2) as well.

All you need is to run “gpedit.msc” using RUN. It will open up group policy editor window.

cmd

Categories
How To SQL Server SSAS

Deploying AdventureWorks Analysis Database ..

If you are working with SQL Server then you might already have used this great cycle selling company’s database (AdventureWorks) at least once. Microsoft has created this cycle selling company database for SQL Server 2005 and later versions, before this sample we had “NorthWind” database.

Anyways, if you try to install these sample databases you will find that it is not just one single database but rather a collection of different types of databases like OLTP, Data Warehouse and OLAP cube. And honestly, I have learned a lot by working on OLTP and DW samples. But default installation doesn’t install Analysis Database by default. You have to manually deploy it using a solution provided, you just need to follow this instructions provided by MSFT. Ideally it should work just OK if your SQL Server instance is running with Local System account (which is not recommended at all because it gives admin access to your system, but who cares … its bloody local system, right ?? Disappointed smile) … but in my case SQL Server is using Network Service account which gives it limited permission. So when you try to deploy the cube as instructed in MSFT help your deployment might fail with following errors.

Categories
Bugs SQL Server Visual Studio

Intellisense in SQL Server 2008 r2 management studio

This quick post is about my recent experience with SSMS for SQL Server 2008 r2. Usually I use some other 3rd party tool for SQL Server Development because it is sort of more easier to use when we are developing (but that tool is not good at all when it comes to managing SQL Server).

If you are a developer like me who is required to work with application but mostly deals with database … and you happen to use SSMS for SQL Server 2008 R2 then you might already have noticed that you have … hmm.. sort of lost … intellisense in SSMS (or SQL Server Management Studio, a default tool for interaction with SQL Server) after installing Visual Studio 2010 SP1 updated. This is really weird issue. I / We generally when release an update for our application we make sure that for any reasons our other applications that are using that one application doesn’t lose some functionality. And I don’t understand how come guys at such a professional company like MSFT don’t understand this common app release / testing process ??