2021-09-08
822 reads
SQL Server 2014
SQL Server Data Table as CRM Data Source on VBA Form
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,651 reads
SQL Server 2014 Service Pack 2 is Available
SP2 for SQL Server 2014 is now out. Check out the build list.
2016-07-12
5,445 reads
CU#6 for SQL Server 2014 SP1 Updated
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,219 reads
In-Memory OLTP Table Checkpoint Processes Performance Comparison
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,941 reads
Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
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
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.
2015-10-16
2,930 reads
SQL Server 2014 and Windows Azure Blob Storage Service: Better Together
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 SQL databases on Azure Blob storage
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,227 reads
Blogs
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
PASS Data Community Summit 2025 Recap
By alevyinroc
This is long overdue but life and distractions happened. It’s been a little over...
Forums
Adding and Dropping Columns II
Comments posted to this topic are about the item Adding and Dropping Columns II
Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform
Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads:...
More Documentation is Needed
Comments posted to this topic are about the item More Documentation is Needed
Question of the Day
Adding and Dropping Columns II
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) , [Country2] [char] (3), [stateprovince2] [char] (2), [Country] [char] (3), [stateprovince] [char] ) ON [PRIMARY] GOI decide to drop the stateprovince2 and country2 columns. What code should I use? See possible answers
