OS X: Getting the MAC Address of Your Wireless Networking Adapter

The first step is to click on the "Wireless Network" icon that should be at the top right on your statusbar;Wireless Networking IconClick on "Open Network Preferences ..." at the bottom;Network PreferencesMake sure you have selected your Wi-Fi connection in the list on the left and then click on the "Advanced" button at the bottom right;Advanced Network SettingsThe MAC Address is highlighted in the image abo...

Read More

Oracle PL/SQL: How Big Are My Tables?

As part of a change request I just happened to need to get a "ball-park" figure on the sizes of some of the key tables in a schema. For that reason I put together the following PL/SQL;SELECT NVL(di.table_name, DS.segment_name) "Table Name",       ROUND((sum(ds.bytes) / 1048576 /* 1 MB in bytes */), 3) "MB"  FROM dba_segments DS  LEFT JOIN dba_indexes DI    ON DI.owner = DS.owner   AND DI.index_name = DS.segment_name WHERE 1 = 1   AND DS.segment_type IN ('INDEX', 'TABLE')  ...

Read More

Accessing Free Audiobooks via Cambridgeshire Libraries Online

The first step is not at all really surprising; you need a library card (if nothing else this acts as proof that you are resident in the Cambridgeshire County as they have to post it out to you). If you don't have one already you can apply for one via this link;https://cambridgeshire.spydus.co.uk/cgi-bin/spydus.exe/MSGTRN/OPAC/BRWREGAlternatively a short link is available - http://goo.gl/jOVG3It takes about 7-10 days for you to get your card (and...

Read More

SQL Server: Installing BIDS 2008R2 (Developer Edition)

After inserting the CD and running the Setup.exe the following User Account Control (UAC) dialog will appear;SQL Server 2008 R2 UAC DialogClick "Yes".The SQL Server Installation Center dialog will now appear;SQL Server Installation CenterClick on "Installation" on the left (highlighted above);SQL Server Installation Center (Installation Page)Click "New installation or add features to an existing installation" (the top option on the right);SQL Server...

Read More

SSIS: Creating a Job To Run An SSIS Package On A SQL Server

For this blog post I'm going to use the test SSIS package I created as part of the "Exporting Query Results To A Flat File"-blog post, and had previously deployed to SQL Server (see "Deploying A Package To A Remote SQL Server") because it's all setup and I know it works.Start SQL Server Management Studio;Management Studio: Connect to ServerMake sure you select "Database Engine" in the "Server type" drop down. Click "Connect";SQL Server: Object ExplorerExpand...

Read More

SSIS: Deploying A Package To A Remote SQL Server (And Testing It)

The blog post covers deploying a package onto a server (and then running it). I'm going to use the test package I created in the blog post "Exporting Query Results To A Flat File" as it's as good as any and doesn't rely on anything tricky. I also know that the domain user who is running the Server has permissions to see the G drive I'm trying to write to so I can eliminate that as a potential error!Open the project in BIDS and right-click the project...

Read More