RSS

Author Archives: Raffye.Memon

Download Internet Explorer 10 Offline Complete Installer for Windows 7

The latest version of Microsoft’s Web Browser Internet Explorer 10 is now available to download for Windows 7 users. Earlier when they launched it is only available for Windows 8 systems. Internet Explorer 10 is well optimized and designed for using touch screen devices and tablet devices.

IE10

IE 10 is not compatible with XP and Vista, its only available for Windows 7 and 8. In this version they bring a fast and fluid experience while browsing. The noticeable change in IE 10 is they have reduced buttons and options, moreover   clean look makes viewing websites enjoyable and convenient.

The most useful and amazing feature I found while using IE 10 is – when reading an article on a news site, we can just swipe across the screen to continue reading the next page instead of having to scroll down to click on a link.

 

Now lets discuss new features of IE 10

  •  High speed web browser. Web pages are loaded almost immediately.
  •  New address bar and One Box searching.
  •  Optimized for use with touch devices.
  •  Controls only visible when necessary. Browse full screen.
  •  SmartScreen Technology which offers greater protection and privacy.
  •  Three different ways to organize your “Favorites”.
  •  ”Do Not Track” , On by default.

System Requirements for IE 10

Processor

  Computer with a 1 gigahertz (GHz) 32-bit (x86) or 64-bit (x64) processor.

Operating system

  •  Windows 7 32-bit with Service Pack 1 (SP1) or higher.
  •  Windows 7 64-bit with Service Pack 1 (SP1) or higher. 
  •  Windows Server 2008 R2 with Service Pack 1 (SP1) 64-bit. 

Memory & Hard Drive Space

  •  Windows 7 32-bit—512 MB & 70 MB disk space. 
  •  Windows 7 64-bit—512 MB  & 120 MB disk space. 
  •  Windows Server 2008 R2 64-bit—512 MB  & 200 MB disk space. 

Offline installers for IE 10 on Windows 7

Advertisements
 
Leave a comment

Posted by on February 27, 2013 in Tech-News

 

Tags: , ,

Drupal: Increase PHP memory limit without access to php.ini

This is the recommended approach if you have access to the server’s php.ini. This will not be possible in some shared hosting environments, though your host may be able to adjust it for you. Note that this change will affect all websites and PHP scripts on the server.

  1. Locate the php.ini file used by your web server. You can click the “more information” link on Drupal’s status page’s PHP section. which shows the phpinfo() page. Locate the Configuration File (php.ini) Path row on that page. During installation Drupal checks the PHP Memory Limit, and if it is less than 32M (16MB for Drupal 6), an error message also provides the path to the php.ini file.
  2. Edit the memory_limit parameter in the php.ini file (usually in a section called Resource Limits)
    memory_limit = 64M  ; Maximum amount of memory a script may consume (64MB)
    If there is no section already for this, place the above line at the end of the file.
  3. Restart Apache.

php.ini in the Drupal root folder

Add the following line to a php.ini file in your Drupal root folder:
memory_limit = 64M
This will only work if PHP is running as CGI/FastCGI.

The next two solutions are more restricted in scope and, in some cases, may be more appropriate choices than affecting all sites.

.htaccess

Edit the .htaccess file in the Drupal root directory. Look for the section:

# Override PHP settings. More in sites/default/settings.php
# but the following cannot be changed at runtime.

and immediately after this add the following line:
php_value memory_limit 64M

This method will only work if PHP is running as an Apache module.

settings.php

If Drupal is already installed, you can edit sites/default/settings.php. This method will affect only the site using this file.
Locate the PHP settings section and add the following line at the end of that section:
ini_set('memory_limit', '64M');

Shared Hosting

In some shared hosting environments, access to the PHP memory limit setting is restricted. If you cannot make the change yourself, please ask your hosting provider to adjust it for you, or look for a new host that allows more flexibility.

For some hosts renaming php.ini to php5.ini may be necessary.

Some hosting services require the following line in .htaccess to enable a php.ini file.
suPHP_ConfigPath ~/public_html

For some hosts (CrazyDomains) you may need to add the following lines to the php.ini file (if they are not there already):

extension=pdo.so
extension=pdo_sqlite.so
extension=sqlite.so
extension=pdo_mysql.so

Modifying php.ini in local server environments

For MAMP see http://drupal.org/node/66187 particularly the “Optional: Adjust PHP’s memory limit for scripts” section (note the difference for MAMP Pro).

