October 2007 - Posts

Tips and Tricks Videos

I just did few screncasts and they are available over here:

Microsoft Outlook 2007 - Tips and Tricks Part I

Microsoft Outlook 2007 - Tips and Tricks Part II
Microsoft Outlook Calendar - Tips and Tricks

As usual, comments always welcome :) ...

Auditing MS SQL
Here is a pseudo implementation using audit tables and triggers ... And available on my favourite site of CodeProject :) ... Catch it here.
SQL and DPM
Join this webcast where they focus on how DPM 2006 and DPM version 2 (DPM v2) can provide continuous data protection for Microsoft SQL Server. Currently, DPM 2006 protects Microsoft SQL Server logs for reliable backup; DPM v2 Beta 1 (just released) introduces a whole new level of SQL Server backup and recovery. This is very interesting webcast to listen.
SQL Server 2005 Driver for PHP CTP
Download the SQL Server 2005 Driver for PHP CTP for October 2007, a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts.
Powershell++
Check it out here.
Overflowing Column
Kalen has this post on this very topic on her blog. I have heard this question comeup evey now and then during presentation to why the 8k limit and what happens if we have beyond this limit etc? In SQL Server 2005 we can have overflowing rows that can span multiple pages. Check it out here from Kalen.
Overlapping Indexes in SQL Server 2005
Here is a post from the ISV team over the same. It is critical to see that we dont have duplicates indexes in the system. They slow the whole system down. Check the post here.
Excel 2007 Web Data Add-In
This is a work from the MSR team hence dont expect this to be supported from MS. Download the same here.
Report Builder - Totals Filter
Bob has this wonderful post on how to filter on totals with Reports Builder here. I know quite a few have asked me on this unique requirement. Thanks bob for this ...
Transparent data encryption feature - SQL 2008
Laurentiu points to this fabulous feature that is part of SQL Server 2008 and has some good explanation. Check the post here.
Excel Calculation Fix
I know there was a lot of noise on this bug. But here is the post from the dev team on the fix. Check it out here.
Donald Farmer on Data Mining
This is a .NET Rocks video from Donald. I have attended quite a few sessions from him and it is always interesting to hear some of the perspectives from SSIS or AS or DM. Here, Donald Farmer talks about data mining with SQL Server and related technologies, including a fascinating discussion about using algorithms for predicting future trends. Download now.
Gadget Samples for Windows Sidebar
Consider this as a step by step tutorials. Has the various options that can be done with the sidebar gadgets. Download it here.
Precision Considerations for Analysis Services Users
This white paper covers accuracy and precision considerations in SQL Server 2005 Analysis Services. For example, it is possible to query Analysis Services with similar queries and obtain two different answers. While this appears to be a bug, it actually is due to the fact that Analysis Services caches query results and the imprecision that is associated with approximate data types. This white paper discusses how these issues manifest themselves, why they occur, and best practices to minimize their effect. Download the whitepaper here.
Presentation Sample Code for .NET Micro Framework 2.0
The NewPresentation sample is an enhanced version of the Presentation sample included with the .NET Micro Framework SDK. Its purpose is to illustrate how to use the .NET Micro Framework GUI framework. This sample has been enhanced with an animated “sliding menu” system and two new panel screens, one containing a scrolling text view and one illustrating free drawing on the display. Download it here.
More Posts Next page »

Search

Go

This Blog

Tags

Community

Archives

My Web Site

External Sites

Other Misc Blog Links

Newsletter

Syndication

News


  • Disclaimer: The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

    Site Counter: Hit Counter

    My tree at Carbon Grove