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,185 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,185 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)
15,032 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,431 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,665 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,693 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,299 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,465 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,529 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,733 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers