Tags » SQL

Accessing Filemaker Pro Server 11 via ODBC/SQL

Anyone who has tried to access Filemaker Pro Server (and Server Advanced) data via ODBC, has probably run into the myriad of weird issues. In this post, I’ll try and catalogue some of them, to help anyone else forced into this desperate method of communication. 380 more words

Python

SQL SERVER - 2016 FIX: Install – Rule "Oracle JRE 7 Update 51 (64-bit) or higher is required" failed

I enjoy spending time with my daughter almost every single day. It keeps me busy at home and most importantly, some quality time with her allows me to relax after a long day at work. 397 more words

SQL Authority

Combine and then split tsql insert statement files into batches of one thousand.

Recently I was given the task of executing hundreds of prepared sql files some containing multi-row insert statements numbering in the tens of thousands.

So I encountered two problems with this: 890 more words

T-SQL

How to Delete Metalogix Content Matrix Job History

Sometimes the tool times out when trying to delete job history on Microsoft SQL Server.

Solution

  1. click on job
  2. Click on “export to excel”
  3. in the popup, select the GUID (the part after the DB name)
  4. 108 more words
SharePoint

@@ROWCOUNT Strikes Again

Just when I thought I’d been thwarted the last time by @@ROWCOUNT, along comes this gem:

begin try
select top 10 * from sys.objects;
end try… 35 more words

YC Alum PipelineDB Releases Open Source Streaming SQL Database

PipelineDB, a Y Combinator Winter 2014 graduate, announced the availability of the open source version of its streaming SQL database product today. A commercial version is expected later this year. 447 more words

TC

Tana Daily Telegraph reblogged this on Tana Daily Telegraph and commented:

"...The typical use case for this product involves reporting and analytics and real-time monitoring,..." - original author

YC Alum PipelineDB Releases Open Source Streaming SQL Database

PipelineDB, a Y Combinator Winter 2014 graduate, announced the availability of the open source version of its streaming SQL database product today. A commercial version is expected later this year. 447 more words

TC