October 2008 - Posts
Recently, Wanda He from SQLCAT ISV team worked with Oracle Siebel group completed a new 12,000 concurrent users Siebel CRM 8.0 benchmark on SQL Server 2008 ( http://www.microsoft.com/isv/oracle/ ). The benchmark demonstrated that the combination of Microsoft
Read More...
Check out the the third of five technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series: Reporting Services Scale-Out Deployment Best Practices This technical note reviews the SSRS
Read More...
Check out the new look and feel of the sqlcat.com ! Now you have easy access and views of our Top 10 Lists, Technical Notes, Whitepapers, and Toolbox. As well, now our blogs our mirrored to sqlcat.com for easy access to all SQLCAT tips, best practices,
Read More...
The other day we got a call from a puzzled friend. He has rewritten a stored procedure using table variable instead of temp table, it makes the stored procedure code look more tidy. The puzzling part is the same stored procedure now running a lot slower.
Read More...
After the great work from the ETL World Record (for more information, refer to our other blog at: http://blogs.msdn.com/sqlcat/archive/2008/09/18/scaling-heavy-network-traffic-with-windows.aspx ), Thomas and I (with the help of many others) have created
Read More...
Saw an amazing BI demo this morning at the BI Conference here in Seattle. Donald Farmer showed how over 20M rows of data can be modeled and analyzed in memory. To build a model today, a DBA needs to define dimensions and fact tables, get the relationships
Read More...
