Archives: May 2014
A recent discussion got me to thinking about Auditing. To be honest, it got started with a complaint about some documentation that seemed overly light about the various fields related to auditing as it stands in SQL Server.
In talking to the person who raised the valid concern about the… Read more
Reading that title, you might sit and wonder why you would ever want to partition a temporary table. I too would wonder the same thing. That withstanding, it is an interesting question that I wanted to investigate.
The investigation started with a fairly innocuous venture into showing some features that… Read more
It has been well documented and is well known that SQL Server supports certain older versions of SQL Server in a compatibility mode. This setting is something that can be configured on the database properties level. You can quickly change to an older compatibility level or revert the change to… Read more
Frequently we hear the analogy that <insert item here> is like opinions, everybody has one and not all of them are good (some may stink).
Well, this may just be another one of those <items>. Whether it stinks or not may depend on your mileage.
This is a pretty interesting topic from a few different angles. Boris proposed a few topics such as… Read more
Imagine my surprise when reading the email and discovering that I was presenting.
Here are the guts of that email.
Can you believe that it’s…