Email Article To a Friend View Printable Version

How to Connect to a SQL Server Compact Edition Database with Management Studio

SQL Server 2005 Compact Edition

Open a new connection by choosing File menu -> Connect Object Explorer in SQL Server Management Studio.

Change the Server Type to SQL Server Compact Edition.

For Database file: put the full path to an existing SQL Server Compact Edition .sdf file; click the drop-down button, and select New Database or Browse to locate a .sdf file.

Enter a password if required.



Share
  • Facebook
  • Google Bookmarks
  • Ask
  • LinkedIn
  • Socialogs
  • Wikio
  • Digg
  • Twitter
  • SlashDot
  • Reddit
  • MySpace
  • Del.icio.us
  • Blogter
  • BlogMemes
  • Yahoo Buzz




Email Article To a Friend View Printable Version

Permanently Redirecting Domain Pages with Geeklog

GeekLog

I have a number of domain names and previously blogged on how to make Geeklog work on all of them.

I’ve decided now to concentrate on one domain name: julian-kuiters.id.au

There is already a number of links to my other domains, so I needed to configure Geeklog to redirect people to the new domain. I think that re-direct pages are pretty annoying, so I opted to use “HTTP/1.1 301 Moved Permanently” to indicate to browsers and search engines the new address.

After quite a few attempts at inserting the redirect code in the theme, I opted to place it in the lib-common.php file.

The basic code to redirect any connects not on my primary domain is:

	if ($_SERVER['SERVER_NAME'] != 'www.julian-kuiters.id.au')
      {
 		header("HTTP/1.1 301 Moved Permanently"); // Convert to GET
		header("Location: http://www.julian-kuiters.id.au" . $_SERVER['REQUEST_URI']);
    		header('Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0');

      }

And I inserted it into the function COM_siteHeader of lib-common.php

function COM_siteHeader( $what = 'menu', $pagetitle = '', $headercode = '' )
{
    global $_CONF, $_TABLES, $_USER, $LANG01, $LANG_BUTTONS, $LANG_CHARSET,
           $LANG_DIRECTION, $_IMAGE_TYPE, $topic, $_COM_VERBOSE;


	//jkuiters 20070420
	if ($_SERVER['SERVER_NAME'] != 'www.julian-kuiters.id.au')
      {
 		header("HTTP/1.1 301 Moved Permanently"); // Convert to GET
		header("Location: http://www.julian-kuiters.id.au" . $_SERVER['REQUEST_URI']);
    		header('Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0');

      }

    // If the theme implemented this for us then call their version instead.

    $function = $_CONF['theme'] . '_siteHeader';

As you can now see, the same url on different domains automatically takes you to the correct site.



Share
  • Facebook
  • Google Bookmarks
  • Ask
  • LinkedIn
  • Socialogs
  • Wikio
  • Digg
  • Twitter
  • SlashDot
  • Reddit
  • MySpace
  • Del.icio.us
  • Blogter
  • BlogMemes
  • Yahoo Buzz






Email Article To a Friend View Printable Version

What I'm Reading 18 April 2007

What I'm Reading

International Considerations for Database and Database Engine Applications
 http://msdn2.microsoft.com/en-us/library/ms190245.aspx

Strategies for Partitioning Relation Data Warehouses in SQL Server
http://www.microsoft.com/technet/prodtechnol/sql/2005/spdw.mspx

Physical Database Storage Design
http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx

International Considerations for Notification Services
http://msdn2.microsoft.com/en-us/library/ms172557.aspx

How MSN Messenger and MSN Hotmail scales with SQL Server 2005
http://www.microsoft.com/technet/prodtechnol/sql/2005/scddrtng.mspx

Scaling out SQL Server 2005
http://msdn2.microsoft.com/en-us/library/aa479364.aspx

Database Mirroring FAQ
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirfaq.mspx

Database Mirroring
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

SQL Server 2005 Mission Critical High Availability
http://www.microsoft.com/technet/prodtechnol/sql/themes/high-availability.mspx

SQL Server 2005 High Availability
http://www.microsoft.com/sql/technologies/highavailability/default.mspx

SQL Server 2005 Failover Clustering White Paper
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en

Achieving Massive Scalability with SQL Server
http://www.sql-server-performance.com/dk_massive_scalability.asp

Clustering
http://www.sql-server-performance.com/rn_sql_server_clustering_2000_to_2005_1.asp

SQL Server 2005 Clustering Best Practices
http://www.sql-server-performance.com/bm_clustering_best_practices.asp



Share
  • Facebook
  • Google Bookmarks
  • Ask
  • LinkedIn
  • Socialogs
  • Wikio
  • Digg
  • Twitter
  • SlashDot
  • Reddit
  • MySpace
  • Del.icio.us
  • Blogter
  • BlogMemes
  • Yahoo Buzz






Email Article To a Friend View Printable Version

SQL Server 2005 - Service Pack 2a (SP2a) Update

SQL Server 2005

Downloaded and installed Service Pack 2 for SQL Server 2005? Well here's a reason to download and apply it again.

A few days after releasing Service Pack 2 for SQL Server 2005, Microsoft has re-released it with an additional fix for maintenance plans. If you have already applied SP2, you will need to apply this critical patch. If you are not sure if the updated service pack 2a has been applied to a server, this kb article explains how to check the affected files.

The new Service Pack (SP2a) includes all the fixes for SP2, as well as improvements to the engine and tools.

While you are at it, don't forget that Updated SQL Server 2005 Books Online (help) Available Now (Feb 2007).



Share
  • Facebook
  • Google Bookmarks
  • Ask
  • LinkedIn
  • Socialogs
  • Wikio
  • Digg
  • Twitter
  • SlashDot
  • Reddit
  • MySpace
  • Del.icio.us
  • Blogter
  • BlogMemes
  • Yahoo Buzz






Email Article To a Friend View Printable Version

Updated SQL Server 2005 Books Online (help) Available Now (Feb 2007)

SQL Server 2005

As SQL Server 2005 continues to grow and change, the Books Online / help files are also updated.

Keep your help files up-to-date by downloading the latest copy.

Download SQL Server 2005 Books Online Feb 2007 version.



Share
  • Facebook
  • Google Bookmarks
  • Ask
  • LinkedIn
  • Socialogs
  • Wikio
  • Digg
  • Twitter
  • SlashDot
  • Reddit
  • MySpace
  • Del.icio.us
  • Blogter
  • BlogMemes
  • Yahoo Buzz






Email Article To a Friend View Printable Version

Suppressing Warnings in Data Dude

VSTS for Database Professionals

I've been working on migrating existing SQL Server database projects into Visual Studio for Database Professional projects. Most of the existing databases have imported without major problems, but there are a few that have warnings about cross-database joins in old unit tests.

TSD3025: The following cross-database dependencies could not be verified: ... Your database application might fail at runtime when ... is executed.

If you are tired of being warned about a known issue, Data Dude allows you to suppress warnings, in the database project's build properties (Project -> Properties -> Build tab -> Suppress Warnings).

Simply put the warning numbers you want to ignore in there (without "TSD" at the front) and save. Separate numbers with a semi colon (" ; ").

For a complete list of the errors in Data Dude, see Gert's page.



Share
  • Facebook
  • Google Bookmarks
  • Ask
  • LinkedIn
  • Socialogs
  • Wikio
  • Digg
  • Twitter
  • SlashDot
  • Reddit
  • MySpace
  • Del.icio.us
  • Blogter
  • BlogMemes
  • Yahoo Buzz







Gold Coast Aquarium Maintenance | Gold Coast Marine Fish | Gold Coast Tropical Fish
Jewel Jones - Counselling Service - Penrith, Richmond
 
     
 Copyright © 2017 Julian Kuiters
 All trademarks and copyrights on this page are owned by their respective owners.