Welcome to Julian Kuiters Thursday, August 16 2018 @ 03:02 PM AEST

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

  • Contributed by:
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.

Permanently Redirecting Domain Pages with Geeklog

  • Contributed by:
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.

What I'm Reading 18 April 2007

  • Contributed by:
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

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

  • Contributed by:
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).

Suppressing Warnings in Data Dude

  • Contributed by:
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.