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,492 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,156 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,529 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,739 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,749 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,320 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,479 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,547 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,743 reads
Blogs
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers