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
24 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,285 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,849 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,298 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
659 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
758 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,037 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
2,009 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,757 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,042 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers