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...
Posted to
David Overton's Blog
by
David Overton
on Tue, Jul 15 2008
Filed under: Developer, SQL Server, Microsoft, Training, Partner, SQL Server 2005, SQL Server 2008
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...
Posted to
David Overton's Blog
by
David Overton
on Sun, Jan 27 2008
Filed under: Windows SharePoint Services, SQL Server, Exchange, Windows Home Server, SQL Server 2005, SharePoint, SQL Server 2008, Search
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