SQL Server 2014: protection against Database Administrator
Such a topic related to SQL Server 2014 CTP1 may seem a bit strange, but it was chosen not randomly. The questions like “How can I protect my data...
2015-09-10
13 reads
Forrards Group Database Blog
SQL Server 2014: parallel execution of SELECT INTO statements
In Microsoft SQL Server 2014 new in-memory options are presented. One of them is online transaction processing (OLTP) that complementing...
2015-09-18 (first published: 2015-09-09)
3,273 reads
Buffer Pool Extension in SQL Server 2014 part 4: benchmark testing for update operations
One of my previous articles was devoted to carrying out a range of tests to compare speed of data read...
2015-09-10 (first published: 2015-09-04)
1,824 reads
SQL Server 2014 Buffer Pool Extension part 3: system monitoring
In this article I’d like to tell about monitoring tools available in SQL Server 2014 to evaluate the performance of...
2015-09-03
1,289 reads
Monitoring of free space in database files
Monitoring of the size of database files is one of the important DBA tasks and this process should be automated....
2015-09-02
637 reads
CONTEXT_INFO and efficient mass update on a large table with a trigger
Let`s assume we have following task – make changes to the data in a large table that has consistency checker in...
2015-09-01
746 reads
Buffer Pool Extension in SQL Server 2014 part 2: benchmark testing
Let’s take a closer look at how we can speed up the system’s performance using the Buffer Pool Extension. For...
2015-08-31
2,010 reads
Data corruption in SQL Server 2012 and 2014 when rebuilding indexes online
When I hear the discussion about causes of data corruption in SQL Server, I always mention bugs in the operating...
2015-08-17
1,995 reads
Buffer Pool Extension in SQL Server 2014
I guess many have heard the phrase «640K ought to be enough for anybody», which Bill Gates is mistakenly thought...
2015-08-17
1,740 reads
System databases maintenance in SQL Server
Let’s talk about maintenance of system databases in MS SQL Server. There are a few differences from user databases.
At first let`s remember...
2015-08-12
2,022 reads
Blogs
Advice I Like: Art
By Steve Jones
Superheroes and saints never make art. Only imperfect beings can make art because art...
Why Optimize CPU for RDS SQL Server is a game changer
One feature that I have been waiting for years! The new announcement around optimize...
Performance tuning KubeVirt for SQL Server
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
Forums
Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL
Comments posted to this topic are about the item Think LSNs Are Unique? Think...
The AI Bubble and the Weak Foundation Beam
Comments posted to this topic are about the item The AI Bubble and the...
Question of the Day
A Big PK
In SQL Server 2025, how many columns can be included in a Primary Key constraint?
See possible answers