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-19 (first published: 2015-11-17)
3,955 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)
14,417 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,155 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,164 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,328 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,280 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,269 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,449 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,522 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,729 reads
Blogs
Abuse, Patience, and Understanding
By Steve Jones
I’ve been struggling with an author for a few months. I tried to work...
Daily Coping 21 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SSIS Logging – Linking sysssislog with custom log
I was working on an ETL solution, which was expected to run for hours....
Forums
cumulative updates in multi instance standalone server
For 2019, how would one go about applying CU on multiple instances in a...
Powershell String was not recognized as a valid DateTime
Hello experts, I'm trying to import some CSV data into a SQL database using...
connecting to SQL Database from asp application and setting CONTEXT_INFO
connecting to SQL Database from asp application and setting CONTEXT_INFO. <connectionStrings> <add name="CLHN_AppConnectionString" connectionString="Data...
Ask SSC