How HADR_SYNC_COMMIT waits can wreak havoc
It has been a decade since I have blogged. Or at least it feels like it. Today I would like...
2015-11-25 (first published: 2015-11-17)
4,037 reads
It has been a decade since I have blogged. Or at least it feels like it. Today I would like...
2015-11-25 (first published: 2015-11-17)
4,037 reads
Who messed around with my database? Auditing 101. In this article we will take a look at another technique available in SQL 2008 and higher. This new technique is SQL Audit.
2014-12-19 (first published: 2012-05-31)
14,882 reads
In my previous article we discussed Change Tracking which is one of the new technologies introduced by Microsoft. This article will focus on Change Data Capture.
2014-12-12 (first published: 2012-01-16)
13,329 reads
In this article we will take a look at one of the new technology that was introduced in SQL Server 2008 for Auditing.
2014-12-05 (first published: 2011-11-28)
16,542 reads
As you may know, SQL Server is a very robust database, but SQL server has its performance bottlenecks. With the introduction of In-Line memory OLTP, there is a chance to get rid of the performance bottlenecks
2014-09-16
6,550 reads
On 25th of February 2012, Curacao hosted its first SQL Saturday event. The event was held at the University of...
2012-03-01
2,294 reads
The New Year is just around the corner. Every year I make a resolution. And every time I fail. That...
2011-12-29
2,274 reads
At our company we have two DBAs to take care of all the databases in the production and QA. It...
2011-12-08
1,460 reads
With the announcement of the official slate for the BoD election for this year, the job of the NomCom is...
2011-11-30
2,526 reads
So far SQL Pass Summit has been great for me. I have had a great time from day one onwards....
2011-10-12
1,731 reads
In this post we're going to go through the steps to set up Always...
I’ve been using Azure SQL Database for quite some while and have set up...
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
The table InventDim has some indexes, we create one index idx1 which has index...