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,535 reads
Roy Ernest
What, when and who? Auditing 101 - Part 3
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)
15,173 reads
What, when and who? Auditing 101 - Part 2
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,541 reads
What, When and who? Auditing 101
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,750 reads
The Ins and outs of In-Memory OLTP
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,759 reads
SQL Saturday # 103 in Curacao a Success
On 25th of February 2012, Curacao hosted its first SQL Saturday event. The event was held at the University of...
2012-03-01
2,321 reads
Ready for the new year?
The New Year is just around the corner. Every year I make a resolution. And every time I fail. That...
2011-12-29
2,286 reads
Junior DBA
At our company we have two DBAs to take care of all the databases in the production and QA. It...
2011-12-08
1,483 reads
It was a pleasure to work with the NomCom
With the announcement of the official slate for the BoD election for this year, the job of the NomCom is...
2011-11-30
2,548 reads
SQL Pass Update - Day 1
So far SQL Pass Summit has been great for me. I have had a great time from day one onwards....
2011-10-12
1,744 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Alamat kantor BCA KCP Renon Telp:08218154398
WhatsApp:0821-8154-398 Jl. Raya Puputan No.10, Panjer, Denpasar Selatan, Kota Denpasar, Bali 80226
Alamat kantor BCA KCP Bantul Telp (0817)-866887
Wa:0817-866-887 JL. JENDRAL SUDIRMAN NO. 18A RT.007 RW.000, BANTUL WARUNG, DESA. KEL. BANTUL, KEC....
ALAMAT KONTAK BCA KCP Blok M Telp:08218154393
WA:08218154393 Jl. Melawai Raya No.3, RT.3/RW.1, Melawai, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers