Bander's Blog

Welcome to the 3rd part of this guide. We have a vanilla cream Windows Server 2008 installation with Active Directory Domain Services and DNS roles installed and configured. The next step is installing SQL Server 2008.
First of all we need to mount the SQL Server image on the virtual machine drive. Using the Hyper-V Virtual [...]

I’m so excited to get the green light of publishing content about SharePoint Server 2010 Being SharePoint MVPs. we had an early access to the Office 2010 bits, to both Server and Client products but we were asked not to share any of the information, even product screenshots until Microsoft officially launches SharePoint [...]

Just had one super community night! NO, I’m not saying this because I was the speaker hehehe I had a rocking audience who had questions about everything. The session went on for 2 hours without any breaks! That was community spirit
The community night was about Business Intelligence & SharePoint, we discussed [...]

I’m planning on delivering a BI on SharePoint community night this June. Part of the session will be dedicated for a quick preview on SharePoint Business Data Catalog (BDC). In my quest in looking for a decent data source I stumbled into the Adventure Works database. It was not what I was looking for, [...]

A weird night!
We went to Barnnies, TCHE TCHE, Starbucks, and even to Zuqaq.. no place to sit!!! So my friend and I decided to go to Chili Ways (next door to Zuqaq) and start eating Zuqaq’s 1 MB bandwidth as usual with Channel 9 videos.
Now what relates all this to Sharepoint?
Simple answer, since I’m a [...]

I had a question the about recovery models for SQL databases. This is the setting that you are shown when you do a right-click on a database in Enterprise Manager and view the properties. It is under the Options tab in the database properties dialogue window. You have 3 choices for a recovery model on [...]

When we have join in queries, the SQL optimizer uses one of the following three physical operator to perform the join 1. Nested Loop 2. Merge 3. Hash Nested Loop In nested loop, while computing the join each row of one [...]

Index Scan
Index Scan means performing a full scan on Index Pages. This is especially done for table that have non clustered index on them.
In case of Non Clustered Index the leaf pages contain links to the rows in the data pages whereas in the Clustered index the leaf page contain the row itself. So when [...]

1. sp_columns_rowset: Given a tablename it provides the schema for the table i.e. column information not exacly but somewhat similar to Oracle desc command.
Exec sp_columns_rowset ”
2. sp_who:Provides information about the current database users and processes.
Exec sp_who
The above will provide list of all database users.
3. sp_who2:This is similar to sp_who the only difference being it provides [...]