Setting permissions on a database mirror database snapshotCommented on: 2 years ago
(March 13, 2012)
One caveat to remember is that if they have access to the principal server through another login, they will get the permissions of that user in the database even though they are accessing via a...
Vendor-mandated regular database shrinkingCommented on: 2 years ago
(December 1, 2011)
One of my [least] favorite arguments is, "I read on a blog post that it's not that bad." This was actually in regards to using clustered nonsequential GUIDs on all tables, but I still...
Hardening SQL ServerCommented on: 2 years ago
(September 15, 2011)
Hi dbird, thanks for the comment! Definitely, the older it the SQL Server version, the harder it is to add different components. This is an area where the SQL team have made pretty good improvements.
Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More