Idle Connection Resiliency
Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.
2018-06-18
2,632 reads
Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.
2018-06-18
2,632 reads
TDS remoting services provide a native SQL experience with local and remote ODBC data sources (contrast with limitations of using OLE DB).
2017-08-28
2,733 reads
ODBC is the closest thing we have to a universal standard for data access across platforms, applications and data sources. So why doesn't DocumentDB support it?
2016-11-07
99 reads
Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.
2015-10-16
2,930 reads
Use the TDS Remoting feature of the ODBC Driver to set up a linked server for Salesforce data.
2018-07-27 (first published: 2015-08-18)
7,101 reads
With ODBC, you can summarise, and select just the data you need, in an Excel workbook before importing it into SQL Server. You can join data from different areas or worksheets. You can even get data from the result of a SQL Server SELECT statement into an Excel spreadsheet. Phil Factor shows how, and warns of some of the pitfalls.
2013-09-05
4,816 reads
Phil Factor reflects on Microsoft's "handbrake turn" on OLE DB; Denali's successor will have to have all this plumbing ripped out to replace it with the older ODBC technology. It's a surprising move but makes a lot of sense, given the ubiquity of ODBC drivers for relational data access.
2011-09-12
275 reads
The Microsoft SQL Server Connectivity team has a survey on the need for ODBC support for other platforms. If you use SQL Server from other platforms, let them know.
2010-03-04 (first published: 2010-02-25)
1,936 reads
I want to have an Audit Table update any Inserts, Deletes or Updates. This is what I have presently,--INSERT INTO AUDITLOG new USERS IF EXISTS (SELECT * from sysobjects where name = 'trg_USER_I' and xtype = 'TR') drop trigger trg_USER_I go CREATE TRIGGER trg_USER_I on USERS for Insert as if update ([name]) insert AUDITLOG ( […]
2005-04-11
I think you did cover everything. But something you might want to look at is any locking/blocking in the databases. This will give you a good idea about the health of the system.
2005-02-14
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers