Have you heard of Microsoft Dreams Park?

This morning I came across this web site by Microsoft called "Microsoft Dreamspark" They have training videos, reading material and provide microsoft professional tools free of cost for students to practice.

Please have a look and sign in and take advantage

SQL Disaster Recovery Event from SSWUG

Here are the event details from SSWUG.

Attend the Free SQL Disaster Recovery Event

SSWUG's free virtual expo will showcase several ways to prevent a SQL Server disaster and how to recover the database in the event of loss or damage. Through the in-depth sessions with some of the leading SQL Server experts in the information technology (IT) field, you will see many demonstrations and examples on anticipating and reducing the likelihood of a database tragedy. Learn more about the virtual expo content and register today.

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.

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!

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.

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.

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.

ATBroker.exe

Last night when I tried to access my computer from home via Remote Desktop Connection an error came up as shown below.

This is the first time I have encountered with this error. Since I had lots of work to do I logged on to one of the servers and did my work thinking that the error will disappear when I access the actual machine in the morning. But to my surprise the error persisted when I switched on the monitor in the morning. So I tried the usual Ctrl+Alt+Delete. And there lies the familiar screen which made me relax as shown below.

So I chose the Start Task MAnager option and luckily got into the computer. But I am not sure why the error has come up. Have any of you had this error before? If so what did you do? And do you know why this error came up?

Increasing SQL SERVER Memory

In one of our server audits it was discovered that only one third of the memory has been allocated to the sqlserver instance. Questions were asked whether multiple instances of sql server are present. But when there was no other instance of sql server running it was recommended that we increase the memory allocated to double from 10 GB to 20 GB.

The actual memory of the server was 32 GB. Here are the steps we took to achieve this.

1) RDP to the SQLServer and sign on

2) Open up SQL Server Management Studio

3) Select the SQL Server in the Object Explorer on the left

4) Right click and select Properties

5) Select Memory tab as shown below

6) Change Maximum Server Memory from 10240 to 20480

7) Click OK

Close Management Studio

As a precaution restart the server. It is better if you do it after hours.

I had a strange problem today. I went to the website I have developed and maintain and tried to click on the print button and expected to get a normal printout. But instead was surprised to get a blank print out with just the header and footer.

I thought I haven't changed any code why did it stop working. I just assumed that it was not working for anyone without testing on other computers. After about 15 min. I had a request from another colleague to print from some other govt. website. So I hit the print button provided on their website. Then the output was the same with the blank page being printed with just the header and the footer.

Then I have asked one of my other colleagues to print and he could print. Only then I have realised that the problem is with my print spooler.

So developers beware of this problem. You might also face this stuation at some stage.

So the following are the steps that I have taken to restart the print spooler.

• Right click on 'My Computer' -- and choose Manage


• From the left hand menu -- choose Services and Applications


• Then click on Services


• From the list that appears on the right hand side choose Print Spooler as shown below.

Stop the service and start it again.

Now the important part : If you test Print form the same browser session the print might not work. Make sure that you open a new session and print.

Power Switch for a blade server -- an interesting find

We had a power outage for about 6 hrs at our office and the UPS would last only for 1 hr. We decided to do a managed shutdown of the servers and then power them back up the next day when the power came back up. I was responsible for coming early in the morning and switching on all the servers.

As mentioned in an earlier post our systems administrator is no longer with us, Andrew joined us to take over this role. He did the shut down part the previous night and called and said that he cannot find the power switches for the blade servers. I also didn't know where the power switches for the blade servers were. I have asked him to go home and said that I will deal with that in the morning.

Now the image below is how the blade server looks.

As you can see there is no way you will know that there is no power switch that is visible to the human eye. I did a lot of googling the night before to get some insight but could not find any documentation. For those who have dealt with the blade servers this could be very easy. But finally I figured out that the glass apnel above can be opened. When that was opened there lies the hidden power switch neatly as shown in the image below highlighted in red.

The keyboard shortcuts I use

Yesterday I was working with my colleague and she was surprised with the number of shortcuts I use with Windows Key .

So I thought I could list all the shortcuts for the benefit of her and others

To open the Start Menu -- just click Windows Key
To open the windows exlpoer -- click Windows Key + E
To open the seach/find window -- click Windows Key + F
To display the desktop by minimising all the open windows -- Click Windows Key + D (I have found this really helpful)
To lock your computer -- click Windows Key + L (Easy to remember)
To open the run command -- click Windows Key + R
To display the Help window -- click Windows key + F1
To zoom in the screen -- click Windows Key + =
To Zoom out the screen -- click Windows Key + -
To go through the open windows one by one -- Windows Key + Tab (Similar to Alt+Tab) but the display is really nice.

If you have windows open and your windows 7 gadets are hidden behind them you could bring them on top of the applications you use -- Windows Key + G

If you use two screens -- two helpful shortcuts are
Moves the current windows to the left screen, when running dual monitors -- Windows Key + Shift + Left arrow
Moves the current windows to the right screen, when running dual monitors -- Windows Key + Shift + Right arrow

There could be other shortcuts which you also might be using. Please let me know so that I could start using them as well.

Have you heard about Channel 9?

I stumbled across Channel 9 yesterday while researching. Channel9 is a Microsoft maintained site which is full of videos, blogs, shows, series etc. There is too much information on this site for one to absorb and learn.

Here is the link to the site. I hope you will enjoy this learning.

