mytechlearning.blogspot.com
My Tech Learning: March 2012
http://mytechlearning.blogspot.com/2012_03_01_archive.html
My day to day ramblings, learnings and research in Technology. Tuesday, March 06, 2012. Scroll Lock problems in Excel. Yesterday I had this problem in moving between the cells within excel. This problem usually occurs if the scroll lock is on. I tried to find the scroll lock button on my keyboard but it was not there. So I got the idea of using the On screen keyboard function to diable the scroll lock. So I clciked on Start button - All Programs - Accessories - Ease of Access - On Screen keyboard. View m...
mytechlearning.blogspot.com
My Tech Learning: Sql Server Error 3154
http://mytechlearning.blogspot.com/2012/07/sql-server-error-3154.html
My day to day ramblings, learnings and research in Technology. Friday, July 13, 2012. Sql Server Error 3154. I created a new database today and was wanting to restore this new database from another exisitng database using the restore option available in the wizard. But I got the 3154 error as below. So I had to restore to the restore database command in the SSMS. So here is the first option I tried. The database was restored successfully. Subscribe to: Post Comments (Atom). Auckland, New Zealand.
mytechlearning.blogspot.com
My Tech Learning: July 2012
http://mytechlearning.blogspot.com/2012_07_01_archive.html
My day to day ramblings, learnings and research in Technology. Friday, July 13, 2012. Sql Server Error 3154. I created a new database today and was wanting to restore this new database from another exisitng database using the restore option available in the wizard. But I got the 3154 error as below. So I had to restore to the restore database command in the SSMS. So here is the first option I tried. The database was restored successfully. Subscribe to: Posts (Atom). Auckland, New Zealand.
mytechlearning.blogspot.com
My Tech Learning: June 2013
http://mytechlearning.blogspot.com/2013_06_01_archive.html
My day to day ramblings, learnings and research in Technology. Thursday, June 20, 2013. Free ebooks from Microsoft. Here is a link to a huge collection of free ebooks. Posted by Eric Ligman from Microsoft. Hope you will find these books useful in your career development. Subscribe to: Posts (Atom). Auckland, New Zealand. View my complete profile. Free ebooks from Microsoft. Picture Window template. Powered by Blogger.
mytechlearning.blogspot.com
My Tech Learning: ERROR 22-322: Syntax Error is SAS code
http://mytechlearning.blogspot.com/2013/08/error-22-322-syntax-error-is-sas-code.html
My day to day ramblings, learnings and research in Technology. Tuesday, August 20, 2013. ERROR 22-322: Syntax Error is SAS code. I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. Today I was running a SAS program and got the following error. ERROR 22-322: Syntax error, expecting one of the following: a name, -, :, FORMAT, INFORMAT, LABEL, LABEL, LENGTH,. Name label 'Employee Name';. Name label = 'Employee Name' ;.
mytechlearning.blogspot.com
My Tech Learning: February 2012
http://mytechlearning.blogspot.com/2012_02_01_archive.html
My day to day ramblings, learnings and research in Technology. Thursday, February 23, 2012. Resolving #NUM error in excel. I was using excel to display data from a cube. I tried to do a caluclated cell in excel to display number of months between two dates. Here is the formula I used to do this. But I received an error - #NUM. So to avoid the #NUM error I changed the formula to. Datedif(G5,H1,"m"). This retunrs the difference between the two dates in months. Friday, February 17, 2012. 24 Hours of PASS - ...
mytechlearning.blogspot.com
My Tech Learning: January 2012
http://mytechlearning.blogspot.com/2012_01_01_archive.html
My day to day ramblings, learnings and research in Technology. Monday, January 23, 2012. Have you heard of Prezi? Late last year one of my colleagues Mark Crosby has introduced the Prezi. Tool in our company to do presentations. Prezi is a presentation software that can be used in creating more visual presentations. It is different to the traditional powerpoint software as it has a Zooming user interface and uses a vector based illustration and text which creates big visual impact. Auckland, New Zealand.
mytechlearning.blogspot.com
My Tech Learning: December 2011
http://mytechlearning.blogspot.com/2011_12_01_archive.html
My day to day ramblings, learnings and research in Technology. Monday, December 19, 2011. Automatcially download pictures in Outlook 2007. Today I was asked by my colleague as to how to change outlook 2007 so that she does not manually need to download the pictures every time an email comes in. Here is what I have suggested to her. Go to the menu item Tools in Outlook and then click on Trust Center. Then choose Advanced settings. Untick the "Don't Download pictures automatically' option as shown below.
mytechlearning.blogspot.com
My Tech Learning: October 2011
http://mytechlearning.blogspot.com/2011_10_01_archive.html
My day to day ramblings, learnings and research in Technology. Tuesday, October 11, 2011. Increasing the number of recent files in SSMS. In Sql Server Management Studio, I usually access my sql query files that I save - using the File - Recent Files option. The default setting of the number of recent files to be displayed in SSMS. Today I wanted to access a file that I had used last week and I could not find that file in the recent list. Now it is starting to display 10 recently used files. Then list the...
mytechlearning.blogspot.com
My Tech Learning: February 2014
http://mytechlearning.blogspot.com/2014_02_01_archive.html
My day to day ramblings, learnings and research in Technology. Wednesday, February 26, 2014. Getting the first date of the month in SQL without any functions. One of the date columns in my database is an integer as it is a dimension key. I was trying to get some results grouped for the whole month by this date integer column. This is how I went about getting it in an easier manner without using any DATEADD and DATDIFF functions. So I used the following SQL code to get the sum of the amount for the month.
SOCIAL ENGAGEMENT