Browse by Tags

All Tags » SQL Server (RSS)
Installing WordPress using Microsoft Web Platform Installer (Web PI) v2.0
Microsoft Web Platform Installer (Web PI) is a free tool that makes getting the latest components of the Microsoft Web Platform easy. This includes the latest Visual Web Developer 2010 Express, ASP.NET 4, and ASP.NET MVC2. Web PI can also be used to download...
Posted Sun, Apr 25 2010 by Martin Poon | with no comments
Filed under: , , , , , , ,
SQL Server Configuration Manager – Cannot connect to WMI provider – Invalid class [0x80041010]
When I am trying to connect to my SQL Server 2008 box using SQL Server Configuration Manager today, the following error dialog pops up… Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage...
Posted Fri, Nov 27 2009 by Martin Poon | 1 comment(s)
Filed under:
SQL Server 2008 SP1 is released. Get your copy here!
~ SQL Server 2008 SP1 http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en ~ SQL Server 2008 Express Edition SP1 http://www.microsoft.com/downloads/details.aspx?familyid=01AF61E6-2F63-4291-BCAD...
Posted Thu, Apr 9 2009 by Martin Poon | with no comments
Filed under: , ,
SSMS - Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft .VisualStudio .OLE .Interop .IServiceProvider'. Exception from HRESULT: 0x80004002 (E_NOINTERFACE))
I am working on Windows Server 2008 SP1 Datacenter Edition 64-bit , with SQL Server 2008 installed. After installing Windows IE8, I got the following error upon starting SQL Server Management Studio (SSMS) 2008. ===== Error 0x80004002 ===== SSMS - Unable...
Posted Fri, Mar 20 2009 by Martin Poon | 7 comment(s)
Filed under: ,
SSIS – Converting string / numeric (yyyymmdd and hhmmss) to datetime inside Derived Column Transformation Editor
It takes me some time to figure out how a string / numeric value can be converted to a datetime value inside the Derived Column Transformation Editor of SSIS, and so, I would like to share my $0.20 here (in order to save others’ $0.20).   :...
Posted Tue, Mar 17 2009 by Martin Poon | with no comments
Filed under:
Microsoft Certification Exam – 10% discount voucher
Great news – Microsoft is offering self-paced, eLearning collections to you when you sign up for the Certification Campaign using the code HKEBA99B . You will enjoy a eLearning collection at US$35 for a 90-days use. This is a great resource for those...
Posted Wed, Feb 18 2009 by Martin Poon | 2 comment(s)
Filed under: , , ,
Upgrade and migration to SQL Server 2008 webcast
SQL Server 2008 is released, and you are invited to join this webcast that highlights the tools and procedures to make your move to SQL Server 2008 easy and troublefree. *** For more information ~ Upgrade and migration to SQL Server 2008 webcast http...
Posted Fri, Aug 8 2008 by Martin Poon | with no comments
Filed under: , , ,
Microsoft SQL Server 2008 { JumpStart }... your data, any time, any place
Microsoft SQL Server 2008 { JumpStart } @ http://sqlserver2008jumpstart.microsofttraining.com This site contains presentations, recordings, hands-on labs and demonstrations for the SQL Server 2008 JumpStart technical training event, while there are 5...
Posted Thu, May 8 2008 by Martin Poon | with no comments
Filed under: ,
Writing the first SQL Server database .NET application
Just listing a few getting-started links for developing SQL Server .NET application. ~ SQL Server 2005 Express Edition - Sample Rich Client and Web Applications http://msdn2.microsoft.com/en-us/express/bb403187.aspx ~ SQL Server 2005 Express Edition ...
Posted Mon, Mar 24 2008 by Martin Poon | with no comments
Filed under: , ,
Installing Components... Full Installation of Visual Studio 2008 Professional Edition
Just got the *full* installation of Visual Studio 2008 Professional Edition done on an Vista Ultimate box (x64), and, here is the ...long... list of components that are installed! - Runtime Pre-requisites - Microsoft .NET Framework v3.5 (x64) - Microsoft...
Posted Sun, Mar 9 2008 by Martin Poon | 1 comment(s)
Filed under: , , , , , , ,
SQL Server 2008 CTP 6 (February 2008) is available for { evaluation }
This build should be { feature complete }, and is available in the following languages. >> Chinese (Simplified), Chinese (Traditional), English, French, German, Italian, Japanese, Korean, Russian, and Spanish === For more information === ~ Evaluate...
Posted Sun, Feb 24 2008 by Martin Poon | 1 comment(s)
Filed under: ,
.NET Framework 3.5 full package
Have just got the link to download the full package of .NET Framework 3.5. This is a 197 MB standalone executable file that contains all the components that are required to deploy to 32-bit and 64-bit platforms on all supporting operating systems. (The...
Posted Sat, Jan 26 2008 by Martin Poon | 8 comment(s)
Filed under: , , , , ,
Free SQL Server 2008 test drive program
SQLServerBeta is offering a free SQL Server 2008 online testing account for the community. Sign up at http://www.sqlserverbeta.com , and get the chance to experience the latest SQL Server 2008 technologies online, using your own set of data.
Posted Fri, Jan 25 2008 by Martin Poon | with no comments
Filed under:
SQL Server Management Studio - standard reports in the Summary Page
In SQL Server Management Studio, the Summary Page can be displayed at any time by pressing F7 (or, to be chosen from the menu --> View --> Summary). When you select an item in the Object Explorer of SQL Server Management Studio, information about...
Posted Thu, Nov 1 2007 by Martin Poon | 2 comment(s)
Filed under: ,
TechNet webcast: Advanced Manageability for SQL Server 2008 Analysis Services on 2007.10.10
With the release of SQL Server 2008 Analysis Services, Microsoft introduces several advanced features for manageability and one such feature is Dynamic Management Views (DMV). These views enable administrators to query for information regarding connections...
Posted Mon, Oct 8 2007 by Martin Poon | with no comments
Filed under: , ,
Microsoft Query - ODBC data source - Error 2571 - User 'xxxx' does not have permission to run DBCC TRACEON
Upon querying SQL Server 2005 using an ODBC data source in Microsoft Excel 2000... You may encounter the following error. Microsoft SQL Server Login Connection failed: SQLState: '37000' SQL Server Error: 2571 [Microsoft][ODBC SQL Server Driver...
Posted Fri, Jul 6 2007 by Martin Poon | 1 comment(s)
Filed under: , ,
SQL Server 2005 Books Online (May 2007)
The latest version of SQL Server 2005 Books Online (May 2007) is now available at http://www.microsoft.com/downloads/details.aspx?familyid=be6a2c5d-00df-4220-b133-29c1e0b6585f&displaylang=en
Posted Tue, Jun 5 2007 by Martin Poon | with no comments
Filed under: ,
SQL Server 2008 Community Technology Preview (CTP)
SQL Server 2008 CTP is now available at Microsoft Connect. ===== For more information ===== ~ Connect: SQL Server 2008 CTP https://connect.microsoft.com/sqlserver
Posted Tue, Jun 5 2007 by Martin Poon | with no comments
Filed under: , , ,
[Hong Kong] Microsoft Business Intelligence Conference on 2007.06.20 (Wed)
The first-ever Microsoft BI Conference is going to be held in Hong Kong this month, after the successful launch of the same conference in Seattle, Washington! You will be able to learn more about powerful BI insights using SQL Server 2005 SP2, PerformancePoint...
Posted Thu, May 31 2007 by Martin Poon | with no comments
Filed under: , , , ,
Remote Keys release candidate (RC1) is now available
Remote Keys release candidate (RC1) is now available. Remote Keys allows you to define and enforce cross databases integrity constraint. With Remote Keys, you can create a foreign key between two tables located in distinct SQL Server databases. =====...
Posted Tue, May 22 2007 by Martin Poon | with no comments
Filed under:
More Posts Next page »