SQL Server 2014 Memory Optimization Advisor
The new SQL Server 2014 “Memory Optimization Advisor” tool helps you quickly analyze tables to see how easy it is to migrate them to In-Memory OLTP tables. Read on to learn more.
2014-01-15
2,292 reads
SQL Server 2014
2013-12-30
1,508 reads
2013-12-06
1,912 reads
2013-11-19
1,519 reads
SQL Server 2014 CTP 2 is available
Download the latest preview of the the next SQL Server version for testing.
2013-10-18
4,775 reads
2013-10-04
2,386 reads
Installing SQL Server 2014 CTP1
If you are interested in learning firsthand what new features are available, then you should download and install the new SQL Server bits. In this article Greg Larsen will walk you through preparing, downloading and the steps to install the SQL Server 2014 CTP1 release.
2013-09-18
2,741 reads
Improved Application Availability During Online Operations in SQL Server 2014
SQL Server 2014 introduces enhancements to two common database maintenance operations namely Partition Switching and Online Index Rebuild which greatly increases enterprise application availability by reducing maintenance downtime impact.
2013-09-13
3,371 reads
What’s New with SQL Server 2014
In this article Greg Larson outlines the exciting new features that come along with SQL Server 2014. He'll also let you know where you can download CTP1, as well as where you can find additional resources related to SQL Server 2014.
2013-08-14
4,381 reads
AlwaysOn in SQL Server 2014 CTP1
AlwaysOn encompasses the SQL Server solutions for mission-critical high availability and disaster recovery. Two solutions were included under the AlwaysOn umbrella in SQL Server 2012: Availability Groups and Failover Cluster Instances. Each solution has different characteristics, making them appropriate for different scenarios, and both can be combined in the same deployment.
2013-07-25
2,810 reads
Blogs
Ways to land data into Fabric OneLake
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
A Very Cool Benefit in SSMS 21
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
AI Helping with an API
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
Forums
The New Log File
Comments posted to this topic are about the item The New Log File
Getting Started with the Data API Builder
Comments posted to this topic are about the item Getting Started with the Data...
The AI/Human Spectrum
Comments posted to this topic are about the item The AI/Human Spectrum
Question of the Day
The New Log File
I have a detached database from SQL Server 2019, called TDE_Primer. This database had a 100MB data file and a 73MB log file. The log file was lost, so I need to run this code:
USE [master] GO CREATE DATABASE [TDE_Primer] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\TDE_Primer.mdf' ) FOR ATTACH_REBUILD_LOG GOHow big is the new log file? See possible answers