Data Mining and Analysis -- Free Expo from SSWUG

Here is another Free Expo Event from SSWUG that covers Data Mining and Analysis. The event is scheduled for March 18th 2011 from 9 am to 12 pm PST.

Sessions will cover the following topics:

• Using Data Mining Plugins with Excel
• Developing SQL Server Data Mining Models
• Understanding Data Mining APIs
• Finding Patterns and Relationships in Server Data

You can register now if you would like to learn from three skilled data mining experts.

Conditional formatting using multiple conditions - Excel 2007

Today I had a requirement to colour code in Excel based on a few conditions. At first I thouhgt I could use thre to four rules in the conditional formatting to achieve this result but when I did that the results that I was getting was not very satisfactory. So I thought I would try the And function of excel in conjunction with the conditional formatting and it worked wonders.

I wanted the entire row to be highlighted in a certain colour based on three conditions.

Here are the steps I followed to achieve what I was after.

• Select all the data that you want to colour code.
• Click on Conditional Formating on the Home Tab
• Choose Manage Rules as shown below
  

• From the dialog that appears click New Rule.
• Add the multiple conditions using the And function in the formula box
• The most important thing you need to do when you are adding the formula to highlight rows is to remove the $ sign that gets assigned when you choose the cell for entering a formula with a mouse.
• Choose the colour by clicking the format button and click ok
• Click Ok again to come out of the Manage Rules window.

As you can see below I have added two rules and it is giving me the result that I want.

Have you heard about Snipping Tool?

Thanks to one of my colleagues, yesterday I learnt about the Snipping Tool which is avaibale in Windows 7. To activate the tool -- Click on Start -- All Programs -- Accessories -- Snipping Tool. A screenshot of the tool is shown below.

Snipping tool enables you to select an area on your desktop or the entire desktop using your mouse and save this as an image for future use.
Until now I used to use the key board shortcuts PRintscn for capturing a screenshot of the entire desktop or Ctrl + Alt + PrintScn to capture the active window. Then open Paint and then save as an image.

Only drawback of the snipping tool that I found was if you have try to capture a screenshot of the values in a drop down of the filter feature of the excel, you could not do that using the Snipping Tool as you are trying to use your mouse to invoke the snipping tool. When you do this the drop down disappears in excel and hence you cannot take a screenshot of what is not appearing on your screen.

But the command that I always used Ctrl + Alt + PrintScn worked as shown below.

If anyone of you know of a workaround for this I would be pleased to know about it.

Processing of SSAS cube -- steps for beginners

I thought today I will cover the steps that can be followed to process a Sql Server Analysis Services Cube from Sql Server Management Studio.

The assumption is that you already have a cube that is built in SSAS and you would like to process this cube from sql server management studio

Step 1
Connect to the sql server analysis services instance from the sql server management studio as shown below.

Step 2
From the left hande side menu click on the plus beside Databases.

Step 3
Right click on the cube that you would like to process as shown below.

Step 4
The following dialog appears. Click on change settings if you need to and click on OK. Depending on the amount of data the processing takes a few minutes upto a few hours.

Have you used Outlook Anywhere?

Since our systems administrator left our company I have had a lot of opportunity to learn about things outside my normal coverage area. I am very thankful to my manager Ashley for giving me that opportunity.

In one of the meetings I sat with the external consultants 'Outlook Anywhere' was mentioned.

Outlook Anywhere is one of the Exchange 2007 feature that Microsoft has developed. The consultant mentioned that the Outlook Anywhere is a remote access method for Outlook Clients to connect through the internet to the exchange server without the need for a VPN.

This was not configured in our Exchange Server and explained the two main benefits as follows:

• There is no need for a vpn connection to be on to access Outlook Anywhere.
• If there is an internet connection available then you can just login to Outlook Anywhere and access your email.
  

Do any of you use Outlook anywhere? If not you can suggest your system admins to enable Outlook Anywhere if you are using Exchange server 2007 or 2010.

My first linked server -- SSMS 2005

Yesterday I was exploring Sql Server Management Studio, when I spotted Linked servers. I thought I will investigate what that and started trying out the options. So I right clicked on linked server, only three options came up as shown below.







I clicked on the New linked server .
I was browsing through the provider list as shown below and was keen to learn more about the provider for Microsoft Directory Services.

I thought I will experiment by using excel hence I gave the product name as excel, and data source -- a file in my c directory. But did not know what to give as a Provider string and location. I just gave the Provider as Excel 8.0 which is commonly used for excel in reports. Left the location blank and clicked ok.




To my surprise there was no error and the Test linked server was created as shown below.
So I right clicked on the test and chose TEst connection and the connection succeeded.


I am happy that it all went well but yet since there were no other options that are visible on how to use this linked server I thought I would find out when I had a bit more time on hand. So I will post my findings in another post.

Managind SQL Server Source Code -- Webinar

Here is the information on very interesting topic -- Managing SQL Server Source code. Here is an excerpt from the communication I have recieved from MSSQLTips

Live Webinar: Managing SQL Server Source Code

Now is the time to properly manage source code in SQL Server. Put an end to the chaos and stress of having to manage source code in a haphazard manner. Source control for application code has been the norm for years, but that is not necessarily the case with SQL Server code.
Come to this web cast to learn how to manage SQL Server source code with simple, predictable steps. We will show how to do so with tools you already have in addition to a solution from Red-Gate that integrates directly with SQL Server Management Studio.

Click here to register