Software
Nexus One – Android 2 – Eclipse
Jan 15th
Decided to revisit Android development due to the release of Google’s Nexus One Phone
Here are my steps so far:
- Download and install Eclipse Development environment from here [eclipse-jee-galileo-SR1-win32.zip ]
- Simply extract this to say, c:\eclipse
- Run eclipse
- Install Google’s ADT Plugin for Eclipse from here
- Download and install the SDK from here – in this case – up to Android 2.1, API 7, revision 1
- Extract above and run SDK Setup.exe – l had to to to the settings on the left hand side and check “force http…”, then choose accept all.
Transferring logins and passwords between SQL Server 2005 and SQL Server 2008
Jan 15th
This link is very useful and details how to transfer the logins and the passwords between instances of Microsoft SQL Server 2005, and Microsoft SQL Server 2008, on different servers. – Microsoft Knowledge Base: #246133
Microsoft SQL Server, Error: 15401
Jan 15th
Got this error a lot when trying to add NT user accounts on a SQL Server 2008 installation that was connected to a Windows 2008R2 server running Active Directory 2008 at Windows 2000 functional level. Same error message appeared when troubleshooting this from a SQL Server 2005 instance in the same server environment.
You’ll keep getting “Windows NT User or group ‘MyDomain\MyUser’ not found. Check the name again. Microsoft SQL Server, Error: 15401″
Azure sample database setup….
Dec 29th
Notes on setting up the sample database – adventureworks [click here] for Microsoft’s cloud computing sql server called Azure:
- you need an account – get one from sql.azure.com - it takes some time for your access information to arrive by email.
- download the sample database using link above
- extract/unzip to a known location
- make sure you add your home/work/workstation actual external facing ip address to the firewall settings
- wait for 5-10 mins for your ip address to be accepted by the azure online firewall system
- run the script commands below
See commands/reference pictures below:
Server Name: serverx serverx.database.windows.net
Administrator Username: userx
Server Location: South Central US
db name: ankh
cd dw
buildawdwaz.cmd tcp:serverx.database.windows.net userx@serverx passwordx
cd lt
buildawltaz.cmd tcp:serverx.database.windows.net userx@serverx passwordx
Business Intelligence w/SQL 2008
Dec 27th
Currently reading “Delivering Business Intelligence with Microsoft SQL Server 2008
Interesting quotes/definitions:
“Would you tell me please, which way I ought to go from here?” asked Alice.
“That depends a good deal on where you want to get to,” said the Cat.
“I don’t much care where,” said Alice.
“Then, it doesn’t matter which way you go,” said the Cat.
Alice’s Adventures in Wonderland
- Lewis Carroll
Planning ahead is a good idea. It wasn’t raining when Noah built the ark.
- Anonymous
He who has not first laid his foundations may be able with great ability to lay them afterwards, but they will be laid with trouble to the architect and danger to the building.
The Prince
- Niccolò Machiavelli
Business intelligence is the delivery of accurate, useful information to the appropriate decision makers within the necessary timeframe to support effective decision making.
Data mining uses a complex mathematical algorithm to sift through detail data to identify patterns, correlations, and clustering within the data.
Online analytical processing (OLAP) systems enable users to quickly and easily retrieve information from data, usually in a data mart, for analysis. OLAP systems present data using measures, dimensions, hierarchies, and cubes.
AdventureWorks…
Dec 24th
Adventureworks is a huge sample database of a make believe bike company provider by Microsoft, and l find this particularly useful when working on/learning OLTP and SSAS – ie Online transaction processing as well as SQL Server analysis services used to make business intelligence decisions, datamarts etc.
Helpful notes:
- download the latest version from codeplex – click here - the file l got was AdventureWorks2008_SR4.exe
- Run this program
- For installing SSAS - SQL Server Analysis Services database see this webpage
- Look for the install scripts in C:\Program Files\Microsoft SQL Server\100\Tools\Samples\
- dont forget to execute the scripts in sqlcmd mode,
Look for code like:
–:setvar SqlSamplesDatabasePath “C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\”
–:setvar SqlSamplesSourceDataPath “C:\Program Files\Microsoft SQL Server\100\Tools\Samples\”
In the scripts, in the sample source path folder on your workstation, make sure you modify and set correctly at least the top line for the sql samples database path
Also, make sure if you made modifications to your model database default size, you adjust the database file size in the create database portion of the script as eg:
CREATE DATABASE [AdventureWorks2008]
ON (NAME = ‘AdventureWorks2008_Data’, FILENAME = N’$(SqlSamplesDatabasePath)AdventureWorks2008_Data.mdf’, SIZE = 170, FILEGROWTH = 8),
FILEGROUP DocumentFileStreamGroup CONTAINS FILESTREAM ( NAME = FileStreamDocuments, FILENAME = N’$(SqlSamplesDatabasePath)Documents’)
LOG ON (NAME = ‘AdventureWorks2008_Log’, FILENAME = N’$(SqlSamplesDatabasePath)AdventureWorks2008_Log.ldf’ , SIZE = 2, FILEGROWTH = 96);
GO
Azure SQL….
Dec 24th
Adventure works sample databases are now available for Microsoft’s SQL Azure at codeplex – click here.
SQL Azure
Dec 6th
SQL Azure is a fully relational database in the cloud by Microsoft.
See this link for the main website.
For how to connect to Azure using ADO.Net heres a good link from msdn and another link which l’m currently using to work on plugging the northwind sample database to azure and using a WPF datagrid view to present the data.
Clickonce deployment issue….
Oct 30th
While deploying a Visual Studio Winform application using clickonce, the publishing goes okay but when l tried to run the setup program, l get this error message:
System Update required – The application requires that system.web.extensions version 1.0.61025.0 be installed in the global assemble cache (GAC) first.”
Clicking on the project properties in Visual Studio.Net, then references, l noticed this file exisits under C:\Program Files\Microsoft ASP.NET\ASP.NET 2.0 AJAX Extensions\v1.0.61025 – l copied this in a local \lib\ folder in my application source project folder, and referenced directly to it, rebuilt the application, republished it to our company shared folder and re-ran the setup.
collection_set_3_upload job keeps failing on uploading Query Statistics – SQL Server 2008
Oct 13th
Keep getting the error messages below from the logs:
To view the detailed logs in SSMS 2008:
Drill down on
Management -> data collection -> query statistics -> view logs
====== Error Messages Below=====
Event
Data Code
Message
SSIS error. Component name: DFT – Upload collection snapshot, Code: -1073450974, Subcomponent: SSIS.Pipeline, Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component “ODS – Upload snapshots into active_sessions_and_requests table” (2686) failed with error code 0xC0209029 while processing input “OLE DB Destination Input” (2699). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
.
============================
Message
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0×80004005.
An OLE DB record is available. Source: “Microsoft SQL Server Native Client 10.0″ Hresult: 0×80004005 Description: “Invalid character value for cast specification”.
An OLE DB record is available. Source: “Microsoft SQL Server Native Client 10.0″ Hresult: 0×80004005 Description: “Invalid character value for cast specification”.
An OLE DB record is available. Source: “Microsoft SQL Server Native Client 10.0″ Hresult: 0×80004005 Description: “Invalid character value for cast specification”.
An OLE DB record is available. Source: “Microsoft SQL Server Native Client 10.0″ Hresult: 0×80004005 Description: “Invalid character value for cast specification”.
An OLE DB record is available. Source: “Microsoft SQL Server Native Client 10.0″ Hresult: 0×80004005 Description: “Invalid character value for cast specification”.
==========
Event OnError
Data Code -1071607780
Message
There was an error with input column “collection_time” (2778) on input “OLE DB Destination Input” (2699). The column status returned was: “Conversion failed because the data value overflowed the specified type.”.
==============
Package Execution ID
Event OnError
Data Code -1071607767
Message
SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The “input “OLE DB Destination Input” (2699)” failed because error code 0xC020907A occurred, and the error row disposition on “input “OLE DB Destination Input” (2699)” specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
================
Package Execution ID
Event OnError
Data Code -1073450974
Message
SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component “ODS – Upload snapshots into active_sessions_and_requests table” (2686) failed with error code 0xC0209029 while processing input “OLE DB Destination Input” (2699). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Read the article on this link.
Solution above essentially worked for me, l changed my retries to 4 from 2 and re-ran the job. It ran okay. Still investigating this in depth.
