2021-09-08
817 reads
2021-09-08
817 reads
Using SQL SERVER Database as Data Source
FOR MS Access VBA Switchboard and Data Entry Form. I am presenting, once again, a method of connecting and upgrading a SQL data source into a VBA presentation process.
2018-08-06
1,630 reads
SP2 for SQL Server 2014 is now out. Check out the build list.
2016-07-12
5,445 reads
Please re-apply CU#6 for SQL Server 2014 SP1 as it has been updated.
2016-06-01
6,727 reads
2015-11-11
1,217 reads
The article demonstrates one of the major performance enhancements in checkpoint processes in "in memory tables"
2018-10-05 (first published: 2015-10-27)
3,928 reads
This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot plan-quality regressions if and when they occur.
2015-10-19
4,120 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
This technical article will cover in depth SQL Server 2014 Data Files on Azure Blob storage service, starting from step-by-step configuration
2015-10-13
2,489 reads
Creating a database in SQL Server running in on-premises with a dedicated storage location for your data in Windows Azure Blob Storage.
2015-09-17
4,215 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Hi, our peer who owns a remote mysql server from which we extract warehouse...
What is returned as a result set when I run this command without a new seed value?
See possible answers