Welcome to Julian Kuiters Saturday, October 20 2018 @ 08:19 PM AEDT

Julian!? Where are you?

General News Well I've definitely been "missing" on my blog lately. Between work commitments, a long daily commute, and personal projects, I've had no time to post much content on my website.

As of last week, I started working some days remotely; from home. Its been quiet a good change, and now that I have less distractions: I get a lot more work done. I've be able to finish off a lot of interrupted tasks. Get my head around how to organise and structure my day when working from home. I'm more focused, planned, and driven. I'm delivering more results each day, and as a result having more time for taking on more responsibilities comfortably.

But working remotely isn't all about work. Its also about re-gaining some of your personal time. I was spending about 10-15 hours per week travelling to work in my car. I planned my travel to try and avoid peak hour traffic, but where my employer is situated there are no direct travel routes. Public transport (commuter train & bus or bus & ferry & bus or bus & bus & bus & bus) would have seen me spending twice as long driving each day. My car has an awesome stereo, so the drive is not too stressful most days.

Ah! Again! Talking about work and the commute! See how I never got time for myself?

So now that I'm actually getting a few days a week working from home, I have time to get more things done. I'm not as tired. My energy level has sky rocketed. And my relationship has definately benefited. I've got time to persue more study, more personal projects, art, catch up with friends, and get back to writing useful tips for other SQL Server users.

Work has also benefitted. I've started to take an interest in managing myself more and co-ordinating my work with others better. Whilst working from home is ultimately a selfish want, it is definately improving my team skills.

So over the next coming weeks, expect a lot more from me. I'll be posting regularly on SQL Server 2005, including scalability with Service Broker and Notfication Services, Management Studio, and Visual Studio for Database Professionals especially Unit Tests.

So if you have any lagging questions or a SQL problem you'd like some tips for, send me an email sqlquestiokuiters.id.au

Excitedly home,
Julian




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.

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.

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

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).

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.