Tuesday, July 27, 2010

SQL Server Sleeping Status and Connection Pooling

›
Are you seeing many “sleeping” status connections in your SQL Server? If so, have you ever thought to find out the reason for it? Is it norm...
7 comments:
Sunday, July 25, 2010

Configuring PerformancePoint 2010

›
We have been creating reports or dashboards with different types of technologies including PerformancePoint 2007 for seeing the insight of t...
6 comments:
Sunday, July 18, 2010

SQL Server Page Size – 8KB and Hard Drive Sector Size – 512 bytes???

›
Discussion related to SQL Server page sizes and OS page sizes was started up while my new SQL Server class was being done. New batch is real...
6 comments:
Tuesday, July 6, 2010

SQL Server 2008 R2 Best Practices Analyzer (BPA) is available for downloading

›
If you have used SQL Server 2005 BPA, you know how useful it is. If I am not mistaken, there was no BPA available specifically for SQL Serve...
1 comment:
Monday, July 5, 2010

SharePoint always prompts for login credentials???

›
I recently configured SharePoint 2010 on Windows 2008 R2 and created couple of applications. Although everything works fine, one thing bothe...
1 comment:
Sunday, July 4, 2010

Microsoft Silverlight PivotViewer is released

›
Truly, this is fantastic. This software allows you to visualize massive data in a nice interface with Business User’s Pet: Microsoft Excel. ...
Sunday, June 27, 2010

Creating Self-Service Business Intelligence dashboard with PowerPivot – Part I

›
What is Self-Service Business Intelligence? Self-Service Business Intelligence – What is it? Is it a new term? You may know about th...
1 comment:
Monday, June 21, 2010

Designing Database with SQL Server: Microsoft Student Champs Meeting

›
Last week I was invited by Madusha Nanayakkara, Microsoft Student Ambassador to deliver a session at Microsoft Student Champs Meeting. I was...
4 comments:
Sunday, June 20, 2010

OPENROWSET, OPENDATASOURCE - “Microsoft.ace.oledb.12.0” for linked server “(null)” reported error – Excel 2007, 2010

›
SQL Server supports distributed queries in many ways, allowing users to access heterogeneous data sources. The frequency of data access dete...