Wednesday, November 29, 2006

Tuesday, November 28, 2006

A Hard Lesson in Privacy

Read this article at Security Focus about how this guy purchased a second-hand laptop and found some porn stuff in the laptop belonging to the owner and then it turns out the owner is a very popular tv hostess.

Read more..

SQL Server 2005 Waits and Queues:SQL Server Best Practices Article

This paper approaches the complex area of Microsoft® SQL Server™ performance tuning using a methodology called Waits and Queues.

Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Reporting Applications

Relational Data Warehouse or Reporting work loads are characterized by low volumes of very large transactions. These applications are often identified as having predominately read workloads (e.g. Decision Support, Analysis, and Reporting) with periodic feeds or batch loads. It is important to keep these characteristics in mind as we examine the significance of database design, resource utilization and system performance. The top performance bottlenecks or gotchas to avoid for Data Warehouse or Reporting applications are outlined in this article at Mirosoft's TechCenter SQL Server site.

Monday, November 27, 2006

Article about DataWarehousing on Avoiding the Metadata Pitfalls

Summary: By doing a bit of groundwork and effectively controlling the scope of the metadata repository continuously throughout the project, few problems should arise.

Microsoft is often unfairly slammed for security issues, says NGSS

November 25, 2006 (Computerworld) --

Microsoft Corp may be taking the most heat among software vendors for security problems, but it's not always the one with the worst record.

A comparison of vulnerabilities in Microsoft's SQL Server database with Oracle Corp.'s relational database management products by Next Generation Security Software Ltd. (NGSS) shows that the latter vendor's products to have far more vulnerabilities than do products from Microsoft.

Read more...

BusinessValue Summit '06 (in Singapore)

SQL Server 2005 Service Pack 2 CTP

CTP for SQL 2005 SP1 can be downloaded from SQL Server 2005 Service Pack 2 CTP (November 2006).

The CTP for SP2 adds data compression, increased business intelligence functionality, adds security updates and support for Windows Vista and Office 2007. Excel, Excel Server and Sharepoint have all been integrated with SQL Server, allowing for Excel data analytics to be done within SQL Server.

Microsoft SQL Server 2005 Compact Edition

Overview (from microsoft.com)

Microsoft SQL Server 2005 Compact Edition offers essential relational database functionality in a compact footprint ideal for embedding in mobile and desktop applications including a new generation of occasionally connected dynamic applications.
Sharing a familiar SQL syntax and common ADO.NET programming model with other SQL Server Editions, and management via SQL Server 2005 Management Studio, SQL Server 2005 Compact Edition allows developers and administrators to apply their existing skills and be immediately productive.

In addition, SQL Server 2005 Compact Edition enables scale-up of an application, either via a robust synchronization with other SQL Server Editions, or by moving to a higher edition of SQL Server. SQL Server 2005 Compact Edition allows you to extend your integrated data management platform deeper into your enterprise and into your mobile workforce. Download SQL Server Compact Edition Release Candidate 1 (RC1).

Saturday, November 11, 2006

Announcing Process Monitor v1.0

Regmon and Filemon is now combined into a single tool, Process Monitor. Also included is other monitoring tools like process, thread and DLL monitoring.

There are all sorts of information displayed, including some basic data mining capabilites.

/Gill

Sysinternals Suite Now From TechNet

MS TechNet has rolled up the entire set of Sysinternals Utilities into a single
Suite of tools. This file contains all the individual tools & help files. The
whole thing is just 8MB.

http://www.microsoft.com/technet/sysinternals/utilities/sysinternalssuite.mspx

Find a career with Dell! The Dell Careers Blog is Open

Source: msexchange.org