Update the Statistics on Recently Modified Tables Only
(April 1, 2010)
Why are you using sp_ as a naming convention for stored proc's when it is best practice not to. And Grant Fitchly( aka Scary DBA ) in his book 'SQL 2008 Performance tuning distilled' shows the...
Seven Tips for SQL Server Production DBAs
(July 15, 2009)
Just a question as to what you would do if your policy is to remove the builtin admin account after a SQL install is done then this will not work. Also I have always thought that buildin admin...
As far as I'm concerned we'll likely always have SQL Injection around to haunt us. Even though this attack vector has been well-publicized and well-documented for well over a decade (and then some), failure to account for it continues to pop all the time—even in catastrophic places....More