How the New Database Security Law Affects YouCommented on: 3 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: 4 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: 5 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: 5 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.
Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....More