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...
If you don't know about the Heroes Happen Here :: Home campaign then you are very much behind the times. The Launch events for SQL Server 2008 (errrm), Visual Studio 2008 and Windows Server 2008 are fast approaching and so is your customers ability to buy and use them - do you understand what, why...
Posted to
David Overton's Blog
by
David Overton
on Tue, Jan 29 2008
Filed under: Support and Tools, Virtualisation, Developer, SQL Server, Community, Event, Training, Tips, x64, Partner, Terminal Server, Windows Server 2008, ISV, IIS, SQL Server 2008, Visual Studio
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...
Posted to
David Overton's Blog
by
David Overton
on Fri, Jan 18 2008
Filed under: Support and Tools, Developer, SQL Server, Training, Tips, SQL Server 2005, SQL Server 2008, Visual Studio
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...
Posted to
David Overton's Blog
by
David Overton
on Thu, Dec 6 2007
Filed under: Support and Tools, Business, SQL Server, Event, Training, Tips, SQL Server 2005, SQL Server 2008
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...
Posted to
David Overton's Blog
by
David Overton
on Wed, Dec 5 2007
Filed under: Windows Mobile, Developer, SQL Server, Documentation, mobile, Tips, SQL Server 2005, SQL Server 2008