$100,000 for the first individual or group to discover a 10,000,000 digit prime number. A prime number is a whole number that can only be divided exactly by 1 and itself. eg the first 6 prime numbers are: 2, 3, 5, 7, 11, 13
Free redgate eBook here on how to be an exceptional DBA – database administrator, DBA best practices etc.
I use and work on Silverlight 2 development using Microsoft Visual Studio 2008. Heres an interesting development l just found out about callled Moonlight, which is geared towards being an open source implementation for unix/linux. Cant wait to try this on my linux distro Fedora. Heres the website link: http://go-mono.com/moonlight/
Another interesting development to watch is: eyeOS – web based operating system – see: http://eyeos.org/en/
Here is a code snippet l got working which enables you to render using Visual Basic .Net an SSRS (Sql Server Report Services) Report to Adobe Acrobat PDF format or Microsoft Excel XLS file.
Public Sub RenderReportTOExcel(ByVal inReportFileName As String, ByVal inReportName As String) ‘7/14/2008 SM
‘converts SSRS report to microsoft excel/acrobat pdf file
Dim objReportViewer As New FrmWithReportViewer
‘Dim strFormat As String = “PDF”
Dim strFormat As String = “Excel”
Dim strDeviceInfo As String = String.Empty
Dim myURLAccessParams As System.Collections.Specialized.NameValueCollection = Nothing
Dim reportStream As System.IO.Stream = Nothing
Dim strMimeType As String = String.Empty
Dim strFileNameExtension As String = String.Empty
Dim file_name As String = “d:test001.xls”
objReportViewer.Text = inReportName
OFD.FileName = “exportfile.xls”
file_name = OFD.FileName
Dim raw As System.IO.FileStream = New System.IO.FileStream(file_name, IO.FileMode.Create)
Dim buffer(1024) As Byte
Dim read As Integer = -1
Dim intCount As Integer = 1
.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote
.ServerReport.ReportServerUrl = New Uri(My.Settings.ReportServerURL)
.ServerReport.ReportPath = My.Settings.ReportPath + inReportFileName
reportStream = .ServerReport.Render(strFormat, strDeviceInfo, myURLAccessParams, strMimeType, strFileNameExtension)
lblMessage.Text = “Working…”
read = reportStream.Read(buffer, 0, buffer.Length)
While (read > 0)
raw.Write(buffer, 0, read)
read = reportStream.Read(buffer, 0, buffer.Length)
intCount += 1
lblMessage.Text = “Completed.”
raw = Nothing
reportStream = Nothing
I use Kaspersky internet security version 220.127.116.11, recently my vista/internet explorer kept crashing/giving this error message – “a runtime error has occured. Do you wish to debug? Line 1: invalid character” and windows offered to check for a solution. This feature is very useful and does work. You can also get at it by going to the control panel, then selecting the problem reports and solutions link. It maintains a list of unresolved problems and suggested solutions. In my case, it said:
Run the Kaspersky Anti-Virus tool to fix this problem
This problem was caused by Kaspersky Anti-Virus, which was created by Kaspersky Lab.
To solve this problem, you will need to run the automatic update tool that comes with Kaspersky Anti-Virus. Go online to learn how to use the tool:
It also had links to the Kaspersky website update tools section. This problem seems to be resolved with after downloading and installing their update kav18.104.22.1687en.exe
Related to this, l also went ahead and installed as suggested by Vista:
This problem was caused by a compatibility issue between this version of Windows and this version of Visual Studio 2005. This program was created by Microsoft.
To solve this problem, go online and install the following updates:
Virtual PC 2007
Using Microsoft Virtual PC 2007, selecting other allows you to install Windows 2008 Server as l have successfully done on a Microsoft Vista Ultimate workstation and a Windows XP workstation. To add the essential Virtual Machine Additons under the action menu, make sure you are logged into the Virtual Operating System. After this, you can now go to the Edit menu/Settings and add say Shared Folders.
Installing SQL Server 2008
On server configuration, when you get this error message ” Must provide AGTSVCACCOUNT parameter” – heres what worked for me. Set sql server agent, sql server (MSSQL), sql server analysis, SSRS, SSIS with blank passwords, but NT_AUTHORITYNETWORK SERVICE as username. For SQL Server Browser – it defaults to NT AUTHORITYLOCAL SERVICE.
Windows Server 2008
Heres the error l get trying to log into my Windows 2008 server remotely.
” To log on to this remote computer, you must be granted the allow log on through terminal services right. By default, members of the remote desktop users group have this right. If you are not a member of the remote desktop users group or another group that has this right, or if the remote desktop user group does not have this right, you must be granted this right manually”
To get Remote Desktop to work, add the user as a menber of the Remote Desktop users group AND also, go to the local security policy, Local policies branch, right click on Allow log on through terminal services properties, and add the Remote Desktop Users group. You do not need to install Terminal Services Server to get this to work.
Please note visitors, that this website will soon undergo a migration to web hosting featuring asp.net, sql server, silverlight and associated Microsoft .Net/ASP.Net technologies. This will allow me intergrate some cool emerging new features seen in most current websites including microsoft.com, myspace.com, facebook.com, dell.com and many more.
These all will now be featured on a duplicate mirror domain: http://www,mbah.us
My Dell server came with 1Gb (512Mbx2) 80Gb. Over time, l’ve upgraded it to 1.6Tb (160Gb+500Gb+500Gb) storage capacity and yesterday l added 2x 1Gb ECC 533Mhxz DDRs bought online from Crucial Memory to bring up the memory to 3Gb. Then l decided to try out installing the new Windows 2008 server – 64bit version. Here are some notes/comments.
- I noticed the time it takes before you get to the server login screen was much more shorter compared to Windows 2003 with the same server hardware. I dont know if this is because of the obvious performance enhancement by Microsoft or the 64bit version OS. I suspect its the former.
- After installing W2008, you’ll need to set up by default a strong password. In Windows Server 2003 this was suggested but you can skip it. Now its enforced before you can do anything else.
- Remote Desktop is turned off by default, and now has a new secure RDC option when you turn it on.
- On Server management, creating an AD (Active Directory) Forest preceeds being able to do anything else.
- When creating a share folder, the everyone group doesnt appear by default. You have to setup users/groups and add their specific access permissions.
Watch this development – Open source Windows XP – React Operating System
Interesting Video from University of Washington on Google Linux cluster
Recommended (software l’ve tried and found very useful compared to various similar options, all those listed below work on Windows vista also):
- MP3Tag – the universal tag editor
- GIMP – GNU image manipulation program
- Ccleaner – system optimizer and privacy tool
- Kaspersky internet security – Best non-intrusive antivirus, privacy and firewall program l’ve used so far
- Easy Duplicate Finder – Very, very good and works on XP/Windows 2003 server/vista etc – saved me tons of space on my file server
Finally got fed up with software compatibility issues and slow response with Vista premium that came pre-loaded on my Hp 6626us laptop compared to windows XP. Now the pain, uninstalling /downgrading to Windows XP. First – l tried copying the c:users folder to my western digital MyBook external usb drive as advised in PC Magazine issue for 5/2008. Kept getting Low memory error while doing this. Googled for help, and found out theres a Memory leak error known to Microsoft and l can only get the hotfix by registering for this on their website and waiting for a reply within about 8 business days. Finally decided to try xcopy from the command line. Vista kept suggesting l used the robocopy new command. I found this fails due to permissions for certain files. finally used xcopy with options for continue on error, copy all files and subdirectories. After about an hour, l had a 28Gb copy of my crucial filess. Next step, rebooting with my original XP CD. Problem – cant get into the recovery mode without the administrator password which the command lusrmgr.msc doesnt bring up. Now l find this out from the hp solutions section for their pavilion laptops:
“To logon as the Administrator, the Administrator account must be activated in Vista. By default, in Windows Vista, the Administator account is created but is not enabled.
In the Windows Vista Starter, Windows Vista Home Basic, and Windows Vista Home Premium editions, you cannot access or change the Administrator account.
In the Windows Vista Ultimate editions you can access and change the Administrator account.”
So, how can l run the following commands for preparing the laptop hard drive for XP: fixboot fixmbr cd ren windows winvista exit, from the Recovery console command prompt when l dont have access to the administrator account under Vista premium? Will let you all know how l resolve this.
Update – Finally decided to upgrade my Windows Vista Premium to Vista Ultimate, which has most administrative functionality l’m used to from Windows XP. Plus l can run VPC2007 – Virtual PC 2007. Note – If you use 3DSMax 9 and have issues/errors running this under Windows Vista, simply go to the Autodesk website, support section and install SP1, then SP2. Now l;ve got to find the solution to the annoying clicking sound problem which seems to be related to a soundcard driver issue with Vista.
Changing the OEM Settings and logo in Vista:
Simply run regedit, and go to
You can create your own logo, as l did, simply create a 120×120 pixels BMP file and upload to c:windowssystem32oobe
If you try to install SQL Server 2005 SSRS – Reporting Services on Vista and it keeps failing saying IIS not found, follow this article – installing IIS7 on Vista. Apparently, when you install IIS 7 from the control panel, not all features are installed if a blue box shows, you need to see a check mark on the box next to IIS components for a full installation. Once this is done, the SQL Server 2005 install will allow you to install all components, especially sql server reporting services.