Wednesday, April 29, 2009

Pragmatic Works - BI xPress Screenshots

Good-looking SSIS Auditing, configuration, monitoring and change management tool.

Pragmatic Works - BI xPress Screenshots

Wednesday, April 22, 2009

THE BI Blog : The Bird is the Word

Straight from the BI Blog comes social BI networks.

Here is a useful list of some of the communities and social groups for Microsoft BI, out there to get involved.

Follow the bird, the bbb-bird bird bird, bird is the word…

Twitter feeds

Microsoft BI

Nic Smith

Donald Farmer

Guy Weismantel

Microsoft SharePoint

SQL Server Pro’s

Microsoft_Excel

Facebook groups

Microsoft Business Intelligence

Microsoft SharePoint

Microsoft SQL Server

Excel


Linkedin groups

Microsoft Business Intelligence

SharePoint Users Group
SQLServer Central

Excel

Microsoft YouTube Channel

http://www.youtube.com/user/wowmsft

Microsoft BI blogs

The Microsoft BI Blog

http://blogs.msdn.com/bi

THE BI Blogroll

Intelligent Insight on Performance Management
PerformancePoint Team Blog
Norm's PerformancePoint Server Blog
Excel Team Technical Blog
SQL Server Reporting Services Team Blog
RDA Business Intelligence Blog
Sacha Tomey's BI Blog
LATAM Business Productivity Blog
SharePoint Team Blog
SQL Data Services Team Blog
The I in BI Hayley Rixon’s Blog

Microsoft BI Websites

Microsoft BI

Microsoft People Ready Business

SharePoint

SQL Server

Excel

Partners

http://www.microsoft.com/bi/partners/default.aspx

https://partner.microsoft.com/bi

TechNet Discussion Forums:

SQL Server Analysis Services
SQL Server Data Access
SQL Server Reporting Services
Management Reporter
ProClarity - General
SharePoint - Excel Services
Data Mining
Monitoring and Analytics
SharePoint - Social Computing
SQL Server Data Warehousing
SharePoint - Collaboration
SharePoint - Business Intelligence

Office Online Discussion Forums

Excel

THE BI Blog : The Bird is the Word

Friday, April 17, 2009

Amit's blog : Disk Partitioning Offset

 

Volume alignment, commonly referred to as sector alignment, should be performed on the file system (NTFS) whenever a volume is created on a RAID device. Failure to do so can lead to significant performance degradation; these are most commonly the result of partition misalignment with stripe unit boundaries. This can also lead to hardware cache misalignment, resulting in inefficient utilization of the array cache. For more information on this, see Disk performance may be slower than expected when you use multiple disks in Windows Server 2003, in Windows XP, and in Windows 2000.

Amit's blog : Disk Partitioning Offset

Monday, April 13, 2009

SQL Steve’s SQL Tips - While replacement

Instead of counters and while loops, this is a simple replacement.

But what if you have billions of rows in the “ErrorLog” table and you need to delete them a batch at a time so that you don’t lock up the entire table? You can use the “TOP” operator to specify the batch size and then specify an integer value that follows the “GO” keyword specifying the number of batches to execute.

For example:

DELETE
TOP(100000)

FROM

    ErrorLog

WHERE

    ErrorTime < ‘2008-01-01′

GO 10000

SQL Steve’s SQL Tips