So these are really quick snippets. I hit an error where my Gateway monitoring software could not connect to the database. All the errors were along the lines of “Provider cannot be found” and when I looked in the Connection String it stated “Provider=SQLNCLI” which is the SQL Native Client...
I’ve recently moved the database behind DavidOverton.com (also uksbsguy.com) from a Windows Server 2003 system with SQL 2005 to Windows Server 2008 with SQL 2008. This would be the same process if you were potentially performing a migration from SBS 2003 with SQL 2005 to SBS 2008 Premium with SQL...
I’ve found myself moving datafiles around or backing up to new locations before enough that I need to change SQL to point to the new locations before it will start for me to do further work. The process to get it up and running is to find the SQL instance in the registry and change 3 values. The...
Hi, I know I’ve been away a lot recently (closing the year end and then doing some travelling for work), but while cleaning my inbox (ohh, 2500 mails processed, replied too, filed and actioned – yee har!) I came across this and it is bang up to date. SQL 2008 is going to be the hot, hot, hot product...
Remember that BI starts with data in Excel and then includes SQL and builds from there. One of the nice things is that BI is now accessible to any business that wants to analyse their business. Now all that is needed is the understanding of what questions do I want to ask and what data do I have that...
If you use Windows XP and need WDS to index Office 2007 files, or SharePoint, Search Server or any other product that used IFilters then this is the KB article and download for you. This obviously includes Windows Home Server which uses WDS to enable you to quickly search for a file on a file share from...
LINQ looks like another amazingly simple move for app developers (I've written a few DB apps myself over the years). While Microsoft provides support for Objects, SQL and XML, others provide for other platforms such as Oracle, MySQL and PostgreSQL ( http://code2code.net/DB_Linq/ ). The reason why...
From the TRM Blog at November 2007 - Technical Rollup Mail - SQL SQL 2005 Webcasts and Virtual Labs SQL Server 2005 is data management and analysis software that delivers enhanced security, availability, and scalability to mission-critical data applications—while making them easier to develop, deploy...
From the TRM Blog at November 2007 - Technical Rollup Mail - SQL Microsoft Synchronization Services for ADO.NET v2.0 CTP1 Microsoft Synchronization Services for ADO.NET provides the ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures. Rather than...
From the TRM Blog at November 2007 - Technical Rollup Mail - SQL Reporting Services in SQL Server 2008 Microsoft SQL Server 2008 Reporting Services provides a complete server-based platform that is designed to support a wide variety of reporting needs including managed enterprise reporting, ad-hoc reporting...
I just found the MSDN Evaluation Center online today to give you evaluation resources that you might develop against. These include BizTalk Server, Office Communication Server, Office Enterprise , SharePoint Server, SharePoint Designer, SQL Server 2005, 2008, Express 2005 SP2, Windows Server 2008. I've...
Posted to
David Overton's Blog
by
David Overton
on
Wed, Nov 28 2007
Filed under:
Filed under: Office System, Support and Tools, Developer, SQL Server, beta, Office 2007, Documentation, Marketing, Tips, Trial, Partner, SQL Server 2005, Windows Server 2008, Unified Communications, SQL Server 2008, Office Communication Server
This is an extract from the TRM blog which can be found here http://blogs.technet.com/trm/ . I have removed the KB article list and some items which I don't think are relevant to small business / ISV partners, however the full info can be found on the blog page too Documents SQL Server 2008 Product...