If you are using XAMPP/WAMP, there may be two PHP.ini files (one under the PHP directory and the other under Apache/bin). To change your memory limit, edit the file in the XAMPP/Apache/bin directory.

Check your change has taken effect

In all cases, it pays to ensure that your change is actually working. Check Drupal’s status report to verify that your memory actually is what you want it to be. If your change doesn’t seem to be working, double-check the location of php.ini. Some systems have multiple copies of that file in different places. Only one is used and the others are red herrings.

 
Leave a comment

Posted by on February 22, 2013 in Tips

 

Tags: , ,

Fix PhP Memory Size without Accessing Php.ini

I have recently discovered that few web-hosting do not allow access to php.ini and some application do need more memory to run or even install properly, for instance Drupal 7, Drupal Commons 7 etc

To Fix this issue paste “ini_set(‘memory_limit’,’16M’);” in your install.php. please note 16M is the memory size you can set 32M , 64M or 128M to suite you needs.

Enjoy.

Raffye.Memon

 
Leave a comment

Posted by on February 22, 2013 in Tips

 

Tags: , ,

Error with TFS2012,Sharepoint 2010 and remote Analysis Services on SQL2008r2

An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ‘dsArea’. (rsErrorExecutingCommand)

Above stated error pops up when we getting reports from report server: it could be caused by many authentication or Instance service types.

If you are trying to get Team Foundation Server 2010 to run with MS SQL Server 2012 Analysis and Reporting services, forget it 😦 i tried didn’t get it to work no matter what.

01 "Could not load file or assembly 'Microsoft.AnalysisServices.AnalysisServices, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies"

AnalysisServices_TFS-640x502I first thought it had to do with the “Client Tools Connectivity” of SQL Server which are required on the TFS application Tier.

After some digging I finally realized, that I missed the obvious.

The SQL2010 assembly has a different version!!!

01 'Microsoft.AnalysisServices.AnalysisServices, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

So it will never work with SQL2012 connectivity tools at least until now with TFS SP1.

Update:

If you install SQL Server 2008R2 Client Tools Connectivity on TFS Application Tier and SQL Server 2012 Client Tools Connectivity (Backwards Compatibility) on the SQL 2012 server it seems to work!
Unfortunately I still have to solve the annoying TF255186 Error with Reporting Services on SQL2012…

Update 2:

Solved!!! Finally solved the last issue by naming the Reporting Services ReportManager URL and WebServices URL by following schema:

http://&lt;ReportServer>/Reports_<InstanceName>
http://&lt;ReportServer>/ReportServer_<InstanceName>

This of course won’t be necessary when your reporting server runs on the default instance of SQL.
Thank you MS for not pointing out that this seems to be a requirement…

http://msdn.microsoft.com/en-us/library/bb552341.aspx

Update 3:

After the installation, I realized, that although everything was setup fine and all databases per created, I still had no access to the reports

Reporting Services answered with

01 An error has occurred during report processing. (rsProcessingAborted)
02 Query execution failed for dataset 'dsArea'. (rsErrorExecutingCommand)
03 For more information about this error navigate to the report server on the local server machine, or enable remote errors

If you look into the SSRS logfile located in C:\Program Files\Microsoft SQL Server\MSRS11.<your instance name>\Reporting Services\LogFiles

I found the error

01 TF221122: An error occurred running job Incremental Analysis Database Sync for team project collection or Team Foundation server TEAM FOUNDATION.

And

01 Errors in the back-end database access module. The provider 'SQLNCLI10.1' is not registered.

As SQL Server 2012 has the SQL Native Client 11.1 (SQLNCLI11.1) I tried to edit the analysis services datasource to use that provider instead. Unfortunately also that didn’t work.

So I installed the the SQLNCLI10.1 which can be downloaded here also on the DATATIER

http://go.microsoft.com/fwlink/?LinkID=188401&clcid=0×409

pocessed the cube again on the APPTIER by calling the webservice

 http://localhost:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx?op=ProcessAnalysisDatabase

with the Processing Type: Full

After a while I checked the status of the warehouse by invoking the webservice

http://localhost:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx?op=GetProcessingStatus

The error about the wrong provider was gone, but now I have the error

01 OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.

Stay posted… 😉

Update 4:

Solved!

you have to check out the permissions of xp_cmdshell in SQL Server Books Online. and enable it if its disabled. by executing following Query in Sql server.

---- To allow advanced options to be changed.

