2021-09-08
753 reads
2021-09-08
753 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,525 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,206 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,840 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,011 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers