Clicks.tui.pl

I have a seen a serious performance dive when moving from SQL Server 2008 R2 to SQL Server 2012 on my linked server queries. I have set the linked server on the 2012 server as a Microsoft OLE DB Provider for ODBC Drivers that links through a DSN which...

The Redgate DLM Automation team that we’re part of recently took time out from development to explore some of the issues our customers face when automating deployment of database changes.  As part of that exercise, we took a closer look at cross-database...

1. Install Oracle Client where MSSQLSERVER is running. I've used 11.2.0 client for my case. 2. Add oracle TNS Entries for the target Oracle Database. TNS location would be: $ORACLE_HOME/network/admin/tnsnames.ora Here is a sample TNS file. You...

I have an excel 2007 file with about 301808 rows and 2 columns. I was trying to use SSIS to import but cant use 2007 excel. I then decided to try and make a linked server in SQL Server, Following the instructions here: In SQL Server Management Studio...

In my previous post I discussed about querying Excel files with both 2003 & 2007 versions from SQL Server. Here we will see how can we query Excel 2010 files. Will use the same scripts from my previous post to create Linked Server to point to the...