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.
In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More
Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a SQL Server. On most servers that I manage, I typically deploy a whole bevy of different alerts....More