EXEC sp_configure ‘show advanced options’, 1

GO

—- To update the currently configured value for advanced options.

RECONFIGURE

GO

—- To enable the feature.

EXEC sp_configure ‘xp_cmdshell’, 1

GO

—- To update the currently configured value for this feature.

RECONFIGURE

GO

restart the services and done. all reports do not report any dsArea’. (rsErrorExecutingCommand) error.

Enjoy 🙂

 
Leave a comment

Posted by on December 21, 2012 in MSSQL, Tips

 

Tags: , ,

Cannot set a credential for principal ‘sa’. (Microsoft SQL Server, Error:15535)

In this Quick and dirty post, let’s see a simple fix for one of the annoying error messages you’ll see in SQL Server 2005. Basically, You’ll see below mentioned error in few cases when you try to change the sa password using SSMS.

The Simple trick is to check the box “Map to credential” as shown below after providing a new password and click Okay.

This should work…Hope this helps!

APPLIES TO
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
 
4 Comments

Posted by on December 11, 2012 in MSSQL, Tips

 

Tags: , , ,

SQL SERVER – ERROR: FIX – Database diagram support objects cannot be installed because this database does not have a valid owner

Recently one of my friend sent me email that he is having some problem with his very small database. We talked for few minutes and we agreed that to further investigation I will need access to the whole database. As the database was very big he dropped it in common location (you can use livemesh or dropbox  or any other similar product) and I picked up from the location.

I was able to install the database successful. He informed me that he has created database diagram so I can easily understand his database tables. As soon as I tried to open the database diagram I faced following error. For a while I could not figure out how to resolve the error.

Error:
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

Workaround / Fix / Solution :

Well for a while I attempted few things and nothing worked. After that I carefully read the error and I realized that solution was proposed in the error only. I just have to read it carefully. Here are the steps I did to make this work.

-- Replace YourDatabaseName in following script
ALTER AUTHORIZATION ON DATABASE::YourDatabaseName TO sa
GO

  • Select your database >> Right Click >> Select Properties
  • Select FILE in left side of page
  • In the OWNER box, select button which has three dots (…) in it
  • Now select user ‘sa’ or NT AUTHORITY\SYSTEM and click OK.

This should solve your problem.

Please note, I suggest you check your security policies before changing authorization. I did this to quickly solve my problem on my development server. If you are on production server, you may open yourself to potential security compromise.

Reference: Pinal Dave (http://blog.sqlauthority.com)

 
Leave a comment

Posted by on December 2, 2012 in MSSQL, Tips

 

Get to Know the New Shortcut Keys in Windows 8

You’ve probably already been using hotkeys in Windows 7 and previous versions, so now that Windows 8 is out, all you need to learn are the new shortcut keys. Here are the important new keys in a short list that you can easily learn.

New Windows 8 Shortcut Keys

There might be a couple of new keys that aren’t included in this list, but as far as we know, these are the most important ones.

  • Windows key – brings up the Metro start screen. You can start typing to search for an app, just like the Win7 start menu.
  • Win + D – brings up the old Windows desktop.
  • Win + C – brings up the Charms menu, where you can search, share, and change settings.
  • Win + I – opens the Settings panel, where you can change settings for the current app, change volume, wireless networks, shut down, or adjust the brightness.
  • Win + Z – opens the App Bar for the current Metro application.
  • Win + H – opens the Metro Share panel.
  • Win + Q – brings up the Metro App Search screen.
  • Win + W – brings up the Metro Settings search screen.
  • Win + F – brings up the Metro File search screen.
  • Win + K – opens the Devices panel (for connecting to a projector or some other device)
  • Win + ,  (comma) – Aero Peek at the desktop.
  • Win + .  (period) – Snaps the current Metro application to one side of the screen. (Right side)
  • Win + Shift + . (period)  – Snaps the current Metro application to the other side of the screen. (Left side)
  • Win + J – switches focus between snapped Metro applications.
  • Win + Page Up / Down – moves the current app to the other monitor.
  • Win + Tab – opens the Metro application switcher menu, switches between applications.

You might notice that we didn’t show screenshots of how all these shortcut keys work, and there’s a reason for that: you need to test them out for yourself to really learn how they work.

If there’s any other shortcut keys that are new to Windows 8 and we haven’t featured them, be sure to let us know in the comments.

 
Leave a comment

Posted by on November 27, 2012 in Tips, Windows8

 

Tags: , ,

 
%d bloggers like this: