This is a video tutorial on installing the Adventure Works sample database onto SQL Server Express 2005 on Windows Server 2003. The Adventure Works samples are not included with SQL Server Express and need to be installed for many tutorial ( including mine ) that are out there.
Tag Archive 'SQL Server'
SQL Server Sample Databases
Posted in Computers on Aug 23rd, 2008
Well, if anyone ever needed evidence that Microsoft is getting ready for an implosion / explosion just go check out the new SQL Server Sample Database site at CodePlex. Seriously, if this is not the most convoluted, messed up joke of a site I don’t know what is.
Do you people just sit around thinking [...]
Sharepoint SQL Server Connections
Posted in Computers on Aug 1st, 2008
SQL Server tables and stored procedures CAN be accessed from Sharepoint and Infopath, BUT it is not recommended to do it directly. Serious. Can’t tell you strongly enough.
Use Web Services to query SQL Server from Sharepoint or Infopath.
Use SQL Server Reporting Services to report and showcase data in Sharepoint.
More on this later as this is [...]
iPhone as Mobile IT Management Platform
Posted in Computers on Jul 17th, 2008
Computerworld gets it. The new iPhone is so good at web tasks it could be used as a mobile platform or dashboard to admin an entire network. With the advent of Ajax and the object oriented libraries with which one can programmatically accomplish administration ( say that three times fast ), the iPhone is primed, [...]
Scripting SQL Server Databases
Posted in Computers on Jul 16th, 2008
The Database Publishing Wizard is THE tool to use when one needs to script both data and schema for deployment around the office or world. Get it here!
Of course it would not be Microsoft if every thing worked smoothly and this is no exception You will find the scripts this tool generates will NOT [...]
Biztalk 2006 R2 Under Vista
Posted in Computers on May 8th, 2008
Biztalk from your Vista development station can be an interesting and sometimes frustrating experience. Here are some bookmarks to articles that might help with this process.
From Microsoft:
Biztalk configuration or installation because of CAB file issues KB942181
Biztalk does not start correctly under Vista. Set delayed start for the service as it depends on ESS ( Enterprise [...]
Microsoft, Clueless or Sadist
Posted in Computers on Feb 12th, 2008
I just had to reinstall SQL Server 2005 AGAIN on Windows Vista. Why, oh I don’t know, perhaps I have a bit too much enthusiasm. Sadly, this routine is a normal thing in the Microsoft world. To put this in perspective, I have NEVER, EVER had to reinstall ANY of my Apple tools for development. [...]