How the New Database Security Law Affects YouCommented on: 4 years ago
(June 24, 2010)
You very briefly touched on it above but I think a good topic for a future article would be to get specific about HOW sql server can be used to comply with the new law. Walk us through how sql...
Performance Secrets for SQL Server DevelopersCommented on: 5 years ago
(May 8, 2009)
I've always declared cursors in a way similar to the example in point #7, but I've not been including READ_ONLY because I've been under the impression that FAST_FORWARD already creates a read only...
Can the Transaction Log Tell Us What Happened?Commented on: 6 years ago
(August 21, 2008)
Berating people for demanding Microsoft’s “proprietary information” was the wrong way to start this article. A user being suspected of doing something they shouldn’t have is a fact of life and a...
The Logical Puzzle - 29 Apr 2008Commented on: 6 years ago
(May 9, 2008)
Here's what I think is interesting. What if you repeated the experiment on Jupiter? Pretend Jupiter has a solid surface and the cat has a space suit.
Despite similar intentions and high-level goals, the ways in which AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups tackle high availability and disaster recovery are quite different....More
While AlwaysOn Availability Groups are a powerful solution that let DBAs tackle both high availability and some disaster recovery concerns from within a single, unified, set of technologies and tooling, AlwaysOn Availability Groups also come with a number of challenges....More
For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More