Monday, May 23, 2011

Microsft outlook export option

A couple of days ago my manager asked whether there is a way to convert appointments recorded in outlook into a report so that the data need not be double handled.




I thought there should be some sort of an export option provided in outlook and started exploring the menus in outlook. Sure enouth there I found under the File menu an option called Import and Export as shown below.





I chose the export to file option as shown below.




I them chose the csv for windows option as shown below.





In the next screen I chose the calendar folder and specified the dates to export and the path and the file name. The csv file was exported with all the different fields.

Friday, May 20, 2011

Free SSAAS Expo again from SSWUG

SSWUG.ORG’s virtual expo will review various aspects of SQL Server Analysis Services (SSAS), which enables the server to be used for analytical processing and data mining.
Through our in-depth sessions with four of the leading experts in the information technology (IT) and business intelligence (BI) fields, you will see many demonstrations and examples on designing, creating and managing data from multiple sources.

By the end of theevent, you should have the tools and understanding needed to bring added functionality, automation and insight into your data.

Sessions will cover the following topics:
Common Mistakes with SSAS Cube Designs
SSAS Partitioning and Aggregation Strategies
Properly Using the SSAS Query Cache
Overcoming SSAS Implementation Issues
Building a Scalable SSAS Solution
Best Practices for Performance and Tuning Techniques

Click here to Register!

Thursday, May 19, 2011

Free Webcast Series on Sharepint 2010 from SSWUG

SharePoint beginners and experts can benefit from attending SSWUG.ORG’s “SharePoint 2010 Basics” webcast series, which will delve into what you can do with the newest version of SharePoint and how the platform can benefit your business.

In four, in-depth sessions, Rebecca Isserman, SharePoint Server MVP and Consultant for Planet Technologies, will explain how to use the platform’s key features, create sample applications in the development environment, blend Silverlight applications with SharePoint and more.

By the end of the series, you will know about the various and available environments and tools you can use to develop a functional and optimized SharePoint project.

Click here to see the session schedule.

Click here to register.

Wednesday, May 04, 2011

Restore folder in Sharepoint

We heavily use a customised feature of Image Library on sharepoint 2007 which is our Intranet. One of the new users yesterday had deleted a whole folder from this library and wanted us to restore this. Now we have never done a restore onto the sharepoint.

So I started investigating the sharepoint settings as to how to solve this problem rather than looking at the backup to restore.


So this is what I found! a Recycle Bin in the Sharepoint. And there are the files from the folder that was deleted neatly sitting in there. Wow that's a learning for the day I thought.

So here is the path as to how I found the Recycle Bin.


  • Click on the Image Ibrary on the intranet

  • Click on site settings

  • Click on Recycle Bin which is under Site Collection Administration as shown below.






Tuesday, May 03, 2011

Free MDX Webcast Series by SSWUG

Explore the basic functions of MDX and view many practical examples on using the query language in SSWUG's "Introduction to MDX" webcast series.

In three, in-depth sessions, Business Intelligence architect and MDX expert Bill Pearson will focus on the basic components of MDX, as well as provide information on crafting simple MDX expressions and queries that generate result sets.

Click here to see the Session dates

Click here to see the Session Schedule.

I think these sessions will be particularly useful for beginners.

Two ways to reset the identity of a table in sql server.

I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...